How FBO One selects exchange rates


If you create a handling order or a quote for a customer that is billed in a foreign currency, what is the rate of exchange that is applied on the receipt or the quote?


To lookup the correct exchange rate for an order, FBO One applies the following logic to obtain the transaction date. The transaction date is then used to lookup the exchange rate in the exchange rates table.


  1. If the order has products flagged with UseDeliveryDateAsCurrencyConversionDate (typically used for fuel uplifts) then the most recent uplift drives the transaction date
  2. Else if the order is invoiced, the transaction date is set to the invoice date
  3. Else the transaction date is set to the current local time at the order's handling station. As you can't predict future rates, this is your best value.

When a credit card payment has been taken for an order, typically the order is paid in full and the amount due to the order will be 0. It can happen that after this final payment, one or more days pass before the invoice is created. Only when an invoice is created, is an order consider to be read-only and static. This leaves a window of time where the amount due could become non-zero again, because of a new exchange rate coming into effect. To mitigate this scenario, will force the amount due to zero in case the last payment resulted in a 0 amount due, and that is still the cause when recalculating the order against the transaction date of the last payment.


See also