Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Ledger Allocation Rule

(0) ShareShare
ReportReport
Posted on by 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

  • 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.

  • 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

  • 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

  • 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 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

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans