(For more resources related to this topic, see here.)

Budgets in Management Reporter 2012

The inquiries and report in Dynamics GP for budgets are good but fairly limited in functionality. Fortunately, another range of Dynamics products is available for use to report on budgets.

This is the Management Reporter 2012 financial reporting product. With the Dynamics GP 2013 Starter Pack (the base licensing pack), an unlimited number of administrator, designer, generator, and viewer licenses are available.

Management Reporter allows for the reporting of multiple budgets for periods, ranges of periods, or YTD. In this section, we’ll take a look at producing a fairly simple budget for the Sales division using the 2017 SALES budget created earlier.

Before producing the report, you will need a fully implemented installation of the latest version of Management Reporter 2012 (at time of writing, this is Rollup 6). You also need security access to Management Reporter and a basic understanding of the reporting product.

We are going to cover a fairly simple report in this section in three parts showing how to create the row definition, column definition, and then the report definition, which pulls the first two together into a working report.

Creating the row definition

To create the row definition, follow the given steps:

1. Launch Management Reporter 2012 and log into the Fabrikam, Inc. company as normal.

2. Press Ctrl + Shift + R to create a new row definition.

3. Click on the Edit menu and then click on Insert Rows from Dimensions.

   

4. In the Division column, perform the following steps:

   1. Enter &&& into the Dimensions row.

   2. Enter 300 into the Dimension Range Start and Dimension Range End rows.

5. In the Account column, change the value in Dimensions to ####.

6. Click on OK to close the Insert Rows from Dimensions window and update the row definition.

   

7. Click on Save.

8. Enter BUDGET-SALES in the Name field.

9. Enter Budget – Sales in the Description field.

10. Click on OK and close the row definition.

This row definition is very simple in structure, and will give an overview of the figures for the Sales division. However, with the options on the report definition that we will set later, we’ll be able to drill down and see more details.

Creating the column definition

To create the column definition, follow the given steps:

1. Launch Management Reporter 2012 and log into the Fabrikam, Inc. company.

2. Press Ctrl + Shift + C to create a new column definition.

   

3. Enter Desc in the Column Type in column A.

4. In column B, perform the following steps:

   1. Double-click on the Header 1 cell and enter Sales Budget @FiscalYear in the Column header text and enter B in Spread from and G in Spread to.

   2. Click on Ok to close the Column Header window.

   3. In Header 2 enter 1 to 3, which is the period range that the column will contain.

   4. Enter FD in the Column Type row which defines this column as containing either actual or budget figures from the financial dimension.

   5. Enter 2017 Sales in the Book Code / Attribute Category row to select the required budget.

   6. Enter 2017 in the Fiscal Year row.

   7. Enter 1:3 in the Period row, which will calculate the figures for periods 1, 2, and 3.

   8. Enter PERIODIC in the Periods Covered row.

   9. Enter P<=B in the Print Column row.

5. Repeat step 4.2 to step 4.8 for 4 to 6, 7 to 9, and 10 to 12 in Header 2; 4:6, 7:9, and 10:12 in the Period row.

6. In column F, perform the following steps:

   1. In Header 2, enter Year-to-Date.

   2. Enter FD in the Column Type row.

   3. Enter 2017 Sales in the Book Code / Attribute Category row.

   4. Enter 2017 in the Fiscal Year row.

   5. Enter BASE in the Period row.

   6. Enter YTD in the Periods Covered row.

7. In column G, perform the following steps:

   1. In Header 2, enter @FiscalYear.

   2. Enter FD in the Column Type row.

   3. Enter 2017 Sales in the Book Code / Attribute Category row.

   4. Enter 2017 in the Fiscal Year row.

   5. Enter 1:12 in the Period row.

   6. Enter PERIODIC in the Periods Covered row.

8. Click on Save to save the new column definition.

9. Enter BUDGET-SALES-2017 in the Name field.

10. Enter Budget – Sales 2017 in the Description field.

11. Click on OK and close the column definition.

Creating the report definition

To create the default records needed for analytical accounting, follow the given steps:

1. Launch Management Reporter 2012 and log into the Fabrikam, Inc. company as normal.

2. Press Ctrl + Shift + P to create a new report definition.

   

3. Set the Detail level: to Financial, Account, & Transaction.

4. Fabrikam, Inc. is operating in 2017, so change the Base Year: to 2017.

5. Set the Row: to BUDGET-SALES.

6. Set the Column: to BUDGET–SALES 2017.

7. Click on the Output and Distribution tab.

8. Enter BUDGET-SALES 2017 in the Output name: field.

9. Click on Save to save the new column definition.

10. Enter BUDGET-SALES-2017 in the Name field.

11. Enter Budget – Sales 2017 in the Description field.

12. Click on OK and close the column definition.

13. Click on Generate to produce the report and launch the Report Viewer.

    

As the base period was set to April, the print control means only the first of the periodic columns displays on the report. Clicking on the line will drill down to the account level showing the breakdown of the budget values on the accounts.

As with report created in Management Reporter, additional columns can be added to the column definition to include actual figures in the report as well as calculation fields.

Summary

In this article, we have taken a look at the inquiries and reports available within a standard implementation of Microsoft Dynamics GP as well as looking at how Management Reporter 2012 can be used to extend this reporting.

Resources for Article :

Further resources on this subject:

• Setting up the Microsoft Dynamics GP System [Article]
• Planning: Microsoft Dynamics GP System [Article]
• Drilling Back to Source Data in Dynamics GP 2013 using Dashboards [Article]