Data management – financial dimensions’ import

Posted by

Dynamics 365 For Operations is using the « Data Management » module to import data for migration or to interface them from external tools.

In this article, I want to explain the Financial dimensions import rules related to the below Data Import error.

Results. The number of dimension values specified in **OffsetAccountDisplayValue** is different from the number set up in the active format for data entities.

Things to try:

  • Make sure the number of dimension values specified matches the active format for data entities.
  • Make sure that any dimension values specified that include the chart of accounts delimiter character in the name escape the delimiter character with a backslash character ‘\’.

Results. Error found when validating record.

For GL transactions, you will probably need to setup a general ledger account in the specific field including « GL acc. + dimensions ». The question is how to interface this field to import data.

For the Data Management tool, the field « OffsetAccountDisplayValue » or *AccountDisplayValue according to the entity will work following the setup in :

AX > General ledge > Chart of accounts > Dimensions > Financial dimension configuration for integrating applications

 

The GL accounts are setup above for a GL Acc. and three dimensions in the interface, whatever of the ledger account type.

For my below sample, I was not needing GL dimensions, as a result, you should add 3 « – » without any data between each of them (or with value depending of your case).

The below file is working for Contoso FRSI.

 

Jonathan Lascaux

Leave a Reply

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *