Cash Flow Management

Exclusive offer: get 50% off this eBook here
Microsoft Dynamics GP 2013 Financial Management

Microsoft Dynamics GP 2013 Financial Management — Save 50%

Unleash the power of financial management with tips, techniques, and solutions for Microsoft Dynamics GP 2013 with this book and ebook

$23.99    $12.00
by Ian Grieve | September 2013 | Enterprise Articles

In this article by Ian Grieve, the author of the book Microsoft Dynamics GP 2013 Financial Management looks at the methods for inquiring and reporting on budgets in Dynamics GP, including the use of Management Reporter 2012.

(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:


Microsoft Dynamics GP 2013 Financial Management Unleash the power of financial management with tips, techniques, and solutions for Microsoft Dynamics GP 2013 with this book and ebook
Published: September 2013
eBook Price: $23.99
Book Price: $39.99
See more
Select your format and quantity:

About the Author :


Ian Grieve

Ian Grieve is a Microsoft Dynamics GP and CRM certified consultant, specializing in the delivery of Microsoft Dynamics GP and CRM projects. He is a senior consultant at Perfect Image Ltd., a Microsoft Partner and VAR in the North East of England.

Ian has been working with Microsoft Dynamics GP since 2003. He has dealt with all aspects of the product life cycle from presales, to implementation, to technical and functional training, to post go-live support and subsequent upgrades, and process reviews.

Alongside his work with Microsoft Dynamics GP, in recent years he has fulfilled a similar role dealing with Microsoft Dynamics CRM, with special emphasis on project delivery and the training of end users on the management of sales, marketing, and services.

Ian is the co-author of Microsoft Dynamics GP 2013 Cookbook, produced Microsoft Dynamics GP Techniques online learning course, and was the technical reviewer for Microsoft Dynamics CRM 2011 Applications (MB2-868) Certification Guide and Microsoft Dynamics CRM 2011 Cookbook.

In his spare time, Ian runs the azurecurve | Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk/) blog dedicated to Microsoft Dynamics GP and related products and tries, often unsuccessfully, to squeeze in extra time for the Dynamics CRM related blog coralcurve | A Consultant's Dabblings in Dynamics CRM (http://www.coralcurve.co.uk/).

Books From Packt


Programming Microsoft Dynamics NAV 2009
Programming Microsoft Dynamics NAV 2009

Excel 2010 Financials Cookbook
Excel 2010 Financials Cookbook

Microsoft Dynamics NAV Administration
Microsoft Dynamics NAV Administration

Microsoft Dynamics GP 2013 Reporting, Second Edition
Microsoft Dynamics GP 2013 Reporting, Second Edition

Microsoft Dynamics GP 2013 Cookbook
Microsoft Dynamics GP 2013 Cookbook

Microsoft Dynamics NAV 2009 Application Design
Microsoft Dynamics NAV 2009 Application Design

Instant Oracle BPM for Financial Services How-to
Instant Oracle BPM for Financial Services How-to

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013


No votes yet

Post new comment

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
s
V
c
b
s
F
Enter the code without spaces and pay attention to upper/lower case.
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software