Expand Detail Reports (GXE)

The Expand Detail option allows users to select a single (or multiple) financial statement line using GXL formulas and expand the line(s) to the individual account details, similar to the Generate Account Detail option. This process is primarily used to launch detailed financial statements in the same template. The option can be used for multiple departments to ensure the consistency of each report. Instead of creating each possible account number as different rows in the spreadsheet, a single line can be created that contains ranges, segment lists, or wildcards. This line will then be expanded to the applicable individual accounts, and placed into a formatted worksheet table, range, or row. The maximum number of columns to be expanded is based on the option in the user's Spreadsheet Server Settings.  See Expand to Account Balances for more information).

Additionally, the Expand Detail option allows users to create a detail journal voucher listing for a specific summary balance of accounts, using the GXE formula. This process works similarly to the Expand Detail option for account detail, but uses additional parameters. See Expand to Journals for more information.