Reorder Calculation

When you click the Calculate button, Greentree applies this logic:

1. Remove any old reorder data if the same run is processed before.
2. Loop through items and process each with steps below:
   1. Select the item depending on:
      • Item is in the range entered into the reorder run parameters
      • Item is active
      • Item is not non-diminishing
      • Item status allows purchases
      • Item has an analysis code as per the analysis code range entered into the reorder run parameters
      • Item is for a location that falls into the warehouse/location range entered into the reorder run parameters.
   2. Check whether the item is superceded (where the Supercessions module is in use). If it has, exclude it from the process.
   3. Search supplier details to find an item/location (if applicable) match, so that specific supplier details can be used. Check to see if there is a preferred supplier which is applicable if you select the Preferred Supplier Only option as a reorder run parameter.
   4. Search item reorder details to get the minimum, maximum, EOQ, shipping method and lead time values. The lead time and shipping method may be superceded by that (previously) obtained from the supplier details. If no reorder details exist for an item, it will be excluded from the process.

      A reorder quantity will be suggested for an item if the potential quantity (calculated as on-hand + future quantity + quantity on order - quantity committed to orders - quantity on backorder) drops below a certain level, which depends on the reorder type of the item:

      • Minimum/Maximum
      • Forecast
      • No reorder required

Suggested reorder quantities are adjusted using the EOQ factor assigned in Supplier Maintenance, if specified (quantities rounded up to EOQ multiple).

• Reorder Details Maintenance