Balance Sheet Case Study: Set Up the Row Definition

Tutorial (Release 9.2 Update): Click here to view a recording of this feature.

To create the row definition for the balance sheet statement, you set up a row definition that the system will use in conjunction with column definitions and data selection to retrieve account balances.

According to the plan that you developed, you need to create one row definition to retrieve asset, liability, and shareholder equity account balances. You also want to:

• Provide subtotals by level of detail.

• Include account descriptions on the statement output.

• Provide the amount of the year-to-date income or loss.

To achieve those results, you use the information in the following table to set up your row definition:

Row Definition Name and Description	Row Definition Type	Grouping Element	Additional Attributes	Data Selection
Name: BALSHTBYBU Description: Balance Sheet by Business Unit	Data Select the Row Definition Grouping check box	Account (AID)	Select these check boxes: Enable Level of Detail Rollup Include GLG AAI Item Number Return Description	Object Accounts between 1000 and 4999