• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Advanced Pricing, Currency - Exchange Rate Date

Dana BY

How to convert price using exchange rate other than for the order's date?

Our sales in USD and also we are adding transportation charges, which are in our local currency.
We store transportation charges in variable table "Transport" and use formula (&TRANSPORT)!USD which converts transportation charges to dollars using exchange rate for sales order's Price Effective Date (which is shipment date or some load date, or some other date sometime, whatever).
Unfortunately now we need to change it, we need to take exchange rate for today's date, I mean, when we are ready for invoicing we need exchange rate to be as for invoice date, not as for shipment date, as it was before.

Is it possible to change formula for it to use current date's exchange rate?

E1 9.2