Creating a Statement Version
Access the Revise Statement Versions form.
- Statement Definition Name
An alphanumeric string that defines the name of a statement definition. The system completes this field with the value that you entered on the Work with Statement Versions form. You cannot change the statement definition name on the Revise Statement Versions form.
- Statement Version Name
The name you assign to the statement version that you create.
The combination of the statement definition name and the statement version name must be unique; you cannot enter the name of an existing statement version that you previously set up for the statement definition. You can, however, create multiple statement versions for the same statement definition.
Spaces and certain special characters are not allowed in the statement version name. See Statement Version Names and Descriptions.
- Statement Version Description
An alphanumeric string that represents the description of the statement version.
Certain special characters are not allowed in the version name. See Statement Version Names and Descriptions.
- Data Selection
The system puts a check mark in this check box if data selection is associated with the statement version. Otherwise, the check box is not selected. You cannot manually change the value. The system changes the values as you add or delete data selection.
- Based On Company
A code that identifies a specific organization, fund, or other reporting entity. The company code must exist in the Company Constants table (F0010).
The system uses the value in this field during the execution of a financial statement to retrieve a default value for the financial reporting fiscal year and period and its corresponding date pattern. If you leave this field blank, the system uses company 00000.
- Based On Business Unit
The business unit that the system uses to retrieve a default chart of accounts. This chart of accounts is used to retrieve the account descriptions and level of detail when the system processes a row definition with grouping elements, and the grouping elements include the object account and subsidiary and does not include business units.
You can group the object account and subsidiary in a data row definition with grouping elements to create statements that consolidate accounts across companies and business units.
If you selected OBJ (object account) only, or OBJ and SUB (subsidiary) as grouping elements, then you must complete this field.
- Fiscal Year
A number indicating the fiscal year for which data is retrieved. If a column definition in the statement definition is for a previous or future year, then the system determines the previous or future year based on the value that you enter in this field. For example, if the value in the Fiscal Year Plus or Minus field in the column definition is -1 and you enter 2020 in this field, then the system retrieves data for the year 2019.
If you leave this field blank, the system uses the current financial reporting year for the company identified in the Based On Company field.
- Period Number
A number indicating the period number for which data is retrieved. If a column definition in the statement definition is for a previous or future period, then the system determines the previous or future period based on the value that you enter in this field. For example, if the value in the Period Plus or Minus field in the column definition is -1 and you enter 12 in this field, then the system retrieves data for period 11.
If you leave this field blank, the system uses the current financial reporting period for the company identified in the Based On Company field.
- Account Level of Detail
A number used to summarize and classify accounts in the general ledger by level of detail. Level 9 is the most detailed and Level 1 is the least detailed level. Levels 1 and 2 are reserved for company and business unit totals. Levels 8 and 9 are reserved for job cost posting accounts in the Job Cost system.
- Calculate YTD Net Income or Loss
An option that indicates whether the year-to-date net income or loss is calculated per section of the financial statement. This option is only applicable for balance sheet statements. For the calculation to be accurate, the statement definition must include rows with data selection for accounts with GLG2 AAI to GLG5 AAI. The row definition must group by account (AID or OBJ). The AAIs will be retrieved using the company specified in the Based on Company field in the Statement Versions program. If you do not specify a company, then the system uses Company 00000.
- Suppress Zero Balances
An option that indicates whether to suppress rows with a zero balance in the financial statement. If you selected the Enable Level of Detail Rollup check box in the row definition, then only those records with zero balances at the LOD specified in the version are suppressed.
If you select this option, the system writes the value 1 to the statement version table.
- Layout Name
An alphanumeric string that defines the layout name to be used when the statement version is run.
If layouts exist for the statement version, you can select a layout from the list for this field to associate the layout with the version. Selecting a layout when you create or modify a statement version is not required. However, you cannot generate a financial statement unless a layout is associated with the statement version that you run. You can select a layout when you run a financial statement.
If no layouts exist for the statement definition, then the Layout Name field is not enabled.
- Layout Format
An alphanumeric string that defines the layout format to be use when the statement version is executed.
If you selected a layout in the Layout Name field, you can select the format in which you want to generate the financial statement.