Serial and Batch Bundle never disappoints! Stock Reconciliation shows incorrect “auto-fetching of existing quantity” when the item has Batch number and has transactions both with Batch number only and Serial and Batch Bundle.
The Stock Reconciliation auto-fetches stock as 81 as there has been a transaction with Serial and Batch Bundle of 1 units. Obviously the auto-fetch in Stock Reconciliation has not been updated with Serial and Batch Bundle.
I would like you to check the Batch-Wise Balance History report once, where you will get a clear picture of the opening and balance values. And I would like to know if you had uploaded the batch-wise stock and series-wise stock separately for that particular item? If you can explain this in more detail, it will help us to solve this.
The batch wise stock balance is 80 with opening and relevant QTYs showing correct values.
There are no uploads for any of the items. We use the system since the beginning of the corp.and all transactions are geniunely made on our instance.
This is becoming more that a bug! The Stock Reconciliation is now posting only stock increase in the Stock Ledger. Since the transaction does not post the negative entry, the stock value is double of the balance.
The SABB is not backward compatible. That is for sure and now it is nearly impossible to correct or debug.
The problem is with the expired batches at the time of reconciliation.
UNTIL IT IS FIXED, here is the temporary solution:
When you change the expiry date temporarily and do the stock reconciliation, the problem is gone. Don’t forget to revert the expiry date to original values after reconciliation.
So, we close this.
