Fixing Your Trial Balance in Microsoft Dynamics AX 2012
Posted on: May 24, 2016 | By: Jarrod Kraemer | Microsoft Dynamics AX/365
Authored by: Chris Rusing
Recently, one of our clients ran into an issue with their trial balance. Opening balances for each ledger account were four times as much as they should have been. Obviously, this was quite concerning to their accounting department! Luckily, when it comes to issues like this, there is an easy solution.
In the legal entity in which you are experiencing trial balance issues with, go to the address below and then click Financial dimension sets.
It will bring you to this form below. Select the financial dimension set you were using when viewing the trial balance and click Rebuild balances at the top of the form.
Next, click OK and wait patiently. This might take some time depending on how many transactions are in your system.
Once it is finished, go back into your trial balance and select the dimension set at the top of the screen. Click Refresh to ensure that the data has been updated.
Please note that the Rebuild balances functionality is only available after you have performed the Initialize balances function. You must initialize the balances after creating a new financial dimension set so that it is available to choose from in the financial dimension set drop down in the trial balance form.
For additional information please feel free to reach out to us at firstname.lastname@example.org or (312) 345-8817.
All the best!
25 Brilliant Ideas to Outsmart Your Competition with Microsoft Dynamics
Top 10 Inventory & Operations Decisions Distributors Are Making Blind
2020 Nucleus Research Report on ERP Technology