This may help, from the KB:
How is the Purchase Quantity calculated on the Inventory Reorder Report?
Products
Sage 100
Description
How is the Purchase Quantity calculated on the Inventory Reorder Report?
Resolution
The reorder method is used to generate a recommended reorder quantity (Purchase Quantity) on the Inventory Reorder Report.
The recommended reorder quantity (Purchase Quantity) is based on the actual quantity available (the on-hand quantity increased or decreased by the quantity on sales order, on purchase order, on work order, and required for work orders, and on back order) and your entries in the Economic Qty, Reorder Point Qty, Min Order Qty, and Max On Hand Qty fields. This field is available only for the default warehouse if the Require Multiple Warehouses check box is selected and the Reorder by Warehouse check box is cleared in Inventory Management Options.
Economic Qty
Type the number of the most economical order quantity for this item, or click the Calculator button to enter an amount using the calculator. This amount is the quantity normally reordered when the available stock falls to or below the reorder point. This field is available only for the default warehouse if the Require Multiple Warehouses check box is selected and the Reorder by Warehouse check box is cleared in Inventory Management Options.
Reorder Point Qty
Type the minimum available quantity at which to reorder this item, or click the Calculator button to enter an amount using the calculator. As an aid to purchasing, you can print a report showing every item for which the available quantity is at or below its reorder point. This field is available only for the default warehouse if the Require Multiple Warehouses check box is selected and the Reorder by Warehouse check box is cleared in Inventory Management Options.
Min Order Qty
Type the minimum quantity to reorder at one time, or click the Calculator button to enter an amount using the calculator. If a minimum order quantity is entered, the recommended reorder quantity is never less than the minimum order quantity, regardless of the reorder method. This field is available only for the default warehouse if the Require Multiple Warehouses check box is selected and the Reorder by Warehouse check box is cleared in Inventory Management Options.
Max On Hand Qty
If Maximum Stock Level is selected in the Reorder Method field, type the maximum level for this item, or click the Calculator button to enter an amount using the calculator. You must type an amount that is as large as, or larger than, the amount entered in the Reorder Point Qty field plus the smallest order quantity you would ever order.
If Economic Quantity or Reorder Point is selected in the Reorder Method field, type a quantity that will print on the Inventory Reorder Report. This field is available only for the default warehouse if the Require Multiple Warehouses check box is selected and the Reorder by Warehouse check box is cleared in Inventory Management Options.
Related resources
How to set up reorder points in Inventory Maintenance
What Information is on the Inventory Reorder Report?
Additional information
When printing the Inventory Reorder Report with ""Print Usage Details"" checked, the quantity sold will print for PTD/YTD/PYR. This quantity is only what was sold and does not contain quantity returned.
To locate the quantity sold in Item Maintenance/Inquiry, go to the History Tab and check the Sales radio button. This will reflect the Qty Sold which prints on the Inventory Reorder Report.
Category
Calculations
payroll calculation, check runs, payment calculation, and depreciation
Processing
Entitlement
Open
ID:79959Last modified:12-1-2016