I just came across the problem where the ledger balance for inventory accounts don't match the inventory balance on the inventory evaluation report.
Usually I find this problem caused by manual journal entries posted to inventory accounts or non-stock items transacted with costs. However, they are not the case this time.
I'm thinking of comparing GL detail transactions of the inventory accounts against IN transactions in the IN module by batch number, however, the batch number referenced in the GL is not always them same as posted in the IN module. So, I wonder if I could get help here. Does any of you have a Crystal report that provides GL batch numbers and their associated original inventory batch numbers?
Any help or comment are very much appreciated.
Redmond, WA. USA