web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Trial Balance Opening ...
Microsoft Dynamics AX (Archived)

Trial Balance Opening Balance Incorrect

(0) ShareShare
ReportReport
Posted on by PaladinSteve 288

Good morning,

Our fiscal year end was a few weeks ago. We have 3 legal entities. In running the opening transactions transfer in one of those companies, somehow the parameters for "Create closing transactions during transfer" and "Delete close-of-year transactions during transfer" got checked. This caused our 30 September balances to appear to be 0 in our revenue and expense accounts. To correct this, I reran the opening transactions transfer with "Create closing transactions during transfer" unchecked. This got rid of the closing transactions as of 9/30, but now my trial balance is showing Opening balances that are twice what they should be. When I look at the details, everything looks correct - the opening balance is fine at the detail level. When I run the ledger transaction list, everything looks fine in both the prior year period and the current open period.

I have run "Recalculate Ledger Periods", which usually fixes issues like this, but it isn't this time. I'm stumped.

*This post is locked for comments

I have the same question (0)
  • Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at
    RE: Trial Balance Opening Balance Incorrect

    Yes, my bad.  Update balances is the incremental update to the Dimension set.  Rebuild balances is the fresh initialization of the Dimension set, deleting it and starting from 0 again.  I should have been more precise, and I'm glad you found it anyway.

  • PaladinSteve Profile Picture
    PaladinSteve 288 on at
    RE: Trial Balance Opening Balance Incorrect

    Ludwig,

    I followed your instructions. Unfortunately, I won't have a test company available again for several weeks. All of our non-production environments are currently in use for testing a CU8 to CU11 upgrade and do not have the year end data in them. Unfortunately, this fix did not resolve the issue. In fact, it has made it worse. My opening balances on the trial balance page are now 3x what they should be, while the details seem to be correct with only one Opening transaction showing and it is for the correct amount.

    Brandon,

    I  tried "Update Balances" on the Financial Dimension Sets. That didn't fix the problem. However, "Rebuild Balances" did! Thank you!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Trial Balance Opening Balance Incorrect

    Hi PaladinSteve,

    Please take a look at the following solution provided by MS

    Solution 3664622Opening balances duplicated following GL EOY

    Problem:

    Closing and Opening Transactions have been duplicated following a GL year end (Opening Balances process).

    Depending on the parameters set when running the Opening balances function each subsequent running of the Opening Balances process should delete the previous entry.

    There are no modifications to GL on this site.

    Expected Result:

    The expected result would be to not have the two entries marked as "interim2". The 'interim2' year end was run in December 2014 for the year ended 30/06/14. The year end run yesterday has the voucher number FY2014.

    The 'interim2' entries should have been deleted

    Mitigation:

    Run the Reset balances job from GL| Periodic| Financial year close| Opening transactions| General| Transfer method| Balance accounts here select the option as ‘Reset’ from dropdown and run the job with the same parameters as used in previous closing. This should just remove the opening balances that exist. Then check the balances for the New Year, and try running Closing | Opening again.

    Link:

    fix.lcs.dynamics.com/.../Solution;qc=12098a0aa011319801dbca872c45154ce6111bfb732610bbc6ebc932eb9747c5

    Isn't this what you experienced?

    Before doing that, get a proper test environment to ensure that things work as expected. There is actually no much that you can 'destroy' but to ensure that nothing deteriorates and to get a confidence that this solution fixes the Problem, I would suggest to test it all in a demo environment first.

    Best regards,

    Ludwig

  • Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at
    RE: Trial Balance Opening Balance Incorrect

    Recalculate ledger periods does something else entirely.

  • Verified answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at
    RE: Trial Balance Opening Balance Incorrect

    Anytime you delete transactions from your ledger, you should Initialize your Dimension sets again.  Actually, the fiscal year-end close process should do that for you, but if it gets out of whack for any reason, just Initialize it again.

  • PaladinSteve Profile Picture
    PaladinSteve 288 on at
    RE: Trial Balance Opening Balance Incorrect

    I have not. I'm a little concerned it will add to the problems rather than correct them and I do not have a test environment available currently.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Trial Balance Opening Balance Incorrect

    Hi PaladinSteve,

    Have you tested running the closing process once again without the "Delete close-of-year transactions during Transfer" parameter checked?

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Mea_ Profile Picture

Mea_ 2

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans