Exceptions

From this screen, the user can set up some Replenishment exceptions. What ever will be set up on this screen will override what is set up in the Vendor Maintenance under the Automatic Replenishment section.

Warehouse: The exceptions can be system wide (if ALL warehouses is selected) or can be personalized by Warehouse. The user will need to defined how he wants to manage his exceptions by selecting from the drop down menu.

The exceptions can either be created by Category (upper part of the screen) and or by Product (lower part of the screen). If an exceptions is created for a category and another exceptions is created for a specific product that was already included in the category - the exception by product will always override the exceptions per category. The system will always apply first the most specific exceptions. 

To be able to add an exception, the user just need to click on ADD either from the Category section or the Product section. Then the user will manually type in the item or the category, or press F1 to open the search window.

Type of exceptions

Week: This field will override the Weeks of Sales set up in the Vendor Maintenance under the Automatic Replenishment section. The Replenishment analysis is usually run by vendor, and the set up will be done for all items that are order from this vendor on the Vendor Maintenance.

Under that field, the user will define how many weeks of sale the Replenishment report should take in consideration for this specified category or item.

I.E: The user is running a replenishment analysis for vendor ABC ltd. The replenishment report will be run be using the Weeks of Sales set up in the Vendor Maintenance. Typically, each time an item from in the store is set up with vendor ABC ltd as a main vendor from the Cross-Index tab of the Inventory Item - the system will auto-generated an suggest a quantity to be order based on the number of week set up in the file of vendor ABC ltd - which is currently 4.

From the Exceptions - the user set up an exception for the following product : Organic Plantic Mix. This product is ordered from Vendor ABC ltd. and the suggested quantity to be ordered should be based on 2 weeks of sales.

Therefore, next time the Replenishment report is run for this vendor using the Weeks of Sales - the system will generated an analysis and suggested quantity to be ordered for all items ordered from this vendor, based on 4 weeks of sales - except for the Organic Plantinc Mix which will have a suggested quantity to be ordered based on 2 weeks of sales.

Increase: From this field, the user can defined a percentage of increase (if the percentage entered is above 1.00) or decrease (if the percentage entered is below 1.00) that will be use to calculate the quantity to be ordered by the system.

This will be used by the user if the statistics of sales of the comparative period are not completely comparable to the current period. As example, if this is a seasonal product that needs to be ordered and the season is higher or lower than the previous year, the user might one to set up exception based on a percentage of increase or decrease.

The exceptions that will be created from this menu will always be applicable until they are delete by the user. Therefore, if an item or a category should not be considered anymore as an exception and the suggested quantity to be order should be calculated based on the default set up - the user will need to go back to this screen, and either delete one item/category at a time, or delete the whole list by selecting delete all.