Sales History Adjustment is used when Average Daily Sales is calculated for an Item and the Replenishment Calculation Type is set to Average Usage. The purpose of Sales History Adjustment is to increase or decrease the sales history quantity for an item in a store for a specific date.
This is usually done, if onetime events created peaks and spikes in the sales history which should not be considered in the Average Usage calculation. With Sales History Adjustment the user can correct the sales history and eliminate those peaks and spikes.
Sales History Adjustment can be also used in implementation projects to create a sales history without creating Item Ledger Entries. The sales history from Sales History Adjustment will be used for the forecast calculation.
The system calculates the sales quantity for a specific period and calculates Sales History Adjustment Quantity. The sum of the two quantities is the Adjusted Total Quantity.
Total Sales Quantity = Total Sales Quantity + Total Sales History Adjusted Quantity.
The Replen. Sales History Adj. page can be accessed from the Replenishment Control Data page. The page lets you copy and paste records into this table using Excel.
Note: It is essential to enter a negative value if you want to lower the sales history figure and a positive value if you want to increase it.
See Also