1. One View Financial Statements
  2. Planning Your Consolidated Income Statement

Planning Your Consolidated Income Statement

Before you can setup the OVFS components for the consolidated income statement, you need to determine which account balances the statement will include, and how you will retrieve those balances from the JD Edwards EnterpriseOne tables. For account balances that do not reside in the JD Edwards EnterpriseOne tables, you need to determine the calculations that you will need to set up that use the account balances that you retrieve from the JD Edwards EnterpriseOne tables.

When planning a financial statement, start your analysis by determining how and where you want to view the accounts. In the images of the Consolidated Income Statement provided in figures B-1 through B-4 above, the accounts are grouped in sections, and the descriptions of the accounts are listed through the middle of the report. Because the sections include account balances, you know that the accounts are set up at the row level.

Next, consider the way the accounts are grouped into sections. You identify the following sections for your income statement:

  • Revenue

  • Direct Costs

  • Gross Margin

  • General and Administrative Costs

  • Operating Income

  • Other Income and Expenses

  • Net Profit Before Tax

  • Income Taxes

  • Income and Expenses

  • Net Income or Loss

Some of the sections contain account balances from the Account Balances (F0902) table, such as the Revenue and Direct Costs sections. Some sections have amounts that are subtotals of amounts in other sections or are calculated amounts, such as the Gross Margin and Operating Income sections. You will need to set up row definitions with data selection to obtain the correct account balances for each section that includes balances from the F0902 table, and will need to set up a subtotal row definition that you can use in multiple sections in the statement definition to provide the interim totals in the statement output.

Some of the columns in the sample of the Consolidated Income Statement include account balances that you can retrieve from the F0902 table. Those columns are the Current Month Actual, Last Year Actual, Year to Date Actual, and Last Year-to-Date Actual. You can set up column definitions within the OVFS feature to return the balances for those accounts. Other columns in the sample statement are calculated amounts, such as the percentage of revenue. You will need to set up columns in the Layout Editor to calculate those amounts.

Other factors that you can view in the sample statement output that you need to consider as you set up the OVFS components include the following:

  • The income statement that you want to generate is a consolidated statement, so you need to use OBJ (object account) in the grouping element of the row definitions that will retrieve account balances.

  • The statement includes the description of the accounts, not the account numbers.

    You will need to set up the row definitions to return descriptions.

  • The accounts are rolled up to level of detail 6 with totals and subtotals in the statement output.

    You will need to set up the parameters in the OVFS components to roll up the account balances to level of detail 6.

  • The account balances for revenue are displayed as positive numbers, though the JD Edwards EnterpriseOne system stores the account balances for revenue as negative numbers.

    You will reverse the sign of the revenue account balances by selecting the Reverse Sign check box in the row definition for revenue.

  • The percent of revenue calculated columns are based on the total revenue.

    To use the total revenue in a calculation, you must have an OVFS component that contains only the total revenue, so you will set up a row definition to obtain that total. You will then be able to divide the total revenue by the account balances for each section.

Now that you've analyzed the statement output that you want to generate, you need to answer the following questions:

  • What column definitions do I need to set up?

  • What row definitions do I need to set up?

  • Which elements do I need to specify in the statement definition and versions?

  • What do I need to set up in the BI Publisher Layout Editor?