Error message in Microsoft Management Reporter: “ The company calendar couldn't be retrieved from the source system”

Symptom

When you set a company as default in Microsoft Management Reporter for Dynamics SL, you receive the following error message:


The company calendar couldn't be retrieved from the source system.

Cause

Cause 1

There is a bug in the SL data provider with having a leap year.  See Resolution 1 in the resolution section.


Cause 2

The company has no posted transactions.  See Resolution 2 in the resolution section. 

Resolution


Resolution 1


This bug is fixed with Management Reporter SL SP1 data provider that is installed as part of the Dynamics SL2011 SP1 update.


1. Browse to C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.0\Providers\SL

2. Verify the version of the SL Data Provider .dll

3. For SL2011 Version 8.00.20321.00 run the following SQL select statement against the SL Application database. 

SELECT pernbr, RetEarnAcct, FiscalPerEnd00, FiscalPerEnd01, FiscalPerEnd02, FiscalPerEnd03, 
FiscalPerEnd04, FiscalPerEnd05, FiscalPerEnd06, FiscalPerEnd07, FiscalPerEnd08, FiscalPerEnd09, FiscalPerEnd10, FiscalPerEnd11, FiscalPerEnd12,
BaseCuryId, NbrPer, PerNbr, BegFiscalYr FROM .dbo.GLSetup where FiscalPerEnd00 > '0'



  • If a date of 0229 exist in any of the FiscalPerEnd columns log on to Dynamics SL and update the Period to 0228.

  • This can be changed back to 0229 as soon as SL SP1 with MR SL SP1 data provider is applied.



4. For SL2011 SP1 Version 8.01.21108.01 run the following SQL select statement against the SL Application database to validate transaction dates.

SELECT fiscal_year from .dbo.vw_gltran union select fiscal_year from .dbo.vw_accthist order by fiscal_year 


5. If any years are returned that are incorrect or not in order, the transactions that have those bad dates must be deleted or corrected. The following select statement can be used to help find the problem transactions. The PerPost column is slightly past mid-way through the table.

SELECT * from gltran order by perpost





 
Resolution 2

Run the following statement:

SELECT fiscal_year from .dbo.vw_gltran union select fiscal_year from .dbo.vw_accthist order by fiscal_year 


If no data is returned, MR will be unable to create reports. You must post a transaction before reports can be created. Once transactions are posted, the gltran table will be updated with fiscal period information. MR will then be able to read the periods and create a report.

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.

×