Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Configuration Package - Config. Field Mapping - Set Currency LCY

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?

  • JM-22040758-0 Profile Picture
    JM-22040758-0 5 on at
    RE: Configuration Package - Config. Field Mapping - Set Currency LCY

    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 :-)

  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,435 Super User 2024 Season 2 on at
    RE: Configuration Package - Config. Field Mapping - Set Currency LCY

    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
    JM-22040758-0 5 on at
    RE: Configuration Package - Config. Field Mapping - Set Currency LCY

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

  • JM-22040758-0 Profile Picture
    JM-22040758-0 5 on at
    RE: Configuration Package - Config. Field Mapping - Set Currency LCY

    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

  • Jun Wang Profile Picture
    Jun Wang 7,435 Super User 2024 Season 2 on at
    RE: Configuration Package - Config. Field Mapping - Set Currency LCY

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans