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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / DMF financial dimensio...
Finance | Project Operations, Human Resources, ...
Suggested Answer

DMF financial dimension issue

(0) ShareShare
ReportReport
Posted on by AX Fourms 77

when i upload DMF it says financial dimension XXX doesn't exist although it's exist in the system and exist in setup of the application for the excel format

any help please 

  • Suggested answer
    OsmanIstanbul Profile Picture
    OsmanIstanbul 2,820 on at

    Hi,

    please verify your financial dimension values. It probably contains a not valid value. check your dimensions sequence also, it should match with the excel format setup.

    Best

  • AX Fourms Profile Picture
    AX Fourms 77 on at

    i opened the debugger i found that the code go throw this class

    DMFDimensionHelper::generateDynamicDimension( "MyLedgerDimension with "-" separator ") like "120012-BU01-export"

    then validate the value from this table

    DimensionAttributeValue::findByDimensionAttributeAndValueNoError(_dimensionAttribute, _dimensionValue, false, true);

    and here he gives that error as i said although the dimension value exist in financial dimension

  • real_ashwin Profile Picture
    real_ashwin 1,229 on at

    What are you importing via DMF what entity ?

  • AX Fourms Profile Picture
    AX Fourms 77 on at

    i import Budget

  • real_ashwin Profile Picture
    real_ashwin 1,229 on at

    In your source data format can you share screenshot of "application" tab so we can see what is defined for the dimensions. Also can you share your Accounting structure to see the dimensions used.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,283 Super User 2026 Season 2 on at

    Hi AXFourms,

    Ashwin mentioned the 'Source data format'. On the second tab, you can indeed specify which dimensions in what order will be provided in a source file or should be exported in that format. Check if this matches your string with dimension values and if the separator is correct.

  • AX Fourms Profile Picture
    AX Fourms 77 on at

    Hi Andre

    all setup is okay dimension in Application Tab with separator

    i checked the account structure from the ledger everything is okay but as i said

    i opened the debugger i found that the code go throw this class

    DMFDimensionHelper::generateDynamicDimension( "MyLedgerDimension with "-" separator ") like "120012-BU01-export"

    then validate the value from this table

    DimensionAttributeValue::findByDimensionAttributeAndValueNoError(_dimensionAttribute, _dimensionValue, false, true);

    and here he gives that error as i said although the dimension value exist in financial dimension

    and i found that the DMFDimensionHelper::generateDynamicDimension method reads financial dimension for the main account different from the finanical dimension which is in the account structure

    for example main account X should follow costcenter in accountStructre

    the DMFDimensionHelper::generateDynamicDimension see the main account should have value from the financial dimension BusinessUnit

    i tried to add the value of the costcenter in businessunit it doesn't give the error but it publish without dimesnion value only main account

    i tried to create new account structure .. and also tried to remove the exist structure and add again to the ledger but same issue exist

    any help ?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,283 Super User 2026 Season 2 on at

    Can you share a screenshot of the dimensions setup on the source data format and a screenshot of the account structure? It is correct that the DMFDimensionHelper is using the dimensions different. You can have multiple account structures with different dimension setup. Also a source file can contain multiple main accounts and different account structures. For that reason, you need to setup the dimensions on the source data format for the whole import.

    E.g. you have two account structures:

    A: Main account - Business Unit - Department

    B: Main account - Cost center - Business unit

    To be able to load a file supporting these different setups and take care of all three dimensions, you need to setup the source data format like this:

    Main account - Business Unit - Cost center - Department.

    In case of a main account for A, you can then use the next string: "120012-BU01--export". Here the value for the Cost center is empty.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 523 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 408 Super User 2026 Season 2

#3
CU10121822-0 Profile Picture

CU10121822-0 354

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans