Currency USD does not exist for Company when generating reports in MR

(0) Share

Report

Posted on by malissaj

I just upgraded a customer from FRx to management Reporter. They need one tree to consolidate 2 companies. I setup the tree but when attempting to generate the report, I receive a message:

2/29/2016 12:19 PM Currency USD does not exist for company. No values will be returned.

Neither company in the tree use multi-currency, but the default currency ID is "0000", not USD.

When running for individual companies, the reports are fine, this is only an issue when using a tree.

All the documentation I can find on this are GP related and I don't see how I can override the currency anywhere.

Any help is much appreciated!

*This post is locked for comments

All responses (2)

Answers (0)

malissaj 40 on at

Like (0)

Report

RE: Currency USD does not exist for Company when generating reports in MR

There are no blank curyid's in any of the tables and none of the column settings in MR resolve the issue. I have tried Currency Override, Currency Display and Currency Override in the column definitions.
Butch Adams 4,761 on at

Like (0)

Report

RE: Currency USD does not exist for Company when generating reports in MR

In the column definitions, there are some lines setting the currency. Have you tried setting those?

Also, there is a CuryId field in GLTran that is not supposed to be blank. Run

SELECT * FROM GLTRAN WHERE CuryId = ''

To see if you have any blanks.