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

Notifications

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) / Importing allocation r...
Microsoft Dynamics AX (Archived)

Importing allocation rules

(0) ShareShare
ReportReport
Posted on by Scania_Bjorn 397

Hi guys,

Dynamics AX 2012 R3

I have a complex allocation scenario, and I'd rather not do the setup manually :)

The source for allocation are all OPEX accounts, ranging from account 5000..7999 (Total 174 accounts) and a range of cost centers. This part is easy.

The destination is the same accounts, but spread on a dimension we call "Counter part" to 5 different counter parts.

Example:

Source: Account 6011 cost center 100 --> Destination: Account 6011 counter part TW1234 50%

Destination: Account 6011 counter part KR4321 50%

Setting up the source with ranges is very easy, but setting up the destination ends up in 870 combinations with different percentages and this is what I don't want to handle manually , 870 times.

How would you go about solving this?

Thanks in advance

/Björn

*This post is locked for comments

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

    Hi Björn,

    I'm not sure whether there is a default entity available in the DIXF and you probably have to build it yourself first to get the data uploaded for example from an excel spreadsheet where you need to prepare them.

    Best regards,

    Ludwig

  • Scania_Bjorn Profile Picture
    Scania_Bjorn 397 on at

    Hi Ludwig,

    There is an entity for source, and another for destination, however it will not solve my problem.

    I think we should perhaps setup a new ledger account where all source accounts can be allocated, to make things easier.

    /Björn

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Björn,

    You can setup a new entity for the import. Not sure why the setup of a new ledger account would make things easier?! Would be great if you can explain a bit more on that.

    Another question: Rather than making use of the periodic allocation rule for all of your OPEX accounts, wouldn't it be easier to make use of allocation terms that are setup at the main account level?

    Best regards,

    Ludwig

  • Scania_Bjorn Profile Picture
    Scania_Bjorn 397 on at

    Hi again,

    Been thinking of the allocation terms on ledger accounts, but there is a limit with that solution, from what I can see.

    Let's say I want to allocate anything that is posted on account 6011, with cost center 100, 200 and 300, but not 400 to the same ledger account (6011) but spread on dimension "counter part" to 3 different values. Then I need to setup:

    One rule for 6011 cost center 100, spread to 3 different counter parts.

    One rule for 6011 cost center 200, spread to 3 different counter parts.  

    One rule for 6011 cost center 300, spread to 3 different counter parts.

    If I have more dimensions combinations on my source, I get more combinations and again the setup is impossible to maintain.

    On account level, there is no way to use a range of dimensions as source. And there seems to be no way to inherit dimension values from source to destination.

    My thoughts on creating one more ledger account as the destination account, is simply because then I can use a range of accounts and dimensions as source, and one account with a spread to counter part as destination, and hence I only need to setup and maintain ONE destination.

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

    Hi Björn Wallmark,

    It's difficult giving you a good recommendation as I we are not as deep into this issue as you.

    In general, I agree that it is better making use of a spearate account that you use in the destination. That's not only because you can easier maintain the rules but also because you can easier follow up what is posted later on.

    Whether and how much time you save through the additional account usage needs, however, to be seen. This is only something you can assess.

    Best regards,

    Ludwig

    P.S. If there is nothing else open it would be great if we could verify and close this thread.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans