web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter 20...
Microsoft Dynamics GP (Archived)

Management Reporter 2012 CU7 - The year is outside the allowed range

(0) ShareShare
ReportReport
Posted on by John Olley 365

When trying to run any Management Reporter report, I'm getting the following error. We are using Dynamics GP 2010 (11.00.2164) and this is a new MR install with a fresh migration from FRx to MR 2012. The migration went fine and a few reports errors have been fixed to work in MR 2012. For some reason, we are getting this error and I can't figure out what's happening.

Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> System.ArgumentOutOfRangeException: The year is outside the allowed range.  \r\n

Minimum year allowed: 1000 \r\n

Maximum year allowed: 9999

Parameter name: currentYear

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLCalendar..ctor(Boolean isDefault, String name, Int32 currentYear, Int32 currentPeriod, GLFiscalYearCollection years)

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.CalendarAccess.RetrieveResultFromCache(IList`1 cacheItem, GLRequest request)

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.GLProvider.GetCalendars(GLCalendarRequest request)

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLSystemProvider.HandleRequest(GLCalendarRequest request)

  at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemRequest.Handle[TRequest](SourceSystemProvider provider, TRequest request)

  at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)

  --- End of inner exception stack trace ---

  at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)

  at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.HandleSubmit(SourceSystemRequest request)

  at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemConnection.Submit(SourceSystemRequest request)

  at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.SubmitRequestDirect(SourceSystemConnection connection, GLRequest request)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ProviderLink.SubmitRequest(GLRequest request, ProviderConnection context)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ProviderLink.GetGLCalendarCollection(ProviderConnection context)

  at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportGenerator.PopulateConnections(CompanyCollection companies)

*This post is locked for comments

I have the same question (0)
  • Verified answer
    John Olley Profile Picture
    John Olley 365 on at

    Just in case anyone else is getting this similar error, this fixed my problem. 

    1. Start GP and log in as 'sa'.
    **You will want to check the following setup for all companies but if the report in question only references one company, that is the place to start.
    2. Go to Microsoft Dynamics GP -> Tools -> Setup -> Company -> Fiscal Periods.
    3. Note the Historical Year checkbox in the top-right. For each year that checkbox is not checked, at least one of the Financial series periods also needs to be unchecked.
    4. After making changes, you will need to refresh the data mart integration if you are using that. If you are using legacy, skip to Step 5.
    A. Close all instances of MR and back up the MR database.
    B. Start the Configuration Console and click on the integration under ERP Integrations.
    C. Click the Disable Integration button and wait a moment for that to take effect.
    D. Click the Remove link in the top-right.
    E. Stop the MR services at the top level of the Configuration Console and then delete the DDM database from SQL.
    F. In the Configuration Console, start the MR services and then click File -> Configure and deploy a new DDM integration.
    G. Enable the integration and wait for the initial load to complete. This can take a while depending on your data and server speed.
    5. Start MR and try the report again.

    In my case, when I brought MR 2012 back up, all my reports were missing. You have to reset the Building Block Group. If you start MR and go to Company -> Companies, you can click Modify to set the correct Building Block Group. This brought back all my reports after I chose the correct group.

    After this my reports ran without this error.

    Enjoy!

    John Olley

     

  • Jason Jones Profile Picture
    Jason Jones 55 on at

    I followed Steps 1-3 as outlined above by John Olley.  I was then able to generate MR reports again.  I did not have to complete the refresh Data Mart steps.  Using MR version 2.1.7044.43

  • John Olley Profile Picture
    John Olley 365 on at

    I'm really glad to hear that helped you Jason. I wasn't sure if steps after 3 needed to be completed either, but I just followed what the MS Support Rep told me to do just in case. Good to know it's not "necessary" all the time. Definitely worth checking before deleting and re-creating. Thanks for sharing.

  • Community Member Profile Picture
    Community Member on at

    I am in the exact situation, new install, etc.  I followed the instructions above, got all years corrected but still get an error .  if you take the tree off, each company runs fine, even it is has not had activity for 2 years you still get a balance sheet, but when you put the tree on you get the error again-- year out of range.

    I did the audit trails rebuild, I am going to do new trees, but with 140 companies it is a long process.

    is there ANYTHING else to look at.  I opened a case with Micorosoft, but of course have not heard back yet!

    I would appreciate hearing from anyone.

    thanks very much

    Carolyn

  • John Olley Profile Picture
    John Olley 365 on at

    Are you doing currency translations? If so, you need to setup Legacy if you are using CU7. If you upgrade to CU8, then it should be fixed in there. I haven't tested that yet so I am not 100% sure if it fixed that or not. It says it did in the notes. If you need to keep CU7 for what ever reason, you need to setup Legacy to do the currency translation. CU8 will allow you to use Data Mart to do the currency translation without errors.

    Make backups before you do any updates!!!

    Download CU8:

    mbs.microsoft.com/.../MROverview

    Thanks,

    John Olley

  • Keith Vogt Profile Picture
    Keith Vogt on at

    If you can, try to isolate the error to a specific company. Typically, there's just a setup issue or something missing for one company that can cause the issue.

    I'd start with the newly added companies in the tree, or any companies that recently had their fiscal periods changed.

  • Community Member Profile Picture
    Community Member on at

    Hi John,

    Glad you ran into this and shared your troubleshooting steps. The fiscal periods all being checked was same root cause for us having that issue, and voila once resolved the reports worked again. Funny that Microsoft CustomerSource / PartnerSource don't have any hits on the error message, yet a Google search returns this nice quick fix.

    Thanks,

    Greg

  • Community Member Profile Picture
    Community Member on at

    I have the same error message. I can run a Balance Sheet (no tree) for 2017 but I can't run an Income Statement (tree w/company defined) for 2017. I have checked my fiscal periods and the financial series is open for both January and February of 2017. Any other suggestions?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans