Purchase Order - Auto Order By Sales, and the calculations used for quantity to order.
Settings which give further control over the Auto Order of Products are found in Admin / Defaults / Manage Supplier Defaults > Orders
If the “Select Products set to Preferred Supplier for Auto Order” setting is ticked, then the software will always assume that an Auto-Order is only to select products that have the nominated Supplier as their ‘Preferred Supplier'. If this is not ticked then the software will select any products that can be supplied by the nominated Supplier.
The “Use EOQ for purchase order auto-orders” setting is to be used in conjunction with the Auto-Order – based on Min/Max.
The Auto Order – Sales buttons allow the creation of a Purchase Order for all Product that can be bought from the selected Supplier. The order will be calculated based on the qty sold over the entered date range.
You can select to calculate your order based on yearly sales or a 30, 60 or 90 day option.
The Auto Order – Sales screen displays the Product Code, Description, Bin Location along with the Landed Cost, Freight Cost, Latest Cost, the product Ratio, EOQ, Min and Max Product Holdings.
The On hand, On order, On Saved, Back Order and Allocated are then displayed.
The next section then displays the Sold Value, Quantity Sold and Sales over Last 30 Days, Last 60 Days and Last 90 Days.
This is then followed by the monthly average and the lead time for this product line.
The system will then produce a figure which it considers is the recommended quantities to order.
You can amend the quantity to order by changing the to order value.
The Top Right of the screen will display the Total Weight, Volume and Value of the order - information which is useful for managing shipping container loads of product ordered.
In this example we have used Last 30 Days for analysing reorder quantities.
The To Order is calculated from the Last 30 Days less On Hand.
The Purchase Order Manual found under the Help menu from within the software will give additional information.