Issue: Ledger balance does not match with the actual one.
Many times, clients face an issue when verifying the closing balance of ledger in AX. The closing balance of the ledger in Trial balance does not match with the actual one.
Closing Balance for year end date can be viewed from various places. Like;
General Ledger > common > Trial balance
General Ledger > Reports > Transactions > Trial Balance
General Ledger > Reports > Transactions > Balance list
For example: Below is the screen of trial balance showing the closing balance for the end date. You can view the end date by clicking on the Parameters at the top. Here, in the screen below, the closing balance for the ledger 110110 is $92,702,651.82
When doing inter-company transactions through the general journal, the closing balance of the ledgers in two companies should be the same with the opposite sign. It means, if in company1 the balance is $50,000 then in company2 the balance should be $-50,000.
Which may not sometimes as have shown in the screen below:
Ledger : 11501
closing balance : $-4,222,786.94
Ledger : 11501
closing balance : $4,222,816.94 Here, the balance should be $4,222,786.94
To resolve, we can follow the below steps:
Process the year-end-closing for all the previous year’s end date, right from the initial fiscal period to the current one from GL->Periodic->Fiscal year close->Opening transactions.
(If Rebuild balance is not enable, reset the FocusState to “Initialize” from “In Process” in the DimensionHierarchy table for the selected financial dimension.)
Select the posting layer as current. DESELECT “Include opening transaction amount in detail” and “Closing Transactions”.
You will find that the balance of the ledger is verifying in summary trial balance report, balance list report, trial balance form.
Latest posts by Dipal Vyas (see all)
- Step by Step Guide to Create Restful API for Dynamics AX Data - December 14, 2021
- Steps to Create Web Service in .NET and Consume in D365 F&O Project - December 14, 2021
- Custom Service Integration with D365 F&O - November 11, 2021