Account RollupThis Feature is an inquiry that you build which allows you to see various GL accounts rolled up together and the ability to drill down into the account details. If you need to look at groups of accounts this is the inquiry for you. You can even perform calculations! Reports can also be printed from these Inquiry Screens.
Additionally, you can perform calculations on those accounts.We use this for all kinds of things like:
· What's the Fixed Asset total across all divisions.
· What's the commission allocation based on sales.
· Useful for things like departmental totals with drilldowns.
· Accounts do not have to be consecutive.
· Rollups can include Actual, Budget and Calculated information.
Traditionally users have been using FRx will to do this type of consolidation, but I don't want to launch FRx and run financial statements just to get a breakdown of my FA accounts.
In Dynamics GP, select
Inquiry->Financial->Account RollupEnter an Option ID, tab and click yes to add the option or Modify to create new options or make changes to the Account Rollup Inquiry Option.
Account Rollup Inquiry :Controls on the right let you see net change or period balance totals. If you want to see what makes up the total number, select a month and click the blue column header.
Account Rollup Inquiry Options:
You set the number of columns you want to see up in the right side. If all you want is totals, one column is fine. For calculations, use at least 2 columns.
In the center, you set the types of columns, but we'll come back to that. At the bottom, you add criteria like accounts, departments, divisions, etc. UNLIKE OTHER GP criteria areas, you can multiple independent criteria here. So if you want to see department A and Department C but not Department B. You add A, then add C.
Now, to get really fancy, you can ad calculated columns to a rollup. Simply create or modify (with the button) a rollup.
Change the
type from Actual to Calculated. In the Selection column, click the More Info button.
This is a little arrow.My example is Commission on Retail/ Parts Sales. Let's say, I accrue 8.9% of sale as a commission accrual. My first column is my monthly sales for the Retail/ Part Division. So I'll pick the only available column in the column box and hit the double arrows (>>) then add the multiply sign (*) then in the constant box I'll add .089 and hit the double arrows (>>).
You formula now looks something like C1 * 0.089. Save and refresh and you get a report with sales and the commission allocation for each month.
This is great for all those estimates you do every month. You can just take the numbers and do a JE.
Posts
