Dear All,
I have a query relating to the ledger allocation rule.
In my implementation we are using ledger allocation on the basis.
We have multiple ledger accounts from which the balance should be transferred from the ledger account to the regions on the basis of the sales made in each region.
How do I select multiple ledger in the ledger allocation rule source and the destination form.
*This post is locked for comments
Dear Ludwig,
We used the direct allocation on the ledger with the account structure validation to allocate the balances.
Thank you for the help.
Hello Binit Shah,
Just wondering if you have been able to get your issue resolved or if further assistance is required?
Best regards,
Ludwig
Hello Binit Shah,
You should be able to get this allocation realized by making use of a so called Basis allocation rule.
An example can be found here: vsdynamicsfinance.wordpress.com/.../setup-ledger-allocation-rule
Can you verify and test whether this fits your requirement?
Ludwig
Hi Ludwig,
Thanks for the reply...
One small example:
Sales East: 100000 USD
Sales West: 200000 USD
Sales North: 300000 USD
Sales South: 400000 USD
So the total sales is = 1000000 USD
Now we have:
Travel Expense (605001): 50000 USD
Employee Benefits (605002): 20000
The above 2 balances are not posted in the HeadOffice Dimension.
I need to allocate the above 2 balances in the ratio of sales
So in the source form I will select: Ledgers 605001..605002
But how do I make sure that the correct balances are posted to the destination.
In my example
Travel Expense East Should be: 5000
Travel Expense West: 10000
Travel Expense North: 15000
Travel Expense South: 20000
and Employee benefits should be:
East: 2000
West: 4000
North: 6000
South: 8000
Please guide
Hello Binith Shad,
In the source form you can select a range of ledger accounts by entering ranges as in other parts of AX. That is, simply enter the first account, then two dots (..) and then the last account. You can also separate individual accounts separated by comma.
In the Destination form the individual ledger accounts can be separated by entering e.g. a percentage figure that indicates which desination account gets allocated which percentage of the source postings.
Hope this helps,
Ludwig
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156