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)

How to keep the Source dimension for Ledger allocation rule with fixed percentage?

(0) ShareShare
ReportReport
Posted on by

AX2012R2:

When Ledger Allocation rule method = 'distribute the source document amount equally", you can select the Destination parameter 'keep account from' and 'keep dimension from': either 'user specified' or 'source'.

You cannot select 'keep account from' and 'keep dimension from' for another Ledger Allocation rule method.  How comes??

I just want to re-allocate the source ledger account into several other ledger accounts, but with keeping the original dimensions.

Example: Let's assume 2 original transactions

1) account 700000 and dimension department = 'G&A' - 15000€ debit

2) account 700000 and dimension department = 'SALES' - 10000€ debit

I need to re-allocate this into: 60% to account 700100 and 40% to account 700200 - but with keeping the original source dimensions.  So I use the allocation method 'fixed percentage'.

Result needs to be:

1) account 700000 - DEP 'G&A: 15000€ credit

-> to account 700100 - DEP 'G&A': 9000€ debit

-> to account 700200 - DEP 'G&A': 6000€ debit

2) account 700000 - DEP 'SALES': 10000€ credit

-> to account 700100 - DEP 'SALES': 6000€ debit

-> to account 700200 - DEP 'SALES': 4000€ debit

How to obtain this without specifying all possible Destination dimension possibilities manually. 

If the split would be equally 50% (using the allocation method 'ditribute equally' I could obtain this by using the parameter 'keep dimension account' = 'source'.  But this is not possible when using 'fixed percentage' as allocation method.

*This post is locked for comments

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

    Hi,

    The setup of the financial dimensions for your allocation rule is manual as you mentioned. If you have many account-findim combinations to setup you can possibly upload them to AX with the DIXF.

    An alternative to the allocation rules that are run after amounts have been posted are the ledger allocation rules that can be setup in the COA at the individual account level. The main difference is that the allocations are posted immediately with the underlying postings on your accounts. You might also want to have a look at those allocations to check if the setup and maintenance is easier for you.

    Best regards

    Ludwig

  • Community Member Profile Picture
    on at

    Ludwig, thanks for the prompt answer, but I find it strange that for an equally distributed allocation, there is no need to setup per dimension combination (because the destination parameter 'keep dimension from' can be set to 'source'), while as this is not possible in case we specify ourselves the percentages.

    As a matter of fact, equally distribution means that is it just divided by the number of lines added in the 'ledger allocation rule destination'; there is nothing more different than just a percentage...

  • Fahad.Khan Profile Picture
    10 on at

    Bert,

    Have u got the resolution of this requirement? I need also this. Kindly reply if u have any resolution for this

  • MahmoudElsaeed Profile Picture
    5 on at

    I have the same requirements on D365 FO,

    Any updates ?

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 April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dserp Profile Picture

dserp 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans