Understanding One View Financial Statement Validations

After you set up the row, column, and statement definitions; and your statement versions and layouts, you can generate statements using the One View Financial Statements (OVFS) feature. You submit financial statements for processing by using an option in the Statement Versions program (P09340).

When you submit an OVFS statement, the system performs validations as it processes records for the statement. The following list describes the validations that the process performs:

• Each section description must be unique.

• Each row definition can be used once only in a section.

• Each column definition can be used once only in a section.

• The text value, numeric value, and subtotal row definitions cannot have associated columns in the section.

• Types of row definitions in a section:

  • If a section includes a data with grouping elements row definition, then the following validations are performed:

    • All row definitions in the section must be data with grouping elements.

    • All row definitions must use the same grouping elements and have same settings for the Enable Level of Detail Rollup and Include GLG AAI Item Number check boxes.

      The values for the Enable Level of Detail Rollup and Include GLG AAI Item Number check boxes must be the same in the OVFS Row Definition Setup (F09310) and OVFS Statement Definition Setup (F09330) tables. If the values are not the same, then the system changes the value in the F09330 table to match the F09310 table, and then continues with the validation process.

    • All row definitions must have at least one column definition and must use the same column definitions for all row definitions in the section.

  • If a section includes a data without grouping elements row definition, then the following validations are performed:

    • All row definitions in the section must be data without grouping elements.

    • All row definitions must have at least one column definition and must use the same column definitions for all row definitions in the section.

  • If a section includes a subtotal row definition, then the following validations are performed:

    • No other row definitions are included in the section.

      A section with a subtotal row definition can include only one row definition.

    • The Section From and Section Thru fields must be populated, and the value in the Section Thru field must be greater than the value in the Section From field.

    • At least one data or subtotal row definition must be included in the range of values in the Section From and Section Thru fields.

  • If the section includes a text or numeric row definition, no data or subtotal row definitions can be included in the section.