The Update Stock Levels Based on Sales History is the section that actually calculates and enters the updates within your files. It is recommended that you print out the "Update Stock Level Report" (3.4.1.1) before running this program.

To lock the Order Level and Stock Level so that it will not be changed when you run Update Stock Level Based on Sales History enter a leading zero (0) on the Order Level. This will lock both the Order Level and the Stock Level at the numbers entered.

If the Ending Period is in the future, the current system date will be used.

The Lost Sales Percentage is the percentage of Lost Sales that you will use during the Stock Level Calculation. You may enter any percentage from 0 – 100. Typically, 10% - 30% is a good rule of thumb.

Lost Sales are created every time an item is not sold at "POS Order Entry" in POINT OF SALE (1.1) because lack of stock. Back Orders are included in Lost Sales for the individual Invoice. There will be times that you will want to Ignore Lost Sales when calculating your Order Level and Stock Level.

The number of selling days in a week is used to calculate the quantity sold per day. This should equal the number of days in a week that you are open.

Normally the Vendor (If Not the Current Source) field should be left blank and the Current Source will then be used for the Lead Time, Order Frequency, and Safety Stock.

If another Vendor (besides the Current Source) is entered, then the program will use the Lead Time, Order Frequency, and Safety Stock from this Vendor to calculate the Order Level and Stock Level. This is mainly used in a Purchase Order Transfer situation for Satellite Stores. If the "Update All Locations" flag is "Y", in "Inventory Setup" in SYSTEM MANAGEMENT (10.2.4.2 field 1) then the Current Source for the Satellite Store is whatever it is for the Main Location. If setting the Order Level and Stock Level for the Satellite Store, use the Transfer Vendor as the Vendor in this field. Enter the Vendor Source to be used for Lead Time, Order Frequency, and Stock Level and press <ENTER>.  This will be a Vendor instead of the Current Vendor.