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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Trial balance with emp...
Microsoft Dynamics AX (Archived)

Trial balance with empty financial dimensions replaced

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I have to solve this problem in trial balance - there is a financial dimension defined, let's have it named X and its values are actually main account values. When posting a transaction in general journal, main account and X can be different and X is not mandatory. When displayed in trial balance, our costumer would like to replace empty values of X with main account values (and do the group by calculations, of course) . Any idea? Thanks.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,199 Super User 2026 Season 1 on at

    Hi Kavanka,

    This is not possible without a customization or export the report to excel and replace values. Have you considered using a standard dimension which can be setup per ledger account if there is no value specified by the user? In that case the dimension always have a value.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Kavanka,

    One possibility is making use of the ledger allocation rules in GL.

    Have you tested this feature?

    Best regards,

    Ludwig

  • Khaled Alloud Profile Picture
    Khaled Alloud 3,658 on at

    Hello,

    For clarification, if the dimension represents main accounts how it is going to be different when putting the values? can you please share with us the purpose of this setup.

    Thank you,

  • Community Member Profile Picture
    Community Member on at

    I haven't tested allocation rules yet. Thank you for your help, this seems to be the way in case the allocations are posted within the same voucher as the original transaction. Allocation terms defined on main account could do the job?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Kavanka,

    The difference between allocation rules and the allocation terms that you set up at the main account level is that the latter ones are posted immediately while the first ones require a periodic process to be run. I guess that both ways work. Probably just do some testing and let us know if it works out for you.

    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 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans