Management Reporter Base Year Different to GP Fiscal year

(0) Share

Report

Posted on by Ian Grieve

22,782

I think the answer is no, but I wondered if someone could confirm. We have aclient who has Fiscal Years set up in GP as year starting (e.g. 2013 is year 01 Apr 2013 to 31 Mar 2014) but in Management Reporter this same year is selectable as 2014.

Can this be controlled anywhere so they are the same year (i.e. 2013) in both products?

*This post is locked for comments

All responses (5)

Answers (0)

Linda Brock 2,990 on at

Like (0)

Report

RE: Management Reporter Base Year Different to GP Fiscal year

Thanks Mickey - fingers crossed . . .
Community Member Microsoft Employee on at

Like (0)

Report

RE: Management Reporter Base Year Different to GP Fiscal year

Using the Legacy option fixes the issue as it goes direct to Dynamics GP instead of using a view to calculate the Fiscal Periods (which DDM does). May be fixed in CU8 but still waiting on release notes for this.

Mickey
Ian Grieve 22,782 on at

Like (1)

Report

RE: Management Reporter Base Year Different to GP Fiscal year

Linda,

Yes this does seem to be a feature of the datamart. The MS Connect suggestion posted by Lisa is for correcting this issue.

Ian
Linda Brock 2,990 on at

Like (1)

Report

RE: Management Reporter Base Year Different to GP Fiscal year

Am I understanding the issue correctly? My client is on MR 2.1.7044.43 and they use the data mart. Their 2014 fiscal year starts on 12/30/2013 and ends on 12/28/2014. When they print their reports in MR it calls the base year 2015. The reports pull the correct data except when we pull the @fiscalyear in the column header. Is this a data mart "feature??" Thanks.
Lisa Payment 65 on at

Like (0)

Report

RE: Management Reporter Base Year Different to GP Fiscal year

Vote to have the DDM fiscalcalendarview match GP. connect.microsoft.com/.../mr-datamart-use-same-periods-as-gp-on-a-4-4-5-fiscal-calendar