Issue

In Sage Pro ERP entering or saving a transaction (like a payable invoice) results in the following error message:

Unhandled Exception Error 1988 Currency Out of Range

This occurs even though the Multi Currency (MC) exchange rate between the buy and sell rate is set correctly. This article will provide a couple of known causes and solutions for the error.

Important This error can also occur when not using MC if there is data corruption in the tables.

Solution or Workaround

Solution 1 If MC is being used the error may result from the exchange rate value exceeding the field length limit. To correct the issue open the MC application and review the exchange rates setup in the Company Currency Maintenance screen. This can also be checked during a transaction by clicking on the Currency Detail icon (magnify glass icon) next to the Currency field. Ensure the exchange rate being used is the correct value and the length of that value does not exceed the field limit for that data type.

Solution 2 If the MC application is not install or not being used the error may result from data corruption in the tables. This will involve the “B” fields (ie: Bpuramt, Bpayamt, etc.) in the company database (ie: ARMAST, SOTRAN, etc.). These fields might have asterisks (*) or a value that exceeds the field limit. Normally these “B” field values should be the same value as the standard equivalent fields (ie: puramt, payamt, etc.). To correct this issue, the incorrect values in the affected database tables need to be corrected.

If the problem still exists, check other MC fields (i.e. Invrate, Payrate) in the database for similar problems.

Important If MC is not installed or not being used the currency will be USD by default and the values  in the Xxxrate fields should be “1.000000000” .

© Copyright Sage Software