Microsoft Dynamics AX (Archived)

Financial dimension value 6501 does not exist when use DIEF

(0) Share

Report

Posted on by Community Member

We use Dynamics AX2012 R3 CU8

I'm trying to do a load balance test using the DIEF: follow the journal

Debit Bank Account Financial Dimentions Cost center, Department, Purpose

$1.00 1234567890 11111111.22222222.00000000

Credit Ledger Account Financial Dimentions Cost center, Department, Purpose

$1.00 6501-02-09-00-00 10000141.10000142.00000000

Source data formats as follow:

Account structure as follow:

CSV as follow

The Staging data execution process of DIEF it does load the staging table, but when the Target data execution is process, the following error occurs

"Financial dimension value 6501 does not exist."

All ledger accounts and dimention vales are in database

Thanks for help

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Sort by

RamK 2,580 on at

Like (0)

Report
Copy link

Link copied!

Are you sure that account 6501 is part of Account Structure...? Can you please add this account explicitly in Account structure and try it...? Do you have any Advanced rule tied up with account structure...? What is the account structure associated in Ledger form...?

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report
Copy link

Link copied!

It looks me your sequence wrong.

Main-Cost-Dept-Pur

6501-02-09-00-00

It should be 6501-02-09-

Hope you don't have any advanced rule.

Hope 6501 main account exist in your execution company.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ram

.- The ledger account is part of the Structure, it was defined as follow:

.- We have no any Advanced rule

.- And the account structure associated in Ledger form as follow:

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Bhaskar:

Ledger account is 6501-02-09-00-00

and Dimentions as follow

Cost Center Department Purpose

10000141 10000142 00000000

We have no any Advanced rule

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report
Copy link

Link copied!

Please ignore my previous comments. Your format is correct. Just I overlook your source data format setup.

I think, this type of main account import is not possible with DIXF.

Could I get your GL ledger dimension screen data when you are entering same data manually.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Follow manually entering for ledger account

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report
Copy link

Link copied!

My assumption was correct. Please change the separator as * or others and check.

6501*02*09*00*00-10000141-10000142-00000000

Was this reply helpful? Yes No
Verified answer

5400 7,162 on at

Like (0)

Report
Copy link

Link copied!
This issue got fixed in R3 cu9 or some hotfix has released for same.

if you want to fix the issue u have to change one line code in class

\Classes\DMFDimensionHelper\generateDynamicDimension line number 46.

It is only workaround for your data set. Permanent fix you need hotfix or Cu9.

dimValueList = str2con(dimValueString, enum2str(SystemParameters::find().ChartOfAccountsDelimiter),false); Change Code: dimValueList = str2con(dimValueString,'.',false);

Ledger Dimension:
6501-02-09-00-00.10000141.10000142.00000000

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Bhaskar

you have the right hotfix? the customer does not plan to update the CU9

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Bhaskar

Code change worked properly, but I think that the hotfix is the right solution.

Thanks a lot for your help.

Was this reply helpful? Yes No