Defining the Maximum Days Supply for Buy Lines

Use the Maximum Days Supply screen to define the maximum number of days supply of a product that your company allows to be stocked in the warehouse. The system uses the following calculation:

Max Days Supply = product's projected inventory level (PIL) / demand per day.

Maximum Days Supply is defined at three levels:

System – Applies to all products, unless overridden at the buy line level. The Maximum Days Supply control maintenance record defines the default maximum days supply for each branch at this level.
Buy Line – Applies to all products assigned to the designated buy line and overrides the system default.
Product – Applies to the designated product and overrides the buy line and system defaults. The maximum days supply checking logic does not apply to "Misc Charge" products.

When an item is added to an order, the system checks the Projected Inventory Level (PIL). If the days supply number is exceeded during order entry, the system displays a warning.

If you have been assigned the appropriate PIL override authorization key, the message displays a Continue (Y/N) prompt.
If you do not have the appropriate authorization, the message prompts you to enter the password of another user who is authorized to override the maximum days supply limit.

If an item is removed, or an order deleted, the system compares the PIL at the time of the removal or deletion to the stored PIL. If the removal or deletion does not make the PIL higher than it was at the time of the addition, no Maximum Days Supply warning displays.

Note: The PIL calculation does not include exceptional purchase orders or purchase orders that have a date past the plenty date.

To define the maximum days supply for a buy line:

From the Purch > Maintenance menu, select Buy Line Maintenance to display the Buy Line Maintenance screen.
Use the Hits/Max Days hot key to display the Maximum Days Supply screen.
For each branch, enter the maximum number of days supply of a product in this buy line that your company allows to be stocked in the warehouse via adjustments, purchase order entry, sales order entry, or transfer order entry.
Press Esc to commit the changes.