AX2012 Ledger Allocations - Allocate Cost Center over a range of Main Accounts

Finance and Operations/AX User Forum
1

Hi AX Finance Experts,

I am looking for some input on setting up Ledger Allocation Rules (AX2012 R2 CU6). I am interested in allocating account balances from a range of ledger accounts (Main account and Cost Center) to diffrenet Cost Centers, but keeping the same Main Account. For example.

Acct 4001, Cost Center 00 amount is 1000

Acct 4002, Cost Center 00 amount is 2000

Acct 4003, Cost Center 00 amount is 1500.

I want to allocate these amounts to the same main accounts, but with 70% each to Cost Center 01 and 30% each to Cost Center 02. (eg, result is 4001-01 = 700, 4001-02 = 300, 4002-01 = 1400, 4002-02 = 600, etc…)

I could achieve this by setting up three different allocation rules (one per main account), and if my production environment only had three accounts I would gladly do this. The reality is that this appoach would not scale well to the number of main accounts that I am actually interested in allocating though.

Has anyone out there encountered this situation? Am I missing any options in the setup of allocation rules?

Thanks for any advice you may have.

Kurt

2

Just to clarify in the above post - We are using Cost Center as a Financial Dimension.

Thanks!

3

You can use ranges and lists for main accounts in the Source Criteria textbox of the Ledger Allocation Rule Source form. See this page:
http://technet.microsoft.com/en-us/library/gg230897.aspx

4

Kurt,

Curious to know whether you cracked this. I believe you have no other option than creating multiple allocation rules and each rule should have its own source and destination.

However, to reduce the human effort, You may use the DIXF to import the source and destination details. Never tried though.

please let us know if you did find any other way.

5

Thanks for the reply RiPi.

Actually I did look at the list / range of values, but it is the destination side of the allocation that I am struggling with. There does not seem to be a way to map each main account in that source range to the same account in a destination range.

6

Santosh,

At the moment we are using Atlas to upload a Journal that effectively allocates the amounts by Financial dimension. As you suggest, I am certain that the same could be done using DIXF. I was hoping to find a way to make the process a little more efficient and that Allocation Rules would provide us a way. The current method is working for the moment though.

Thank you for the reply.

Kurt

7

Sorry about that - I didn’t read your OP thoroughly.

I too am not aware of a way in base AX to do what you are talking about.

8

Kurt,

My intention is to tell you that You can do this by defining multiple ledger allocation rules.( In my opinion).

But, as it is tough to create multiple ledger allocations rules, I suggested to Import the allocation rules using the DIXF or Atlas.

9

Thanks Santosh,

Yes, I was not really thinking in terms of loading the allocation rules, but that is a good thought. I was thinking primarily of a way to efficiently execute the allocation rules on an ongoing basis. It looks like each allocation rule must be run individually and executing each rule creates its own journal.

Do you know if there a way to execute the multiple allocation rules in a single process (or perhaps a batch process) that would result in a single journal? I was not able to see a way to do that.

Thanks again.

10

You are right Kurt, we do not have a provision to process multiple allocation requests at one time. However, if you want you can do onething. Let’s say you create 3 different allocation rules. Then, you process allocation request individually for the first time and you schedule it for batch processing there.

So, without user intervention, you can have that allocation keep happening everytime. Finally, regarding the “single journal”, you have to live with that. I believe having each allocation data in single journal would make good sense and won’t bother customer much.

11

Thanks Santosh. We will have to evaluate the trade offs between the current method (Journal Import) and the possible alternative of setting up batch processing for the allocation rules. This has helped me in better understanding the process options and I thank you again for your input.

Kurt

12

Santosh:

Could you provide further instruction as to how to create a mass set-up either using the “DIXF” functionality you mentioned and/or Atlas?