Management Reporter Columns Rolling Forecast

(0) Share

Report

Posted on by Marianna

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

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

guk1964 10,888 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No