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.
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:
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:
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:
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:
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:
For an example of making columns the same width, see: |
Hide zero balances |
To hide zero account balances, complete the following steps:
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. |