What Rows Definitions Do I Need to Set Up?
In your initial analysis of the statement output that you want to generate, you determined that the account balances that you need to retrieve should be set up at the row level. You want to show the account balances for your revenue and expense accounts.
In the consolidated income statement, you also want to:
Show account descriptions instead of account numbers.
To retrieve descriptions, you must select the Return Description check box in the row definition.
List accounts in the statement in the order that they're listed in the model chart of accounts.
To enable sequencing by the object account, you must select the Enable Level of Detail Rollup check box in the row definition.
Roll up account balances by level of detail.
To enable this feature, you must select the Enable Level of Detail Rollup check box in the row definition. In addition to providing subtotals by the level of detail, you can use the detail levels to format the account balances and descriptions when you set up the layout in the Layout Editor.
Show the revenue account balances with the sign reversed.
To display account balances with the sign reversed from the way the accounts are stored in the JD Edwards EnterpriseOne tables, you can either select the Reverse Sign check box in the row definition or you can reverse the sign using a calculation in the layout. In this case study, you will select the Reverse Sign check box in the row definition.
This table describes the attributes of the row definitions that you need to set up for your consolidated income statement:
Purpose of Row |
Row Definition Type |
Grouping Element |
Select These Attributes |
Data Selection Needed? |
|---|---|---|---|---|
Revenue |
Data, with grouping |
Object (OBJ) |
Enable Level of Detail Rollup Return Description Reverse Sign |
Yes. Revenue accounts 5000 through 5999. |
Direct costs |
Data, with grouping |
Object (OBJ) |
Enable Level of Detail Rollup Return Description |
Yes. Direct cost accounts 6000 through 7999. |
General and administrative expenses |
Data, with grouping |
Object (OBJ) |
Enable Level of Detail Rollup Return Description |
Yes. General and admin expense accounts 8000 through 8999. |
Other income and expenses |
Data, with grouping |
Object (OBJ) |
Enable Level of Detail Rollup Return Description |
Yes. Accounts 9000 through 9250. |
Income Tax |
Data, with grouping |
Object (OBJ) |
Enable Level of Detail Rollup Return Description |
Yes. income tax accounts 9700 through 9750. |
In addition to the row definitions listed in the table above, you also need report sections for the following subtotal and total lines. You can set up one subtotal-type row definition and then use it for all of the subtotal and total lines.
Total Revenue
When you set up this subtotal line in the statement definition, you will enter the values to total the revenue accounts.
Gross Margin
The gross margin is revenue plus the cost of goods sold. When you set up this subtotal line in the statement definition, you will enter the values to total the Revenue (which are a negative value) and the Direct Costs sections.
Operating Income
Operating income is the net income, not including financial activities or taxes. When you set up this subtotal line in the statement definition, you will enter values to total the Revenue, Direct Costs, and General and Admin (Administration) Expenses sections.
Net Profit before Tax
Net profit before tax is the amount of revenue in excess of costs before taxes are added to the equation. When you set up this subtotal line in the statement definition, you will enter values to total the Revenue, Direct Costs, General and Admin Expenses, and Other Income and Expense sections.
Other Income and Expenses
Other income and expenses includes the Revenue, Direct Costs, General and Admin Expenses, and Other Income and Expense, and Income Tax sections. When you set up this subtotal line in the statement definition, you will enter values to total those sections.
Net Profit or Loss
Net income or loss is the total of net revenue, the cost of goods sold, administrative expenses, and taxes. When you set up this subtotal line in the statement definition, you will enter values to total the Revenue, Direct Costs, General and Admin Expenses, Other Income and Expense, and Income Taxes sections.