Overview
Problem / Symptoms:
When trying to view the StockList from the Product Setup view and the below error is presented, then the Prodstore Current Stock ID records have been corrupted.
This is normally due to StockVar Data being lost when doing a Database Restore.
Diagnosis:
As can be observed. 'Mcguig Blklab Melbec' has a current Stock ID of 128158 on the Prodstore Record.
But the product should be associated with StockID 4145
Solution / resolution:
The StockList view will automatically populate with a function button called ' Repair Chain' when the error is encountered, the operator simply should execute this operation which will then fix the Current Stock ID record for the affected product on the Prodstore Table.
Secondly, it is then recommended to run a Stock Test from Database.exe
Note: Normalise Costs
This runs a similar process to above in that this will report on and change Cost on hand values that are more than 20% outside the Last Cost multiplied by Qty OH pressing NO will also produce a .txt file as a reference report