Recalculate Order Quantities

Use the Recalculate Order Quantities function to determine which items to reorder and in which quantities based on the order quantities information entered in the Inventory Items function on the Location tab as well as manufacturing/production information. Before you begin reorder processing, make sure you set up and verify forecast type IDs, assign forecast types to IN item locations, and set up the order quantity amounts for IN item locations. The Recalculate Order Quantities does not generate requisitions.

  1. Use the Data Filter to select the range of filtering options or leave the filter blank to include all available data.
  2. Select the Transfers Out check box, if applicable, to include transfers out in the annual usage calculation.
  3. Select the Material Requisitions check box, if applicable, to include material requisitions in the annual usage calculation.
  4. Select whether to calculate the Quantity On Hand or the Quantity Available from the Calculate Quantity section.
  5. Select the Include Quantity On Order check box, if applicable, to determine the reorder quantity.
  6. Select the Remove All calculations and Start Over check box , if applicable, to delete all reorder calculations and start the calculation process over.
    Note: This check box only appears if you have calculated reorders once and have not generated transactions.
  7. Select the Replace Overlapping Calculations check box, if applicable, to recalculate reorders and only include those that now have a different calculation from the original calculation.
    Note: This check box only appears if you have calculated reorders once and have not generated transactions.
  8. Select a calculation method from the Calculation Method field.
  9. Select To Generate Purchase Requisitions For
    EOQ Items that are at or below their EOQ (economical order quantity).
    Forecast Items with forecast types that are at or below their forecasted quantities.
    Min/Max Items whose quantities are at or below their minimum amount.
    Least Quantity The least quantity of items. The system chooses which method to use.
    Greatest Quantity The largest quantity of items. The system chooses which method to use.
  10. Enter a comment, if applicable, in the Comments field.
    Note: The comments appear in the Activity Log after you Generate the requisitions.
  11. Click a command button to

  12. Click To
    Calculate Calculate reorders and populate the data grid.
    Activity Display the Activity Log to view reorder processing activity.
    Reset Set all fields to their default values.
    Select All Select all reorder records.
    Unselect All Unselect all reorder records.
    Generate Generate requisitions. The data grid is repopulated after generation is complete and selected reorder records are removed.

The Notes field in the results grid may hold a code, defined as follows:

Code Definition
HM: History Missing One or more months of summary history are missing in the last year. Summary sales history is used to produce the forecast used to calculate EOQ.
FM: Forecast Missing The item is not assigned to a Forecast Type.
FQ: Frozen Order Quantity The EOQ Status field is set to Frozen.