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

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

<b>Version :</b> 1.8 / 1.9 / 2.0

[[File:Batch not tally1.png]]


[[File:Batch not tally2.png]]


<u><b>Possible Reason (1) :</b></u>

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


<u><b>Solution (1) :</b></u>

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


1)	You should go to <span style='color:red'>More Options > UOM Option</span> in Stock Card report, change from <span style='color:red'>Show Multi-UOM</span> to <span style='color:red'>Show Smallest UOM</span> and <span style='color:red'>Inquiry</span> again.

[[File:Batch not tally3.png]]


2)	Now Stock Card show balance qty = 65.

[[File:Batch not tally4.png]]



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


<u><b>Possible Reason (2) :</b></u>

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.


<u><b>Solution (2) :</b></u>

Try to do <span style='color:red'>filter date till end of the year</span> at <span style='color:red'>Stock Card Report</span> and <span style='color:red'>Inquiry</span>, and do compare again.

[[File:Batch not tally5.png]]


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


<u><b>Possible Reason (3) :</b></u>

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


<u><b>Solution (3) :</b></u>

1)	Go to <span style='color:red'>AutoCount Accounting Management Studio > Data Consistency</span>. Click on <span style='color:red'>Fix Inconsistent Stock Balance Quantity Problem</span>.

[[File:Batch not tally6.png]]


2)	Click on <span style='color:red'>Fix Inconsistent Stock Balance Quantity Problem</span>.

[[File:Batch not tally7.png]]


3)      Click on <span style='color:red'>Yes</span>.

[[File:Batch not tally8.png]]


4)      Click on <span style='color:red'>OK</span> after fixed.

[[File:Batch not tally9.png]]



By :  Cheryl 181015, Lay Swan 181115, P181119



{{NavigateForUser}}

[[Category:Users]]