Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Amy Axness]

I am working on importing our budget through the DIEF/DIXF framework in AX 2012 R2 CU6.  I have been able to get this to work for two of our financial dimensions sets, but am getting an error message on the third.
The first dimension set is for our sales and cost of sales accounts, and we only budget 2 of the 5 financial dimensions, so the LedgerDimension is 41000-119B–.  I am able to get this to import successfully.
The second dimension set is for expense accounts with no financial dimensions attached, so the LedgerDimension is 89800.  I am also able to get this to import successfully.
The third dimension set is for Expenses with departments,  so the LedgerDimension is 53200-510.  Here is the error message I am receiving “Financial dimension value 510 does not exist.”  I am able to type in this LedgerDimension directly in the Budget Register Entry and it does work there.

Here are the items I have reviewed:
1) The financial dimension values are assigned to the company I am importing.
  2) The financial dimension is set up as a budgeting dimension.
3) I can manually enter this combination in the budget register entries.

Has anyone else had this problem?  Any suggestions on how get this fixed?
Thanks!

——————————
Amy Axness
Controller
J&D Manufacturing
Eau Claire WI
——————————

[Shirley Adams]

I have to admit I had issues with importing using DIEF so I ended up importing using the Excel add-in – normally I stay away from it too much as it’s a little finicky but for ledger and budget and the dimension references, I found it easier than DIEF.  Just a thought.

——————————
Shirley Adams
AKA Enterprise Solutions
New York NY
——————————
——————————————-

[Barr Snyderwine]

We use Atlas for the budget import and it has not had any issues but do not have a budget only dimension

——————————
Barr Snyderwine
Hargrove, Inc.
Lanham MD
——————————
——————————————-

[Sam Clark]

We had issues with the financial dimensions using DIXF as well.  We ended up using the Excel Add-in and it worked fine.

There’s a blog out there with the instructions on how to do it in Excel.

Thanks,

Sam

——————————
Sam Clark
Business Systems Analyst
Team Technologies
Morristown TN
——————————
——————————————-

[Amy Axness]

Thanks everyone for the responses!  I was able to get it to work with the excel add-in.

——————————
Amy Axness
Controller
J&D Manufacturing
Eau Claire WI
——————————
——————————————-

[Archive User]

For future reference Amy, I’m almost positive that issue was resolved in CU7.  DIXF is generally better at handling larger data volumes than Excel Add-Ins but as you undoubtedly found, Excel can be a handy alternative.  Glad you found something that works.

——————————
Jessie Swartz
Senior Functional Consultant
Stoneridge Software Inc.
Minneapolis, MN
——————————
——————————————-

[Archive User]

Hi Amy,
I’m almost positive I’ve seen this in CU6 before and that it’s a bug resolved by a hotfix.  I can’t seem to find the bug/KB number in LCS though.
Jessie

——————————
Jessie Swartz
Senior Functional Consultant
Stoneridge Software Inc.
Minneapolis, MN
——————————
——————————————-