Troubleshooting: Stock Balance Quantity in batch number selection not tallied with balance quantity in Stock Card

From AutoCount Resource Center
Jump to navigation Jump to search

Question : Why the balance quantity in my Batch No. Selection is not tallied with the balance quantity in stock card?

Batch not tally1.png


Batch not tally2.png


Possible Reason (1) :

You didn’t inquiry the stock card in smallest UOM.


Solution (1) :

Batch Number selection will show the quantity in smallest UOM. In order for Stock Card to do the same,


1) You should go to More Options > UOM Option in Stock Card report, change from Show Multi-UOM to Show Smallest UOM and Inquiry again.

Batch not tally3.png


2) Now Stock Card show balance qty = 65.

Batch not tally4.png


If stock card shown in smallest UOM still not tallied, please refer to the below possibility.


Possible Reason (2) :

There is transaction on future date. As balance quantity at batch number selection do not have date filter, and it will always be updated immediately.


Solution (2) :

Try to do filter date till end of the year at Stock Card Report and Inquiry, and do compare again.

Batch not tally5.png


After found out the source of discrepancies, if the date was wrongly assigned, make correction and save.


Possible Reason (3) :

Suspected data inconsistency occurred due to abnormal input or sequence in using the system.


Solution (3) :

1) Go to AutoCount Accounting Management Studio > Data Consistency. Click on Fix Inconsistent Stock Balance Quantity Problem.

Batch not tally6.png


2) Click on Fix Inconsistent Stock Balance Quantity Problem.

Batch not tally7.png


3) Click on Yes.

Batch not tally8.png


4) Click on OK after fixed.

Batch not tally9.png


By : Cheryl 181015, Lay Swan 181115, P181119



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