Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Management Reporter- D...
Microsoft Dynamics SL (Archived)

Management Reporter- Default Base Year in report definition

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello,

I have a client who recently installed Management Reporter.  It is not the newest build.  When they open a report definition, there are the dropdown lists for the Base Period and Base Year in the date information not saved with report definition section.  In the dropdown for base year, the list stops at 2011.  Since their current fiscal year is 2012 I would expect this list to at least show that.  What am I missing here?  How is this list populated or what is it based on?

 

Thanks,

Seth

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter- Default Base Year in report definition

    I have the same issue, too.  Ran the script above which shows 2011, 2012 and 2013, exactly as it should, since those are the only years with data.  However, Report Definition Base Year combo box shows 2006 - 2012.  It's missing 2013.  In spite of that, reports run with Base Year = 2012 return data for 2013.

  • Deb Davis Profile Picture
    Deb Davis 1,515 on at
    RE: Management Reporter- Default Base Year in report definition

    I am getting the same issue, but I am seeing the last fiscal year as 2009. The fiscal year is 2013.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Management Reporter- Default Base Year in report definition

    I have since upgraded the client to MR 2012 but I am still seeing the same issue.  The last date available to choose is fiscal year 2011.  Any thoughts?

  • Lee Brockney Profile Picture
    Lee Brockney 30 on at
    Re: Management Reporter- Default Base Year in report definition

    I am having the same issue, I have closed off the year (2012) in GP10 and have all my 2013 periods set up but I do not see 2013 available for me in the drop down.  I need to start issueing budget reports for 2013 but cannot do so without being able to select the right base year.   The odd thing is that when I use the drop down for the default base period and select last closed period it brings up 12/31/2011.  Every period in 2012 has been closed.....  Any ideas on this?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Management Reporter- Default Base Year in report definition

    Hello Cory,

    Thank you for the reply.  I finally was able to get the results of the sql script you suggested.  Years 2012 and 2013 both appear on the results list so that would indicate based on your explanation that data has been posted to those two years.  Do you have any other thoughts on why the Base Year would not included these values?

  • Cory Severson Profile Picture
    Cory Severson 695 on at
    Re: Management Reporter- Default Base Year in report definition

    Hello Seth,

    MR runs one of the following 2 queries based on your version to get the years.

    SL 2011 RTM provider version: 8.0.20321.00

    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'

    SL 2011 SP1 Provider version: 8.1.21108.1

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

    If the year doesn't show up in the list then it may be data has not been posted to it.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans