Processing a Min Max Update Run

Overview

If you are using min/max purchase runs, you should be running min/max update runs about every 3 months to refreshen up and review your min/max reorder levels.

Min/Max update runs help you by automating updates to Min/Max levels for product sites.
You can review and adjust the suggested new min/max levels before you update each one.
The system color codes suggestions to tell you which min/max levels need to be used.
Min/Max levels on product sites can be used in purchase runs.


This is not related to min/max levels on product locations, which are used for internal stock location transfers.

Procedure

  1. In the navigation panel, go to Inventory then Min/ Max Update Runs
  2. Click New. The New Bulk Update Run window displays. 

  3. Enter a Name for the Min/Max Update Runs
  4. Click on Extract Products a button from the ribbon line. Extract Min/Max Update Run window appears.

     Show me

  5. Select a Min Max Update Run Set

  6. Enter a Start and End Date For Sales
  7. You can filter by Supplier, Products, or Site. 
  8. Click on OK

     Show me

  9. Review the lines on the min/max update run. You can change or delete any lines on the run
  10. The lines on the min/max run are color-coded:
    1. Green lines are ok, the variance between your current min/max and the suggested min/max is small
    2. Yellow lines need review, the variance between your current min/max and the suggested min/max is fairly large
    3. Red lines definitely need review, the variance between your current min/max and the suggested min/max is very large. This would result in a material change to your purchasing for the product

  11. If you have any questions about how the result was calculated. Please read the message shown below each line. The message explains how the result was calculated. The message is intended to be similar to the message on purchase runs where average weekly sales are used. As the min/max run uses the same kind of calculations as the average weekly sale purchase run. If you have trouble understanding the message, consider talking to your purchasing officer. They may be familiar with the messages in the contacts of purchase runs.
 Show me..

  1. Once you are happy with the min/max levels shown. Click on Finalize to post the min-max run

To exclude product from the min/ max runs there is a check box on the products page > Settings > Excl from Min/ Max Upd Run