web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 410
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,429 Super User 2025 Season 2 on at
    Sending "blank" value of Currency Code using Edit in Excel function
    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 12,126 Super User 2025 Season 2 on at
    Sending "blank" value of Currency Code using Edit in Excel function
    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 410 on at
    Sending "blank" value of Currency Code using Edit in Excel function
    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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,160

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,943

#3
Sumit Singh Profile Picture

Sumit Singh 2,823

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans