Currency value from posted shipment remains

(1) Share

Report

Posted on by Frida_Admotion

267

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:

Business Central

All responses (4)

Answers (1)

Suggested answer

Jun Wang 7,437 Super User 2024 Season 2 on at

Like (0)

Report

Currency value from posted shipment remains

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

Like (0)

Report

Currency value from posted shipment remains

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.
Verified answer

YUN ZHU 73,339 Super User 2024 Season 2 on at

Like (0)

Report

Currency value from posted shipment remains

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
Suggested answer

Valentin Castravet 24,747 Super User 2024 Season 2 on at

Like (0)

Report

Currency value from posted shipment remains

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.