1. One View Financial Statements
  2. Applying Formatting for Financial Statements

Applying Formatting for Financial Statements

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

You can use the same design elements when setting up layouts for One View Financial Statements as you use for other reports that you design in the BI Publisher Layout Editor.

Note: The case studies in this implementation guide provide examples of formatting that you can use in the Layout Editor. See OVFS Balance Sheet Statement Case Study.See OVFS Consolidated Income Statement Case Study (Release 9.2 Update).

The following table describes some formatting tips that you can use to make your OVFS output look like traditional financial statements.

Formatting Action

Explanation

Hide a column or heading

You might need to hide an element, such as a column value or heading, when you need to have the element in the layout, but you do not want it to print in the financial statement layout. For example, if you want to sort the records by the level of detail sequence, you must include the LOD Sequence element in the table because you cannot sequence the balances in the table by an element that is not included in the table. After you sequence the accounts, you need to hide the LOD Sequence element so that it doesn't print in the statement output.

To hide a column and its heading:

  1. Hide the column heading:

    1. Select the column heading and rename it with a single-character name.

      You rename the element with a single character to make the element as narrow as possible.

    2. Select the column heading, and then use the options in the Appearance section and the Font section of the Properties tab to make the background color white, the text color white, and remove the borders.

  2. Hide the column values:

    1. Select the column, and then use the options in the Appearance section and the Font section of the Properties tab to make the background color white, the text color white, and remove the borders.

    2. Using the Width option in the Appearance section of the Properties tab, make the column width smaller.

      For example, you can make the width 10 pixels to make the column narrower.

For examples of hiding columns and headings, see:

Balance Sheet Case Study Task: Hide a Column in the Layout.

Balance Sheet Case Study Task: Hide the Column Titles in the Layout Tables.

Remove cell borders

To remove cell borders:

  1. Select the cells from which to remove the lines.

  2. Click the Set Borders icon in the tool bar or select one of the border icons on the Appearance section on the Properties tab.

  3. In the Border window, select the Use same value for all sides check box.

  4. Select None from the list in the Style field and click OK.

For an example of removing grid lines, see:

Consolidated Income Statement Case Study Task: Remove Grid Lines.

Sequence by level of detail

If you selected the Enable Level of Detail Rollup check box in the row definition in your statement definition, you must sort the records by the level of detail sequence to ensure the records are in the proper order.

To sequence records by the level of detail sequence:

  1. Locate the Lod Sequence element in the Rowset section and drag-and-drop it into your layout.

    The placement of the list item in the layout is not important, but placing it before the Account ID Description column will make it easier to work with the Lod Sequence element.

  2. Select the Lod Sequence column and then click the Ascending Order icon on the Column tab of the layout window.

Generally, you will hide the Lod Sequence column after you sequence the accounts.

For examples of sequencing records by the level of detail and hiding a column, see:

Balance Sheet Case Study Task: Sequence Accounts.

Consolidated Income Statement Case Study Task: Sequence Accounts.

Indent values based on level of detail

You can use the fields on the Highlight window to format text, such as increasing or decreasing the font size and changing the font style or color. You can also use the Text Indent field to indent text based on the element you select in the Data field and the value you enter in the Value field.

To indent values based on the level of detail, you must have selected the Enable Level of Detail Rollup check box for the row definitions in the sections in the statement definition.

To indent values based on the level of detail:

  1. Select the account description cells.

  2. Select Highlight from the Conditional Formatting menu option.

  3. In the Highlight window:

    1. Select Account Level of Detail from the list in the Data field.

    2. Enter the number of the level of detail to indent.

      For example, enter 3 to indent the values at level of detail 3.

    3. Select the measurement to use to indent, such as px (pixel) or pt (point),

    4. Use the up and down arrow buttons for the Text Indent field or enter a value to specify how much to indent the text.

      You can review the results of your choices in the Preview field.

    5. Click OK on the Highlight window to save your changes.

For an example of indenting based on the level of detail, see:

Balance Sheet Case Study Task: Format Account Balances Columns.

Make all columns the same width

To make all of your columns the same width:

  1. Select the columns to set to the same width.

  2. Specify the width in the Width field in the Appearance section on the Properties tab.

For an example of making columns the same width, see:

Balance Sheet Case Study Task: Change the Width of Columns.

Hide zero balances

To hide zero account balances, complete the following steps:

  1. Select the column, and then select Highlight from the Conditional Formatting section on the Column tab.

  2. In the Highlight window, perform the following steps:

    • Enter 0 in the Value field.

    • Click in the Color field, and then select the box for white on the Color Picker window.

    • Click in the Background Color field, and then select the box for white on the Color Picker window.

Note: Do not select the white box that has an X in the box. The white color is not used in the statement output if you select that box.

For an example of hiding 0 balances, see:

Balance Sheet Case Study Task: Format Account Balances Columns.

Move column titles to the statement header area

For statements that use multiple sections with the same columns, such as an income statement, you will hide the column headings associated with all of the tables you place on the statement. In order to have the column titles appear on each page of the statement, you must add the column titles in the statement's header area.

See Balance Sheet Case Study Task: Create Column Titles in the Statement Header. and Balance Sheet Case Study Task: Hide the Column Titles in the Layout Tables.

Reverse the sign of a column

You can select the Reverse Sign check box in a data type or subtotal type row definition to have the system displays account balances with the sign reversed from the sign in which the account balance is stored in the JD Edwards EnterpriseOne tables.

You can also reverse the sign in a column by applying a calculation in the Layout Editor.

For an example of reversing the sign in a column using a calculation, see Balance Sheet Case Study Task: Reverse the Sign of OVFS Account Balances Columns.