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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Update balance sheet (financial report) after changing main account category

(0) ShareShare
ReportReport
Posted on by

After changing the main account category in the chart of account, I am not able to get this realised in the financial report Balance Sheet Default.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Hans Teunissen,

    Are you making use of a Management Reporter financial Report?

    If this is the case, please have a look at the report setup.

    A lot of MR report make use of main account categories and if you change them, the reports might not work properly anymore.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi,

    I didn't change the account category itself but changed from one existing to another.

    Rgds Hans

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Hans,

    Is the new category that has been assigned included in the row or column structure of your Balance Sheet Report?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi,

    Yes it is in the row.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Hans,

    And the Problem still exists?

    Have you tried updating the cached financial data?

    What happens if you change the category back to the one that was originally linked to your account?

    Does that make any difference?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi,

    Yes still there. I have refreshed the cache but the ledger account is still cumulated on CASH instead of CASHEQUIV.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Hans,

    Have you tried restarting the Management Reporter Services?

    What happens if you post a new transaction on the account in AX?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    I have made a new transaction just yet and it can't be found on the old AND the new row. :-(

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Hans,

    This does not sound good.

    Do you have access to the MR data mart tables and can you check whether the new transactions are there?

    If they are not there then either your MR Services do not run or something else went wrong and you might have to reset the MR data mart.

    Do you have a developer or admin around you who setup the MR?

    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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
imran ul haq Profile Picture

imran ul haq 8

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans