In the ledger allocation rule, the "Destination" form does not allow to keep the financial dimension (those not allocated) according to the original value.
If you want to allocate dimension 1, you need to even though define each value of dimension 2 for destination posting. This is not manageable.
Just use the logic of
Main accounts > Legal entity overrides > Allocation terms > Destination ledger account.
This is exactly what is missing in the allocation rule definition.
It would be perfect if this logic could be made available in the ledger allocation rule definition, Destination, too. As is the Main accounts table, the selection should be per single financial dimension (could also be applied in the form "Offset").
Comments
Is there any update as to when this might be available?
Category: General Ledger
To keep dimensions or possible to setup which dimensions should keep from the origin transactions is very required by the customers and it is common way to do allocations.
Category: General Ledger
Yes, this is a basic requirement. The ledger allocation rules are not manageable without the choice of keeping some of the financial dimensions (and main account) from source. E.g. my client has 10 active financial dimensions, they want to use the allocation rules to split one product in to 10 different based on percentage. At the same time they want to keep main account, costcenter and other financial dimensions from original posting. If this should be setup now it would require hundreds of rules to make it happen because every combination requires their own rule because of the destination setup, but it should be a quite simple requirement. Please add this in the roadmap soon, I have gotten requests about this from multiple clients.
Category: General Ledger
Administrator on 5/14/2019 2:14:06 PM
Thank you for your feedback. This is a great suggestion! We will consider this in our roadmap.
Sincerely,
Kristi Weekley
PM, Microsoft