Error message when you generate a report in Microsoft Management Reporter: “The company calendar couldn’t be retrieved”

Symptoms

When you generate a report in Management Reporter for Dynamics GP, you receive the following error message:

The company calendar couldn’t be retrieved from the source system

Cause

Cause 1

The data provider version does not match the other installed Management Reporter components.  See Resolution 1 in the “Resolution” section.

Cause 2

The fiscal years or periods have an issue preventing Management Reporter from using the information.   See Resolution 2 in the “Resolution” section.

Resolution

Resolution 1

  1. Confirm the version of MR. You can browse to the folder C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.0\Client and check the version of ReportDesigner.exe.

  2. Confirm the version of the data provider. Make sure that this version matches the MR version from step 1. Browse to C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.0\Providers\Dynamics GP 11.0 and check the version of any of the .dll's in that folder.

The version of the data provider and the MR client must be the same.  If it is not the same, you will have to download and apply the appropriate service pack.  Service packs for Management Reporter can be downloaded here:

https://mbs.microsoft.com/customersource/downloads/servicepacks/mroverview.htm



Resolution 2


  1. Start Dynamics GP and sign in to the company in question as 'sa'.

  2. Click Microsoft Dynamics GP, point to Tools, point to Setup, point to Company and then click Fiscal Periods.

  3. Make sure that there is at least one year that does not have the Historical box marked. This is required for MR.

  4. Make sure that for each non-historical year there is at least one Financial series period open.

  5. Make sure that none of the years or periods have any gaps or overlap.

  6. If there are gaps or overlaps, you must correct this in GP and then you should be able to use Management Reporter again. This would include if there are gaps in the years such as 1999 and then the next year being 2001, you would have to create the 2000 year and populate it with periods. 


Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×