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

(0) Share

Report

Posted on by Community Member

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

All responses (4)

Answers (0)

MahmoudElsaeed 5 on at

Like (0)

Report

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

I have the same requirements on D365 FO,

Any updates ?
Fahad.Khan 10 on at

Like (0)

Report

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

Bert,

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

Like (0)

Report

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

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...
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

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