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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Sending "blank" value ...
Small and medium business | Business Central, N...
Answered

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

(3) ShareShare
ReportReport
Posted on by AntonioKD 416
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)
  • Verified answer
    Yi Yong Profile Picture
    Yi Yong 2,555 Super User 2025 Season 2 on at
    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.
     
  • Verified answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,631 Super User 2025 Season 2 on at
    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.

  • AntonioKD Profile Picture
    AntonioKD 416 on at
    Thank you - using "space" works :) 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans