
We are having an issue where some anomalous entries are getting added to our exchange rate table. We have 2 currencies that we use in our country KYD and USD. The exchange rate between the two is always 0.82 so we have a single conversion rate in the table that is effective 01/01/2000 and doesn't expire to 12/31/2050. Something keeps adding new exchange rates of 1.0 to this table which screws up any entries in GL or payables that are in USD. I have removed access to the exchange rate windows from everyone so no one can manually edit the rates so there must be some system process that is automatically adding the 1.0 rate but I have no idea what process might be doing it. We are running Dynamics GP 18.0 plus we use eConnect for integration with our main company app. Can anyone point me to what might create entries in this table?
Example Error
I found the issue is with our bank rec integration. This page www.azurecurve.co.uk/.../ led me to the realization that we sometimes put through transactions in our base currency (KYD) that go to our foreign currency bank account (adjustments are always done in the base currency). I am adding some logic to our integration to convert these adjustments to the foreign currency just prior to integration.