Management Reporter drilldown to Dynamics GP allows you to drill down to transaction and source document detail in Dynamics GP, from your financial statements. This will save you a lot of time when analyzing financial statements.
There are a few requirements:
You must be using the Data Mart Integration to Dynamics GP with Management Reporter. This is an option that is available in the Management Reporter Configuration Console.
This little item consumed a lot of my time; don’t let it get you. And to repeat, if you’re not following Mahmoud AlSaadi on a regular basis, start doing so today.
For any Report Definition you must select the Financial, Account, & Transaction Detail Level.
Once you generate the report you will need to view it in the Management Reporter Viewer in order to drill down to Dynamics GP. In the viewer you can select the line of the report you want to drill down on, and this will show you the accounts that support the line on the financial report. You then select the amount you’re interested in, and click on the Dynamics Drilldown button in the ribbon at the top of the screen. This will open up the inquiry screen in Dynamics GP that will allow you to access transaction and source document detail.
This is a quick video that shows this in action: