Update MIN/MAX Records
Modified on Mon, 30 Apr 2018 12:17 by J Denniston — Categorized as: Procurement
Table of Contents
[
Hide/Show
]
General Information
Fields/Filters
General Information
¶
Default Menu Location
Transaction >> Procurement >> Update Min/Max Records
Screen Name
UPDATEMINMAX
Function
Use this screen to update your items' min/max and reorder point quantities based on usage.
Fields/Filters
¶
Use Days of History
Number of past days of item history to factor in.
Set Order Qty to X Days of Inventory
Update items to have an Order Qty for a specified number of future days. Select the box to update this field.
Set MinQty to X Days of Inventory
Update items to have a Min Qty for a specified number of future days. Select the box to update this field.
Set MaxQty to X Days of Inventory
Update items to have a Max Qty for a specified number of future days. Select the box to update this field.
The following filters represent item attributes that must exist on the item where the filter should apply.
The option in the screen to Include represents AND, so if you check manual and long, the item has to have both attributes to be included. The option to Exclude represents OR, so if you check manual and long, both manual and long will be excluded.
Manual Setpoint Items
Only updates items with the MANUPDATE item attribute.
AutoSet Items
Only updates items with the AUUPDATE item attribute.
LongLead Items
Only updates items with the LLUPDATE item attribute.
Whse
The option to only update an individual warehouse.
Commodity Code
This option will only update items containing the selected Commodity Code.
Export Only
Select to export the results to an Excel file for review.