Sage 100

 View Only
  • 1.  On the inventory reorder report run with usage det

    Posted 10-18-2018 08:44
    On the inventory reorder report run with usage detail what is the difference between Recom. Order and Purchase Quantity?


  • 2.  RE: On the inventory reorder report run with usage det

    Posted 10-18-2018 09:27
    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


  • 3.  RE: On the inventory reorder report run with usage det

    Posted 10-20-2018 06:51
    Thanks Brett, I was able to determine the difference is that the Recom. Order is units at the Standard Unit of Measure and the Purchase Quantity is in units converted to the Purchase Unit of Measure