Balance Sheet Case Study Task: Create Data Row Definitions

In this task, you will set up a row definition.

Note: Remember to begin the name of the row definition with your initials so that you do not receive duplicate records errors.

To set up the Balance Sheet by Business Unit row definition:

1. From the One View Financial Statements Setup menu (G0916), select Row Definitions.

2. Click Add on the Work with Row Definitions form.

3. In the header area of the Revise Row Definition form, complete these actions:

   1. Enter (initials) BALSHTBYBU in the Row Definition Name field.

      You can enter the name in upper or lower case; the system converts lower case to upper case when you exit the field.

   2. Enter Balance Sheet by Business Unit in the Row Definition Description field.

   3. Select Data from the Row Definition Type list.

      The system automatically selects the Row Definition Grouping check box.

      Do not deselect the check box.

   4. Leave the Reverse Sign check box unselected.

      Because you are creating one row to include both assets and liabilities, you will not reverse the sign for the row. You will reverse the sign for the liability account balances in the Layout Editor.

   5. Select Active in the Definition Status field.

4. In the Grouping Elements section of the Review Row Definitions form, complete the following actions:

   1. Enter AID in the Grouping Element field.

   2. Select the Return Description check box.

      Selecting the Return Description check box will cause the process to retrieve the account descriptions.

   3. Select the Enable Level of Detail Rollup check box and the Include GLG AAI Item Number check box.

      Selecting the Enable Level of Detail Rollup check box enables you to roll up account balances to the level you specify in the statement version that you run. It also enables you to use the level of detail to sequence and format accounts in the Layout Editor.

      The returned values for the Include GLG AAI Item Number check box is not needed for this balance sheet statement, but you select it to make the values available if the row definition is used in another statement definition.

      Note: You must exit the row before the system enables the check boxes.

5. On the Revise Row Definitions form, click Data Selection.

6. On the Revise Row Data Selection form, click the + (plus sign) for the Obj Acct (Object Account) field.

   The system adds the Obj Acct field to the Query Manager tab.

7. On the Query Manager tab, select between from the comparison type list.

8. In the first values field, enter 1000.

9. In the second values field, enter 4999.

10. Click Save on the Query Manager tab.

11. Click Close on the Revise Row Data Selection form.

12. Click OK on the Revise Row Definition form.

13. Click Cancel on the Revise Row Definition form.