AX 2012 R1 did not allow you the ability to fix a financial dimension value for a given main account. However, AX 2012 R2 has added functionality allowing you to fix a financial dimension value for a given main account. This ensures that regardless of other financial dimension assignments used on a particular AX transaction, posting to the main account for which you’ve defined a fixed dimension will always use that fixed financial dimension value. The key towards using fixed financial dimension values in AX 2012 R2 for a given main account is to use the ‘Select the level of main account to display’ option in the Main accounts form. When this is set to ‘Companies’ you can map your individual companies and an additional fast tab called Financial dimensions fast tab becomes available.
Please consider the following example on how to use fixed financial dimension values in AX 2012 R2:
Assume that you have a main account ‘110110’ in your Chart of Accounts, for which you want to make sure you always have a Department financial dimension value of ‘022’ posted with the main account.
You would start by going to General Ledger | Common | Main accounts to open the Main accounts list page. Within the Main accounts list page, you would double-click on the ‘110110’ main account to open the Main accounts form. Once in the Main accounts form, you should select ‘Companies’ from the ‘Select the level of main account to display’ field.
You can then click the green Plus button to the right of the Companies field and select the individual company for which you want to assign a fixed financial dimension value for. In my example, I’ve used the green Plus button to select the ‘USSI’ company.
Now that I have the ‘USSI’ company selected in the Companies field, the Financial dimensions fast tab appears at the bottom of the Main accounts form. When I expand the Financial dimensions fast tab, I can select ‘022’ in the Department field and specify ‘Fixed’.
I can now close the Main accounts form. At this point, any future postings against the 110110 main account in the USSI company will always associate the ‘022’ department financial dimension value. As an example, I will simply create a GL journal using the ‘110110’ main account. You will see that the ‘022’ department defaults in.
When you then post the journal, the ‘022’ Department financial dimension value will always be passed in. I can see from the posted voucher (clicking on Inquiries | Voucher at the top of the Journal voucher form) that the ‘022’ Department financial dimension value was passed in.
In this example, I’ve articulated how this works using the example of a simple GL journal. However, where this fixed financial dimension value becomes more valuable/advantageous is in those unique types of subledger tranasctions where you need to ensure that a main account always has a specific financial dimension value passed in to ensure accurate financial reporting.
Ryan Kleven
Hi Ryan,
Am into an implementation where, I have a previous company A using AX for its transactions for an year now.
Am now implementing company B (same instance) with a partner. I am told that we cannot have a separate set of financial dimensions for company B. Your answer will be appreciated.
Thanks,
Tahseen.
Hello Tahseen,
I have spoken to a couple of our functional consultants, and I received the following answer.
Financial dimensions are shared between all companies. With that being said, you use the “Account Structures” to deem which financial dimensions are used per company, per account so per say you can have separate financial dimensions per company.
1. Create any new dimensions needed for Company B.
2. Go to GL > Setup > Chart of accounts > Configure account structures
a. Setup the account/financial dimension hierarchy for company B. This could use existing dimensions from company A, the new dimensions created for B, or a combination of both.
3. Activate the new account structure or structures created.
4. In company B, go to GL > Setup > Ledger and select the account structures that will be used for the company. This will make the dimensions selected in the account structure active for company B.
Regards,
Dalton