Accounting 2.0 - Stock: Inconsistent stock balance quantity problem keep happening

From AutoCount Resource Center

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.


By: Jodie 220317, Lay Swan 220329, P220330


Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations