Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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.
Do yourself a favour and invest in Jan Harrigan;s booklets - www.frxbuzz.com/got-management-reporter
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.
P.S. Some additional information on report creation can be found for example on youtube. Have a look at the videos available there.
Business Applications communities