Expiration Dates on Exchange Rates

Microsoft Dynamics GPI’ve been doing some work with a US-based company as they implement Microsoft Dynamics GP in Europe for one of their subsidiaries (we do a fair bit of this type of work for expertise with VAT and Intrastat). One of the issues they asked for assistance with was a problem they had while importing transactions.

All of the transactions which were in the functional currency, imported without a problem, but all of those in other currencies failed.

The cause of the problem was actually quite a simple one, and one I have seen before with other clients. On the Multicurrency Exchange Rate Maintenance window, there is an Expiration date field:

Multicurrency Exchange Rate Maintenance

The Expriation Date isn’t the date the rate stops applying, but the date after which the rate cannot be used.

If you try to manually enter a transaction using the rate, you will receive a message stating that the exchange rate has expired, but this error can be swallowed by integration tools:

Microsoft Dynamics GP - The selected exchange rate has expired.

Microsoft Dynamics GP

The selected exchange rate has expired.

It is for this reason, I always recommend manually entering a transaction if it can’t be integrated.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you’d like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

What should we write about next?





Your Name (required) –
Your Email (required) –

Leave a Reply

Your email address will not be published. Required fields are marked *