|ALERE: News & Tips for ALERE UsersPSSI has been implementing ALERE accounting and manufacturing software for over 25 years, and we still think it’s one of the best-priced, best-functioning manufacturing software products you can buy anywhere. Users appreciate ALERE’s flexibility over many other systems.
This month TIW Technology President Rod Hatcher shows how to perform ‘drop shipments’ in ALERE, and how to export your data to an Excel worksheet.
Drop Shipments with ALERE
A drop shipment takes place when a company takes the title of the product but does not actually handle, stock, or deliver it to the customer. Instead, the supplier receives instructions to ship directly to the company’s customer. In ALERE, sales orders handle drop shipments.
There are four, possibly five, items to be addressed when preparing to handle drop shipments.
- In inventory on the Item tab screen check the item attribute Drop Ship check box for any items that can be dropped shipped.
- At a minimum, also check the Purchase and Sellable boxes.
- Assign a location to use as a default for the item on the inventory Location tab.
- Add any suppliers that can handle a drop shipment for the item on the Supplier tab.
- If a company uses permissions to create accepted drop ship purchase orders, then assign them the appropriate permission. The permission type is PFAO.
Use the Line Items tab on a sales order to enter orders for drop ship items. This permits the Ship ID and Ship Locn of the supplier fulfilling the drop ship order to be designated. Items being drop shipped are labeled, clearly in red, as illustrated on the screen below.
Start by entering the account from which the funds will be taken. Choose the Transfer (circled in red) radio button and enter a reference and an amount. The GL Journal Entry screen is displayed when the Post button is clicked.
A purchase order for the item can be created and automatically emailed to the supplier when it is released on the sales order. The purchase order contains the customer shipping address.
Even though drop ship items do not move through inventory, their activity is captured. They will show up on the Log of Activity and Future Activity screens and on any usage and analysis reports. General ledger postings for drop shipments will be made to accommodate the slightly different path than standard sales items because no physical inventory moves through the company. Other accounts, such as sales discounts and shipping, are added in the normal fashion.
Exporting to Excel from ALERE
Often there is the desire to take the information generated by an ALERE report and perform further calculations on it. Sometimes a certain format is required by a company to meet special report requirements. Then, there are the occasions when data from different reports or sources need to be combined for the information to be visible. Since the most common vehicle for these various requirements is Excel, all of the reports in ALERE have an Export button to convert into to Excel.
The Export button will create a spreadsheet, in XLS or XLXS file type, which can be opened and edited in Microsoft Excel. It is automatically compatible with the 64-bit version of Excel. The information will be exported even if Excel is not installed on the workstation. The file automatically names and stores in a default location. However, both can be changed to allow full control over what to call the file and where to store it.
When exporting a report the formatting and grouping are not exported. Any calculations made by the report will therefore not be present. This method of exporting is followed because it allows the data to be manipulated. If the report were to be exported in a formatted manner, as is done when the report is printed, the data would be all placed into one cell on the spreadsheet and the ability to edit it would be lost. Having the ability to export any report to Excel greatly enhances report functionality.
Questions about Excel exports? Just call us!
Want to Learn More About ALERE?
TIW has a 7 minute “Manufacturing Overview Video“ on YouTube that gives a concise summary of what manufacturing software can do for you. Click the link below to see why ALERE may be a great fit for your manufacturing operations.
- Interested in a trial version for your organization?
PSSI can work with you to understand better what a manufacturing software system can do for you. For information on obtaining a trial version, contact Larry Lukasik at the number below.
To learn more, call us any time at 877.273.2444, or visit us on the web.