Detail group

A detail group is an option that lets you repeat lines that display in the rows of your reports. Use this option to save time when setting up a report that has similar lines going down the page with only the account or accounting unit being reported on changing.

You assign lines to a detail group and the application automatically repeats those lines based on the detail option assigned to the first line in the range. For example, with a detail option of Account, the lines repeat at each change in the account. With a detail option of Level, the lines repeat once for every change in the posting accounting unit.

Note: This option is good to use when including multiple formats on a report.

Example

LGE has created a Style 3 report to show sales and percent-of-total sales for each accounting unit displayed by sales account. In this example, the first row line in the detail group has a detail option of Account. The lines in the detail group repeat once for every sales account defined in the range.

Line Description Type Detail Accounts Detail Group Format number
10 Hospitals H 1
20 Hospitals Base Line B 041000-041800 1
30 Hospitals Sales Accounts D A 041000-041800 1 1
40 Percent of Sales D C 041000-041800 1 2 

              
              
                          LGE Corporation
                           SALES REPORT
                         January 31, 2000
                          (in thousands)


          HOSPITALS

  Sales-Prescription Drugs                   $9,654
       Percent of Sales                       15.5 %

  Sales-Non-Prescription Drugs               $8,337
       Percent of Sales                       13.4 %

  Sales-Clinic Services                      $4,000
       Percent of Sales                        6.4 %

  Sales-Hospital Services                   $37,301
       Percent of Sales                       59.9 %

  Sales-Other                                $2,000
       Percent of Sales                        3.2 %

Restrictions for detail groups

These restrictions apply to detail groups:

  • The first row line defines the company, level, and account ranges for the entire detail group.

  • Detail groups work only on row lines with the detail option Account, Subaccount, or Level.

  • Detail groups are not valid for Base row types.

  • The maximum number of row lines you can assign to a detail group is 20.

  • The maximum number of detail groups you can define for a row is 35.