web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Ledger Allocation Rule
Microsoft Dynamics AX (Archived)

Ledger Allocation Rule

(0) ShareShare
ReportReport
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)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger Allocation Rule

    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

  • binitshah Profile Picture
    binitshah 660 on at
    RE: Ledger Allocation Rule

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger Allocation Rule

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger Allocation Rule

    Hello Binit Shah,

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

    Best regards,

    Ludwig

  • Verified answer
    binitshah Profile Picture
    binitshah 660 on at
    RE: Ledger Allocation Rule

    Dear Ludwig,

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

    Thank you for the help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#3
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans