Our Balance Sheet shows a Purchase Accrual balance that is almost four times higher than the balance shown on the Purchase Accrual Summary report.
I checked the Account Details for the Purchase Accrual account, and there are no manual journal entries posted to this account — all entries are from AP and IN modules. The balance for this account also matches the Trial Balance, including the debit and credit amounts.
I also read a similar post on the Acumatica Community and tested all of the suggested steps, but the issue still remains.
I’m not sure where else to look to identify the discrepancy. As mentioned, the variance is quite large — roughly four times higher than the Unbilled Receipts amount.
Has anyone encountered a similar issue or have any recommendations on how to troubleshoot and resolve this discrepancy?
Please run the Purchase Accrual Summary report in Purchasing module for all accounts. It’s possible that more than one Purchase Accrual account has been entered on the GL Accounts tab of Vendors and used to post the purchase accruals.
Look at the activity in all of the Purchase Accrual Accounts in the GL Trial Balance report, to see whether activity on the Purchase Accrual Summary matches the Debits and Credits in the GL Trial Balance for a given period (as you described).
Check the Release Batches screens in PO, AP, and IN modules to make sure every batch that updated PO, AP, and IN has been posted to the GL.
Check GL Post Transactions Process to make sure every batch from AP and IN modules has been posted to GL.
Use Account Details screen in Finance/GL module to make sure All transactions posted to your PO Accrual account originated in either PO, AP or IN. Click the Module column to filter: there should be no GL entries in PO Accruals account
Please run the Purchase Accrual Summary report in Purchasing module for all accounts. It’s possible that more than one Purchase Accrual account has been entered on the GL Accounts tab of Vendors and used to post the purchase accruals.
Look at the activity in all of the Purchase Accrual Accounts in the GL Trial Balance report, to see whether activity on the Purchase Accrual Summary matches the Debits and Credits in the GL Trial Balance for a given period (as you described).
Check the Release Batches screens in PO, AP, and IN modules to make sure every batch that updated PO, AP, and IN has been posted to the GL.
Check GL Post Transactions Process to make sure every batch from AP and IN modules has been posted to GL.
Use Account Details screen in Finance/GL module to make sure All transactions posted to your PO Accrual account originated in either PO, AP or IN. Click the Module column to filter: there should be no GL entries in PO Accruals account