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.
To create the row definition, follow the given steps:
normal
.&&&
into the Dimensions row.300
into the Dimension Range Start and Dimension Range End rows.####
.BUDGET-SALES
in the Name field.Budget – Sales
in the Description field.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.
To create the column definition, follow the given steps:
Desc
in the Column Type in column A.Sales Budget @FiscalYear
in the Column header text and enter B
in Spread from and G
in Spread to.1 to 3
, which is the period range that the column will contain.FD
in the Column Type row which defines this column as containing either actual or budget figures from the financial dimension.2017 Sales
in the Book Code / Attribute Category row to select the required budget.2017
in the Fiscal Year row.1:3
in the Period row, which will calculate the figures for periods 1, 2, and 3.PERIODIC
in the Periods Covered row.P<=B
in the Print Column row.4 to 6
, 7 to 9
, and 10 to 12
in Header 2; 4:6
, 7:9
, and 10:12
in the Period row.Year-to-Date
.FD
in the Column Type row.2017 Sales
in the Book Code / Attribute Category row.2017
in the Fiscal Year row.BASE
in the Period row.YTD
in the Periods Covered row.@FiscalYear
.FD
in the Column Type row.2017 Sales
in the Book Code / Attribute Category row.2017
in the Fiscal Year row.1:12
in the Period row.PERIODIC
in the Periods Covered row.BUDGET-SALES-2017
in the Name field.Budget – Sales 2017
in the Description field.To create the default records needed for analytical accounting, follow the given steps:
normal
.Financial, Account, & Transaction
.2017
.BUDGET-SALES
.BUDGET–SALES 2017
.BUDGET-SALES 2017
in the Output name: field.BUDGET-SALES-2017
in the Name field.Budget – Sales 2017
in the Description field.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.
18.222.164.141