Consolidated Income Statement Case Study Task: Sequence Accounts

Note: You sequence accounts for only the Revenue, Direct Costs, General and Admin Expenses, Other Income and Expenses, and Income Tax sections in your layout.

Note: You can access an existing layout that was created for the One View Financial Statements feature only by using the Manage Layout option on the Work with Statement Definition form. If you exited the Layout Editor after you completed the last set of steps and need to re-access an existing layout, see Consolidated Income Statement Case Study Task: Accessing an Existing Layout (Optional).

The account descriptions as initially provided in the Object Account Description column are sorted by the object account number. You need to display the descriptions by the level of detail.

Because you selected the Enable Level of Detail Rollup option in the row definition that you set up, the Rowset section includes the Lod Sequence element. This element enables you to sort the account balances by the level of detail in your chart of accounts.

To sequence the description and corresponding account balances, complete the following steps:

Locate the Lod Sequence element in the Rowset section for the Revenue section and drag-and-drop it into your layout.
The placement of the list item in the layout is not important, but placing it at the far left side of the table will make it easier to account for the space that it uses in the table when you later format the columns.
Select the Lod Sequence column and then click the Ascending Order icon on the Column tab of the layout window.
Click the Save icon to save your layout.

Caution: If you need to exit the BI Publisher Layout Editor, do not click the Sign Out icon or you will log out of the server. Instead, click the Close icon (the X in the upper right corner of the window) to exit the window.

After you complete the steps in this task, your statement layout should look like the following image:

Consolidated Income Statement: Records Sorted by Level of Detail in the Revenue Section