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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Multiple allocation te...
Microsoft Dynamics AX (Archived)

Multiple allocation terms above 100%

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All.

 

I want to know if it’s possible to setup multiple allocation terms on the main account with each allocation term at 100%. Currently AX gives the error that you can’t exceed 100% of the allocation. In my case I would like to do that as I allocate it just too new dimensions due to default dimensions setup on master data that can’t be changed.

 

Regards

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Eduan,

    Can you provide some additional details on what you try to achieve exactly and what you have setup so far? Some screenprints would help.

    Thank you,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig

     

    We are mapping the COA to GAAP dimension for reporting purposes. We use a shared COA and a specific entity needs to report according to GAAP. We created a dimension and did a 1to1 mapping for majority of accounts. Some of the GAAP dimensions get defaults from master data and thus needs some reallocations. So end of the day we are re-classing our GAAP dimension

     

    Error received when loading multiple allocation rules

     b.JPG

     

    Allocation rules on account 400100

    b.JPGc.JPG

     

      

    Code preventing the 100% allocation

    2620.d.jpg

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Eduan,

    What you try to achieve cannot realized by using the allocation feature at the main account level that you show above as you are over the 100% that the code prevents to allocate.

    If you need to setup multiple allocations you can use the ledger allocation rules under (GL/setup/Posting/LedgerAllocationRules)

    Have you tried using this feature instead?

    The difference to your solution is basically that you have to run a periodic job that does the allocation for you.

    Yet, if you run the job in Batch mode e.g. every 5 or 10 minutes this should hopefully fine for you.

    If you need more information on the Feature, please have a look at the following sites:

    technet.microsoft.com/.../ff395364.aspx

    dynamicsax-fico.com/.../allocations-cost-distributions-in-gl

    Hope this helps,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Thank you for the feedback.

    I investigated using the allocation rule but unfortunately it also has some shortcomings to what I would like to achieve.

     

    Firstly: In the destination we would have to specify each dimension for the destination unless I am missing something. It does not have the specific/unspecific option as with the ledger allocation term. For our allocation rules that will be an issue especially due to the volume of allocation rules.

     4861.z.JPG

    Secondly: Unfortunately the allocation needs to happen at the stage where the transaction is being processed. As my understanding we will contradict GAAP compliance for the country if we reallocated by batch after the transaction is posted. Doing the recon to what gets allocated and what not would be a big task as I’m talking about a lot of allocation rule.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Eduan,

    I see. So, if I understand you correctly the ledger allocation rules would require you setting up lots of rules and is not manageable in your company.

    Initially you wrote that ... Some of the GAAP dimensions get defaults from master data and thus needs some reallocations. I am wondering why this happens and how this could be avoided if you say that you have a 1:1 relationship between your accounts and financial dimensions.

    Have you tried Fixing main accounts and financial dimensions?

    2821.Unbenannt.PNG

    Using this feature would overwrite any other financial dimension that comes from your master data (customer, vendor, items..) and should - hopefully - fix your problem.

    Can you check that?

    Ludwig

     

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig.

     

    Thanks for all the suggestions.

    We are currently using the “fixed value” option on some of our scenarios. But let me explain the scenario of Sales order invoice as example.

     

    The invoice creates the following postings.

    Account

    Type

    Transaction

    MainAccc-Dim-Dim-Dim-Dim-Dim-

    Dim-Region-Gaap

    Comment

    Revenue

    Allocation

    400100-10100-75200-00000

    -0000-00-0000-6320-707050

    The correct Gaap dimension that’s associated with Revenue

    COGS

    Allocation

    500100-10100-75200-00000

    -0000-00-0000-6320-607050

    The correct Gaap dimension that’s associated with COGS

    COGS

    Allocation

    500100-10100-75200-00000

    -0000-00-0000-6320-411000

    Reallocation transaction to reverse

    COGS

    Original

    500100-10100-75200-00000

    -0000-00-0000-6320-411000

    Because we defaulted the Gaap dimension on customer it pulls through but my 411000 Gaap is not related to COGS account so we need to reallocated

    Ship not

    Invoiced

    Original

    122200-10100-75200-00000

    -0000-00-0000-6320-371002

    Gaap dimension is set on GL with fixed value because we have a 1:1 relationship between Main and Gaap dimension

    FG

    Original

    122100-10100-75200-00000

    -0000-00-0000-6320-371000

    Gaap dimension is set on GL with fixed value because we have a 1:1 relationship between Main and Gaap dimension

    FG

    Original

    122100-10100-75200-00000-

    0000-00-0000-6320-371000

    Gaap dimension is set on GL with fixed value because we have a 1:1 relationship between Main and Gaap dimension

    Revenue

    Allocation

    400100-10100-75200-00000

    -0000-00-0000-6320-411000

    Reallocation transaction to reverse

    Revenue

    Original

    400100-10100-75200-00000

    -0000-00-0000-6320-411000

    Because we defaulted the Gaap dimension on customer it pulls through but my 411000 Gaap is not related to Revenue account so we need to reallocated

    AR

    Original

    110100-10100-00000-00000

    -0000-00-0000-6320-411000

    Gaap dimension is set on Customer because in the customer we have 3 dimensions for the GAAP. Local, Export, EU dimension but all post to 1 main account

     

    Ok so the above all can be done in allocation functionality. My challenge is as soon as the region dimension in my dimension string change my gaap dimension should change as well. The above transactions is related to a France region but let’s say the region change to US, the gaap dimension for COGS should change from COGS EU to COGS Export. This will then create another allocation rule but my main account posting stayed the same and I can’t create multiple allocations per GL account.

     

    I’m therefore creating allocation on a variable in a dimension.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Eduan,

    I can see your point with the region dimension. Would it be possible that this single dimension is not fixed at the ledger account level and gets inherited e.g. from your customer?

    Irrespective of this, I believe that you either need to work with different allocation terms, fixed main account-ledger dimension combinations or make a system modification for your allocation terms that you currently using. As you have all the details, I believe that you are the only one who can make an assessment and weight the pro and cons.

    What I would like to emphasize at this point is try to avoid making an adjustment - if that is possible - especially in regards to financial dimensions. The inheritance logic, tables, etc. related to financial dimensions is already complex and the risk that something is overlooked when making an adjustment is pretty high. Yet, if you see no other chance then make the adjustment but throughly test your system and processes to ensure that everything works as required.

    All the best,

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans