Microsoft Dynamics AX (Archived)

Ledger Allocation Rule

(0) Share

Report

Posted on by binitshah

660

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

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
binitshah 660 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Binit Shah,

Just wondering if you have been able to get your issue resolved or if further assistance is required?

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

binitshah 660 on at

Like (0)

Report

Dear Ludwig,

We used the direct allocation on the ledger with the account structure validation to allocate the balances.

Thank you for the help.

Was this reply helpful? Yes No

Community site session details

Ledger Allocation Rule

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Ledger Allocation Rule

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates