Account rollups are a great way of grouping and analysing accounts that are not in sequential order. If you haven’t found this particular enquiry, then it is one you definitely need to check out.

Enquiry –> Financial –> Account Rollup
 AccountRollup_1

Type in an option ID and click Modify to set up.

AccountRollup_2

 

 

Choose which segment you want to sort by and how many columns you want to use. You have four user defined columns that can be set up to view your data.

Define each column. The options you have are:

  • Actuals – this returns actual data for the current year.
  • Budget – if you select this option, you then need to select which budget you wish to query.
  • Calculated – the calculation needs to be defined. To do this, click on the blue arrow next to the Selection heading.
  • Previous Year – type which year you wish to query in the selection column.
  • Other Currency – if you run a multi-currency system, this may be of benefit. Once selected, you need to choose which currency to return.

 

AccountRollup_3

Rename the column headings so you know what you are looking at in the Enquiry screen.

Choose which account segments you wish to enquire on. These do not need to be sequential as in other report and enquiry screens.

Click on Save and return to the Enquiry screen. Click on Redisplay to see the results of your query.

From the Enquiry screen, you can now drill into detail and print reports. Click on each heading for different drilldown views. Here is a view of a drill-down into the actuals of a group:
AccountRollup_4

Use the Print icon to print as a report either in Summary or Detail.

 

Go and have a play with them. I am sure you can find specific areas within your reporting that these can be very useful.  One of our clients is using this to compare their accounts receivable and payable trial balances as they have multiple control accounts.

 

Heather Roggeveen is a MS Dynamics GP Consultant with Olympic Software. After 15 years of working with the end user all the way from designing the solution to user training, she has become a Dynamics GP expert. Heather regularly shares her knowledge, including tips and tricks for end users in her blog articles. Follow her on Twitter @HRoggeveen to be notified of her latest articles. You can also like Olympic Software on Facebook or follow us on LinkedIn or on Twitter @OlympicSoftware. For more information about Dynamics GP and how it could benefit your business, view the Dynamics GP page on our website or give us a call, 09-357 0022.