Finance Dimension Value is missing in Ledger Journal Lines after the import from Excel Add-On

(0) Share

Report

Posted on by AB-25071415-0

Hi!

I am importing the Ledger Journal Line in Invoice Journal.

In my import file(Excel Add On) I have all the data(Financial Dimensions) there.

After the import - the value of one financial dimension is missing in Invoice Journal.

In UAT works fine, in Live not. I checked the set up - it is the same.

Maybe somebody can help me.

Thank you in advance.

Regards

Admir

All responses (3)

Answers (3)

Verified answer

Navneeth Nagrajan 1,452 Super User 2025 Season 1 on at

Like (1)

Report

Finance Dimension Value is missing in Ledger Journal Lines after the import from Excel Add-On

Hi Community member,

In the link below there is an important step that states "Upload with same template name 'LedgerJournalLineEntryTemplate.xls' , allow override and then create a general ledger journal and open in Excel and create lines with financial dimensions and then publish". Have you tried this option?

Financial dimensions in Excel with general journal in Microsoft Dynamics 365 Finance and Operations

Happy to answer questions, if any.
Verified answer

Hana Xue Microsoft Employee on at

Like (1)

Report

Finance Dimension Value is missing in Ledger Journal Lines after the import from Excel Add-On

Hi,
Please check the Financial Dimension Configuration (on the Integrating applications page.) and check if the old thread is useful.
Financial dimension configuration - Finance & Operations | Dynamics 365 | Microsoft Learn
Solved: Available field missing from open in excel (dynamics.com)
Best Regards,
Hana
Verified answer

André Arnaud de Cal... 293,245 Super User 2025 Season 1 on at

Like (1)

Report

Finance Dimension Value is missing in Ledger Journal Lines after the import from Excel Add-On

Hi Admir,

Have you also checked the settings on the form Financial dimension configuration for integrating applications (General Ledger > Chart of Accounts > Dimensions)? There might be a difference in the settings here.