Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Michael Connolly]

We have a AP batch with a transaction that contains an error, which is “exchange rate has expired.” In this case, the Trx doc date is after the exchange rate expiry date. Can we extend the expiration date for the applicable exchange rate, to say the end of 2017, without causing other issues in the system (Dynamics GP 2013)? — Thank you in advance!

——————————
Mike Connolly
ERP Admin
MPS Group, Inc.
Farmington Hills, MI
——————————

[Vaidhy Mohan]

Hi Mike,

Usually in such cases, we take an approach to select most recent exchange rate in the system and post the transaction, instead of touching the exchange rate table. This works well if the rate does not fluctuate much. You won’t have asignificantgain/loss.

However, if therateis highly fluctuating, you mayoverride the exchange rate on the transaction by simply changing the rate with a least decimal value and not add that to the exchange table. For instance, if the expired exchange rate on the transaction is 0.0897, you may simply override that with something like 0.089701.

I’d probably update the exchange table only if it is necessary and unavoidable.

——————————
Vaidhy Mohan
Senior Consultant | Scope Systems
Perth, WA
——————————
——————————————-