Share
ReportAX2012R2:
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 (
Answers (
5
