This article troubleshoots an error that occurs when trying to use the Calculate Rates option in the Currency section of the Data Warehouse Manager
When a user tries to use the Calculate Rates, they receive the following error message:
"Error in Calculating Rates"
This issue can occur when the code for the entity with memberid -1 is changed to something other that No Member. Most often this is changed to Null or NA.
To confirm that this is the problem, in SQL run 'select * from d_entity' on the Data Warehouse database. If code for entity with memberid -1 is anything other than NO MEMBER, edit the row to match the image below.
*Always make sure you take a backup of the database before making any changes.
Data Warehouse Manager 4.x