Currency value from posted shipment remains

(1) Share

Report

Posted on by Frida_Admotion

387

We have a problem with currency on the invoices:

Scenario as follows:

2024-02-07 In the morning, we post today's shipments. The posting date is set for today. The currencies are still for 2024-02-06.
2024-02-07 In the afternoon, the currencies is updated for 2024-02-07 (The Swedish National Bank releases the currencies at 16.15)
2024-02-08 Next day, time for invoicing. The posting date is not touched, since we want to have the same date as the posted shipment as the invoicing date.

Problem: On the invoice, the currency value from the posted shipment appears, which was the currency value 2024-02-06,. This in spite of the fact that we have posted the invoice after the curreny is changed for the actual posting date.

If we choose to manually /update/ the posting date from 2024-02-07 to 2024-02-07 again, Business Central reads in the new currency value.

Is there a solution to this problem? It seems reasonable that BC checks for the currency at every posting.

Due to tax rules we need to have todays currency value on the invoices.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Valentin Castravet 32,689 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The way the system works is that when you add a currency code to a document or journal line it will check the posting date of the document/journal line, and then the system will look at the currencies table for the fx rate valid for that posting date. It will then bring that fx rate to the document or journal line. This search is only triggered when the posting date or currency code is changed, it doesn't get triggered during posting.

So in your case the only way to update the fx rate is to manually change the posting date as you've been doing. The other option is to manually change the fx rate on the document.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 100,850 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Valentin is right, this value is only updated when posting date, currency code is modified.

You can make a small customization, create a button, call the following function, and update manually

Hope this helps as well.

Thanks

ZHU

Was this reply helpful? Yes No
Frida_Admotion 387 on at

Like (0)

Report
Copy link

Link copied!

Hi! Thanks for your answers even though I am not at all happy that they confirm what I thought.

I think it would be appropriate that there is a currency check with the actual posting.

It is what is, we just have to find a way to deal with it.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,216 Moderator on at

Like (0)

Report
Copy link

Link copied!

I guess you know how to manually change the currency rate, but in case other readers need it. click on the ... then change.

Was this reply helpful? Yes No