Controlling reporting with account rollups_Microsoft Dynamics GP 2016 Cookbook-QQ阅读男生轻小说网

书名：Microsoft Dynamics GP 2016 Cookbook
作者名：Ian Grieve Mark Polino
本章字数：706字
更新时间：2021-07-14 10:30:20

Controlling reporting with account rollups

Microsoft Dynamics GP provides great functionality for analyzing and reviewing individual accounts and sequential groups of accounts. Many users don't know that it also provides impressive functionality for analyzing non-sequential groups of accounts via a feature known as Account Rollup.

Account Rollups are enquiries built to allow users to see different GL accounts rolled up together and to provide drill-back capability to the details. Additionally, these queries can include calculations for things such as budget versus actual comparisons and calculations.

Management Reporter provides similar functionality and Account Rollup allows users to access this functionality without the wait time in starting up Management Reporter. Let's see how to mix up some account rollups in this recipe.

Getting ready

Before using Account Rollups, it's important to understand how to set them up:

To set up Account Rollup, select Financial from the Navigation pane then select Account Rollup in the Inquiry section to open the Account Rollup Inquiry Options window.
In the Option ID field enter the name Actual vs. Budget and hit Tab. Select Yes to add the option. On the right, set the number of columns to 3.
In the first row, type Actual in the column heading and set the type to Actuals.
In the second row, type Budget in the column heading and set the type to Budget. In the Selection column select the lookup button (magnifying glass) and select Budget 4.
In the third row, type Variance in the column heading. Set the type to Calculated. Click the blue arrow next to Selection to set up the calculation.
In the Column field, select Actual and click the double arrow (>>). Click the minus (-) button. Back in the Column field select Budget and click the double arrow (>>). Click OK.
Back in the Account Rollup Inquiry Options window select the Segment field and select Account. Use the lookup buttons (magnifying glass) in From and To to add account 4130 and click Insert. Repeat this process inserting 4120 and then 4100 into the Restrictions box below. Click Save and close the window:

Notice when looking up these accounts for selection that these numbers are not sequential; there are a number of accounts in between.

How to do it...

Now that we've built an account rollup, let's see how to make it work:

Select Account Rollup under Inquiry on the Financial area page.
In the Option ID field, lookup Actual vs. Budget with the lookup button (magnifying glass).
The screen will show Actual, Budget, and Variance for each period in this year.
The year can be changed at the top and the display can be changed to show either Net Change or Period Balance for each period in the year, along with a total at the bottom, using the controls next to the year. The Difference field is the Actuals minus Budget calculation that we created when setting up the rollup:
Click on a period with an amount in the Actuals column and select the Actuals link at the top. A new window will open with the included accounts and the actual amounts for each account.
When drilling down to the Account Rollup Detail Inquiry Zoom window, Dynamics GP provides a checkbox option to show accounts even if they have a zero balance.
Additionally, an option at the top controls the printing of Account Rollup information. The rollup can be printed in Summary or in Detail:
Selecting a line and clicking Balance from Account Rollup Detail Inquiry Zoom drills back to the detail transactions behind the balance:

How it works…

Account Rollups combine account totals from disparate accounts for reporting. This is great for tying back multiple accounts that rollup to a single line on financial statements. Account Rollups also work well for analyzing a single segment, such as a department, across multiple accounts. In the past I've used this for easy comparisons of Fixed Asset general ledger accounts to the subledger and for rolling up full time equivalent unit accounts to get the number of employees across the company, with drill-back to the employees in each department.