I’m working with a partner, and were attempting to reconcile many months of inventory history to the Trial Balance Summary. We’re attempting to build generic inquiries to do this using the INTran and INTranSplit tables, extracting rows, grouping by our materials / lots / warehouses / locations to find that last transaction and filtering by Financial Period.
Our comparison results are sometimes close, but never tying out.
The back story is that a number of inventory receipts and adjustment were done during various go-lives and onboarding events, and now the Finance department is concerned about being able to audit the the history, essentiallly using details to prove out the Trial Balance Summary report.
Has anyone out there encountered this circumstance? Perhaps someone might shed some light on how the Trial Balance Report (especially Inventory Accounts) is calculated and relates to the transaction history?
Many thanks!