Report on transactions rolled up by parent

You can create a custom report that rolls up an entire hierarchy of transactions into one total, including the parent transactions. You can also create a report that shows multiple levels, and create multiple rollup lines for parents within a parent.

Open the custom report writer

To access the custom report writer, go to Customization Services or Platform Services and select Reports.

Create a rollup by parent hierarchy report

1. Go to Customization Services > All and select Add (circle) next to Custom reports.

2. In the Select a primary data source step, select a data source that contains a hierarchical structure. The following data types can contain parent-child relationships:
   • Customer
   • Vendor
   • Project
   • Task
   • Location
   • Department
   • Class
3. In the next few steps, select options appropriate to the report you want to generate, such as columns for display, adding a calculated column, or the sequence of columns.
4. In the Optionally group data step, select Grouping. You must select this option to be able to group your data and show parent-child relationships.

5. In the Group data by a column step, select one grouping option appropriate to the data source you selected for your report. This step only becomes available if you select Grouping in step 4 of this procedure.

   Selecting this grouping option makes the Include Children option appear for selection in the Order the groups step.

   Grouping options by data types

   Data Type	Group by
   Class	Class ID Class Name
   Customer	Customer ID Customer Name
   Department	Department ID Department Name
   Location	Location ID Location Name
   Project	Vendor ID Vendor Name
   Task	Task ID Task Name
   Vendor	Vendor ID Vendor Name

   Hierarchical roll up works only if you correctly link the Group by field. For example, if you selected Invoice Detail as the data source for your report, and you want to do a hierarchical roll up by Customer ID in the Group data by a column step, you wouldn't select Invoice Detail > Customer ID from the Columns section. Instead select Customer > Customer ID from the list of objects below the Columns section. The system can now determine the hierarchy

6. In the Order the groups step, check the Include children box.
   Selecting this option causes the hierarchical group to appear in the generated report with rollup totals for the combined transactions, including transactions against the parent.

7. Complete the rest of the steps of the report writer, selecting appropriate options for the report creation, then generate the report.