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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Configuration Package - Config. Field Mapping - Set Currency LCY

(0) ShareShare
ReportReport
Posted on by 5

Hey. 

I am trying to import customers to Business Central through an Excel Configuration Package. I am using Config. Field Mapping to map field values to BS. But I am having a little difficulties - specifically with currencies.

I would like to map the Excel Currency value "DKK" to the LCY of BC (Blank Value)

I have tried the below mapping (a a number of other combinations) - But the import seems to ignore it.

I get the following error on all Excel Records with Currency "DKK" - "The field Currency Code of table Customer contains a value (DKK) that cannot be found in the related table (Currency)"

Any Ideas?

  • Jun Wang Profile Picture
    8,220 Moderator on at

    The error message you receive indicates that the Currency Code "DKK" cannot be found in the related table "Currency." This error occurs because Business Central expects to find a corresponding entry for the currency code being imported in its Currency table.

    To resolve this issue, you can follow these steps:

    Open Business Central and navigate to the Currency table.

    Verify that the Currency Code "DKK" exists in the table. If it doesn't exist, you need to add it as a new currency.

    If the Currency Code "DKK" already exists, ensure that it is spelled correctly and that there are no extra spaces or special characters.

    Double-check the field mapping in your Config. Field Mapping setup. Make sure that the column in your Excel file containing the currency values is correctly mapped to the Currency Code field in Business Central.

    If the mapping appears to be correct, ensure that the Excel column for currency values does not contain any additional formatting or characters that could cause the mapping to fail.

    Retry the import process with the updated currency mapping and check if the issue persists.

    By following these steps, you should be able to import customers with the currency "DKK" successfully into Business Central.

  • JM-22040758-0 Profile Picture
    5 on at

    I have already verified that - and it works when I put in DKK as the currency table. However, I have been told that you are not supposed to enter your LCY currency into the currency table in BC, as a blank currency value is the equivalent of LCY. Or am I mistaking?

    If it is correct, I need to put a blank value onto our LCY (DKK) customers. But I am not allowed, as described above.

    learn.microsoft.com/.../finance-currencies

  • JM-22040758-0 Profile Picture
    5 on at

    Any thoughts on this? Or am I not expressing myself properly? :-)

  • Suggested answer
    Jun Wang Profile Picture
    8,220 Moderator on at

    check the local currency setup on the general ledger entry if it is correct. below is an example

    in theory, you don't need to put the LCY in the currencies. Check with your partner or dev to debug and find out why it behaves that way. 

    you could put in the LCY code as a workaround. I don't think it affects anything other than make BC happy. 

  • JM-22040758-0 Profile Picture
    5 on at

    Hi. 

    I have already checked my general ledger setup and it looks correct ("DKK" set as LCY). 

    I will contact my partner and see if they have any ideas.

    Thanks for the help :-)

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans