Sending "blank" value of Currency Code using Edit in Excel function

(3) Share

Report

Posted on by AntonioKD

432

Hello guys!
I have a question for you my experts.
I have Customer, who has default currency code set to USD on its card.
I want to use Edit in Excel function to send some General Journal lines and when I use this Customer as an account and send BLANK value in currency code (I want to use local currency, so I send blank value, I don't want to use default USD for this customer) unfortunatelly system updates Currency Code on General Journal and download default USD from Customer Card. So I need to use Edit in Excel once again to edit created lines in currency code field.

Is it any other way, to send BLANK value of Currency Code field to general journal lines using edit in excel functionality, which will omit updating currency code from Customer card?

Thank you in advance! :)

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Yi Yong 2,612 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

This is because if you keep the cell empty and publish it, the currency field are validated by the customer master data and the currency code was assigned over.

You can simply put a empty space ("space-bar") on the currency code cell in excel.

Was this reply helpful? Yes No
Verified answer

Jainam M. Kothari 15,666 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

I Do Agree with Yi Yong.

Business Central defaults to the customer's currency code (USD) when you leave the currency code field blank in the General Journal lines using the Edit in Excel function. This happens because the system validates the currency field based on the customer master data.

One workaround is to enter a space character in the currency code cell in Excel instead of leaving it completely blank. This way, the system won't automatically fill in the default currency code from the customer card.

Or Else you need to Customize the same.

Was this reply helpful? Yes No
AntonioKD 432 on at

Like (1)

Report
Copy link

Link copied!

Thank you - using "space" works :)

Was this reply helpful? Yes No