Error:
The number of dimension values specified in 9999971 is different from the number set up in the active format for data entities.
The mentioned above error was generated when importing the journal entry in Dynamics 365. The error says the account mentioned in the field do not match with the dimensions specified. The screen as below:
Import file has the values as below screen:
All the values are mentioned in file looks proper though it throws the error while import.
Solution:
I tried to import the file multiple times and the error was the same again and again. As in AX 2012 the same data imported without any issue. So what could be issue on Dynamics 365
Then reviewed the Account structure as we set the dimensions with accounts there (General ledger > Char of account > Structure > Configure account structure). In the active account structure on the legal entity (attached in ledger) and allowed blank values is already selected.
After some search and review cause of issue found and the issue on set up of Financial dimension configuration for integrating applications
Verify format define for the ledger dimensions integrations. As on the screen MainAccounts-BusinessUnit-CostCenter-Department. So it is require to follow the format define for import.
