News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Management Reporter Co...

Microsoft Dynamics AX (Archived)

Management Reporter Columns Rolling Forecast

(0) Share

Report

Report

Posted on by Marianna

20

Hello,

we would like to setup a report using MR to show the Cashflow forecast on a rolling basis - from now to the next 12 months. This independently from the fiscal year. Is there a way to setup the columns so that they do not need to be changed every month?

Example: I am now in month 6 of fiscal year 2019 - and would like to have a column for each of the following 12 months. Fiscal year will end in December. I imagine that starting from January the setting with Fiscal Year "base" will not give me Jan 2020 values as desired.

Thank you!

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Management Reporter Columns Rolling Forecast

Hello Marianna,

You can find some examples how such rolling reports can be created in the default column definitions that ship with the MR.

I added you some screenprints for your reference

With such a setup you don't have to change the column definition configuration every year.

The only thing required is running the report for the current period; the rest is calculated by MR.

Best regards,

Ludwig

P.S. Some additional information on report creation can be found for example on youtube. Have a look at the videos available there.
Suggested answer

guk1964 10,877 on at

Like (0)

Report

RE: Management Reporter Columns Rolling Forecast

Do yourself a favour and invest in Jan Harrigan;s booklets - www.frxbuzz.com/got-management-reporter

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans