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

Inconsistent stk1.png


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.


Inconsistent stk2.png

Inconsistent stk3.png


4) Now, the problem should be resolved.


By: Jodie 220317, Lay Swan 220329, P220330


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations