Accounting 2.0 - 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.

By: Jodie 220317, Lay Swan 220329, P220330

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations