Is this a Data Mart or Legacy install of MR? If this is Data Mart and the account is not translating at all, there some script you can run against the Data Mart database to see what Translation Type the account is using.
select * from datamart.Organization
--find Id for your organization. Use it for the OrganizationId in the next query.
select * from datamart.DimensionDefinition where OrganizationId = 2
---find Id for the main segment. Use it for the DefinitionId in the next query. The Name value will be the main segment for the account.
select * from datamart.DimensionValue where name = '1100' and DefinitionId = 2
--find Id for account. Use it for the Id in the next query.
select * from datamart.Account where Id = '537'
The results here will show the CurrencyMethod. If it is set to 0 (unknown), MR won't translate the amounts for that account. This can happen if the account does not have a Currency Translation Type in the MC00200 table. You could run this statement to check that:
SELECT * FROM GL00100 WHERE ACTINDX NOT IN (SELECT ACTINDX FROM MC00200) AND ACCTTYPE = 1
If you're using the Legacy provider, check the GL20001 table. You can search by ACTINDX. If there is a record for the account, go to Cards | Financial | Account. Click Currency and then change the translation method from Current to Historical. You'll likely get a message about rates being lost. You won't lose your actual exchange rates, so you can click Yes to the message. Save the account and then change it back to Current.
