Overview
Problem / Symptoms:
When upgrading to 4.6 from versions like 4.5.2 and below, there might be the scenario where all the stockvar records before the upgrade show a Zero Start Qty on Hand and End Qty on Hand, is due to changes in the StockVar and Stocksummary table that recalculate the data in order to ensure opening and closing value are correct.
This is on by default when upgrading to 4.6 but is not triggered automatically for historical data.
Example of this occurring after upgrade to 4.6
Diagnosis:
The reason that the Quantities on hand show zero is because they have not been recalculated into the StockSummariesRebuilt Table yet.
Due to the default global function 'Stock Tables Rebuild'
Solution / resolution:
In order to resolve this please follow the steps below.
Create a new Schedule Job- Stock Recalculation
Job Type: External DLL
DLL Name: Jobstd.Dll
Stock Recalculation
Set it to all venues and all stores
Max Timeout of 30 mins
Ensure its run once every 24 hours before the start of a new day or when the venue is closed for trade.
The average processing time is around 5-10mins dependant on the product base.
NOTE: While this process is running the StockVar Table is locked out of processing any new records until the process is completed.