A1.71 : Stock: Inconsistent stock balance quantity problem keep happening
Question: Why is my stock balance quantity always not tally with the total balance quantity at stock item maintenance and can only be solved after run fix inconsistent stock balance quantity problems? It happens very frequently.
Possible Reason :
Suspected that the ItemBatchBalQtyTrans table is stuck due to deletion of item that has item opening. This is a known bug and is fixed in version 2.0.27.193.
Solution :
1) Update to Version 2.0.27.193 or above.
2) Backup your database, login to AutoCount Accounting Management Studio, go to Tools > SQL Query, and run the query as shown below: -
delete from ItemBatchBalQtyTrans
3) After done, go to Data Consistency > Fix Inconsistent Stock Balance Quantity Problem, and click on Fix Inconsistent Stock Balance Quantity Problem, click on OK after fixed.
4) Now, the problem should be resolved.
Related Articles
A5.93 : Stock - Reports : Stock Balance
This function allows you to generate Stock Balance report. Stock Balance is used to view each stock balance quantity as at specific date by location, by stock. If you are running Periodic Inventory System, it can also be used to obtain the total ...A5.103 : Setting - Account Book Setting : Stock Opening Balance
This function allows you to maintain your stock opening. It is used to input your current stock balance quantity and cost when you start to use the system. To access Stock Opening Balance, click on the Account Book Setting > Stock Opening Balance. ...A5.89 : Stock - Transactions : Stock Adjustment
This function allows you to manage your Stock Adjustments. Stock Adjustment is usually used to adjust the quantity of your stock due to specific reason such as stock damage, loss etc. *Stock Adjustment will add or deduct your stock quantity depending ...A2.122 : How to reset stock balance to 0?
Question : How to make all stock QTY become 0? Solution : Adjust your stock quantity by using stock adjustment. For Accounting 2.0/POS 5.0: Go to AutoCount 2.0 Management studio/ AutoCount 5.0 Management studio Tools > Reset Stock Balance Quantity ...A5.90 : Stock - Transactions : Stock Transfer
This function allows you to manage your Stock Transfers. Stock Transfer is usually used to transfer stock from one location to another location. *Stock Transfer will deduct your stock from the source location (From Location) and add into the target ...