Search Site     
HOME >> TIP OF THE MONTH     
Back Office
Home Office
Central Price Book
POS Interfaces
Hand-held Scanning
EDI Conversion
Fuel Distribution
Work Orders/ALLDATA
Work Orders/Mitchell 1
Sunray - ASP
Digital Dispatch
Training
Support
System Administration
POS Conversion
General Information
Employment
Sales
Support
Tip of the Month
Press Releases
Product Versions
Trade Shows
Tip of the Month

Reorder Quantities Based on Sales History

Tip

Replenishing inventory by reordering items with purchase quantities based on past quantities sold.

On the Reports menu, click Inventory > Reorder.  In the Reorder Type box, select Sales History.

Select the sales history period you want to use as a basis for replenishing your inventory.  In the Beginning History Date box, select a beginning date for the desired date range.  In the Ending History Date box, select the ending date for the desired date range.  In the Reorder Days Supply box, type the number of days for which you are reordering.

For example, if you select a date range for a specific week and specify a Reorder Days Supply of 14, if an item was sold once per day during the selected week, the report will suggest an order of 14 items (assuming that the minimum purchase quantity for that item is also 1).

In the Current Vendor ID box, select the vendor for the reorder.

If you want to hand this Reorder report to the vendor, click Print.

If you want to send this Reorder report electronically to your EDI vendor, click Create Purchase Order. Once the system creates the purchase order (it displays a message telling you that it has), on the Daily Work menu, select Purchases/Payables and display the paidout that corresponds to the reorder. The paidout will display "CAO" as a prefix in the Invoice # box (for example, CAO12334).

Click CAO Trans > Create Order. You may be prompted to view the order. After you close the order display, click Send Order. Close the Transmission window when finished.

Please submit your ideas for Tip of the Month

Do you have a question, comment, or idea for Tip of the Month? Please complete this quick web form and we might use your submission for future updates!

Past Tips of the Month...

July 2006: How to Reconcile Inventory

June 2006: How to Reconcile Inventory After a Promotion...

May 2006: Reordering the Correct Number of Items

Home  |  About Us  |  Products  |  Services  |  What's New?  |  Contact Us