Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error when you generate a report in Management Reporter: "Currency USD does not exist for company"

Error when you generate a report in Management Reporter: "Currency USD does not exist for company"

View products that this article applies to.

Symptoms

When you generate a report, you receive the following error message:

Currency USD does not exist for company xxxx. No values will be returned.

↑ Back to the top

Cause

This is caused by the way the currencies configured in Dynamics GP are recognized differently between the Legacy provider and the Data Mart provider.

The legacy provider will recognize a currency from Dynamics GP based on the Currency ID set for the currency. The default currencies for the TWO company include IDs such as "Z-US$".

The data mart provider will recognize a currency from Dynamics GP based on the ISO Code set for the currency. The default currencies for the TWO company include ISO Codes such as "USD".

↑ Back to the top

Resolution

In the column definition, check the Currency Display cell in the FD columns.  If you are using the Data Mart provider, you should see USD and not Z-US$. 

In the tree definition, check the Company.  If the companies are set to Legacy company (the company code includes -Curr), the Currency Display in the column should be set to use the currency for the Legacy provider, such as Z-US$.  If the companies are using Data Mart, then the Currency Display in the column defintion should be USD.

If you switch from the Legacy provider to the Data Mart, you can run the script below to check your columns for any that will need to update the Currency Code.  You will need to update data mart database name in the script.  


select CCM.Name as ColumnDefinition, CSS.Name as BuildingBlockGroup
from ControlColumnCriteria CCC
join ControlColumnDetail CCD on CCC.ColumnDetailID = CCD.ID
join ControlColumnMaster CCM on CCD.ColumnLayoutID = CCM.ID
join ControlSpecificationSet CSS on CSS.ID = CCM.SpecificationSetID
where (CCC.CriteriaType = 8 or CCC.CriteriaType = 7)
and LOW not in ('FUNCTIONAL','NATURAL/ORIGINATING')
and LOW not in (select Name from 
[DDM-GP]..UnitOfMeasure --<<-- Update name of the data mart database
) 
group by CCM.name, CSS.Name
order by CCM.Name

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 3058400
Revision : 1
Created on : 1/7/2017
Published on : 4/17/2015
Exists online : False
Views : 244