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

Configuration Package - Config. Field Mapping - Set Currency LCY

(0) Share

Report

Posted on by JM-22040758-0

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?

All responses (5)

Answers (0)

JM-22040758-0 5 on at

Like (0)

Report

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 7,443 Super User 2024 Season 2 on at

Like (0)

Report

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 5 on at

Like (0)

Report

RE: Configuration Package - Config. Field Mapping - Set Currency LCY

Any thoughts on this? Or am I not expressing myself properly? :-)
JM-22040758-0 5 on at

Like (0)

Report

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 7,443 Super User 2024 Season 2 on at

Like (0)

Report

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.