4 (CZE, HUN, and ESP) Setting Up Accounts and Layouts for Financial Statement Reports

This chapter contains the following topics:

4.1 Understanding the Setup of Accounts and Layouts for Financial Statement Reports

Financial statement reports include standard accounting reports such as balance sheets, profit and loss statements, and income statements. The JD Edwards EnterpriseOne software enables you to define the accounts, cost centers, and layouts for these types of reports, and then print reports using the layouts that you established.

To set up accounts and layouts for financial report statement reports:

  • Define cost center groups.

    You can define cost center groups that you can use in multiple reports or in a specific report.

  • Define account groups that you associate with cost center groups.

    You can define account groups that you can use in multiple reports or in a specific report.

  • Define layouts for each type of report that you need to generate.

The system writes information for report layouts to these tables:

  • Report Definition (F749101)

  • Section Definition (F749102)

  • Section Column Definition (F749103)

  • Rows Definition (F749104)

  • Cells Definition (F749105)

After you define report layouts, you use the Generate Financial Reports program (R749110) to generate the reports.

4.2 Setting Up UDCs for Financial Statement Reports

Before you set up and generate financial statement reports, set up these UDCs.

4.2.1 Function (74/FA)

You use the values that exist in the Function UDC table when you set up report layouts for financial statement reports. The system uses values from the Account Balances table (F0902). These values are hard-coded:

Codes Description 01 Description 02
(blank)    
AUDITAC_CR Audit Activity 13,14 - Credit AND13+AND14
AUDITAC_DB Audit Activity 13,14 - Debit ANC13+ANC14
AUDITACTIV Audit Activity 13,14 AN13+AN14
CURRPER_CR Current period - Credit ANCxx
CURRPER_DB Current period - Debit ANDxx
CURRPERIOD Current period Anxx
INCETODATE Inception to date APYC + (AN01 + Anxx)
PRIORYNET Prior Year Net APYN Prior Year Net
PRIORYREND Prior Year End Balance (APYC) APYC Balance Forward amount
YEARTODATE Year to date AN01 + Anxx
YTD_CR Year to date - Credit ANC01 + ANCxx
YTD_DB Year to date - Debit AND01 + ANDxx

4.2.2 Factor to Apply (74/FR)

You use the values that exist in the Factor to Apply UDC table when you set up report layouts for financial statement reports. The values in this UDC are hard-coded and represent factors such as showing an amount as negative or positive, or reversing the sign. Values are:

Codes Description
(blank)  
- Show amount as negative
+ Show amount as positive
N Show amount if it is negative
P Show amount if it is positive
R Reverse the amount sign

4.2.3 Group Type (74/GT)

This UDC table provides group types that the system uses when you set up account groups for financial statement reports. The values in this UDC are hard-coded and describe the type of groupings for accounts, such as a cost center, account, or category code. Values are:

Codes Description
ANI Account
C21 Category Code 21
C22 Category Code 22
C23 Category Code 23
MCU Cost Center
OBJ Object Account
OBS Object Account - Subsidiary

4.2.4 Report Type Classification (74/RC)

The Report Type Classification UDC table includes values that you use to specify the type of report when you set up report layouts for financial statement reports. JD Edwards EnterpriseOne software provides these hard-coded values:

Codes Description
BASH Balance Sheet
CFLO Cash Flow
CHEQ Changes in Equity
OTHR Others
P&L Profit & Loss

4.2.5 Report Layout (74/RL)

You select one of the hard-coded values in this UDC table when you set processing options for the Generate Financial Report program (R749110). Verify that these values exist in your system:

Codes Description
R749111 General Layout - Landscape
R749112 General Layout - Portrait

4.2.6 Report Row Type (74/TR)

The system uses the hard-coded values in this UDC table when you select a row type when setting up rows for reports. Values are:

Codes Description
FOR Formula
GAC Group Account
SAC Single Account
TIT Title

4.3 Setting Up Cost Center Groups for Financial Statement Reports

This section provides an overview of cost center groups and discusses how to set up global cost center groups.

4.3.1 Understanding Cost Center Groups

You create cost center groups to select groupings of accounts by cost center (business unit). You can set up cost center groups to include a range of cost centers, or to use one cost center only. For example, you might have a range of cost centers set up in your system for all of your sales locations. You could group all of these cost centers, and associate that cost center group to a group of accounts for reporting sales income. Similarly, you might have only one cost center that you use for all administrative costs, and you can associate a single or a group of accounts with that cost center when reporting on administrative costs.

After you create cost center groups and associate them with account groups, you use the groupings when you create the layouts for financial reports.

4.3.1.1 Types of Cost Centers

You can create two types of cost center groups. Create a global cost center group for cost center groups that you want to use in multiple reports. For example, you might create a global cost center group to include all business units (cost centers) that are set up to account for sales activities. You could then use that cost center group in both a profit and loss report and in a balance sheet report. Create a report-specific cost center group for a group that is used in only one report. Create report-specific cost center groups when you want to restrict the use of the group to one report.

You create a report-specific cost center group only when you use the Financial Report Setup program (P749101) to set up report layouts. You can create a global cost center group from either the Financial Report Setup program or the Financial Report Account Setup program (P749102).

4.3.2 Forms Used to Set Up Cost Center Groups

Form Name FormID Navigation Usage
Work with Report Definition W749101A Financial Reports (G7410), Financial Report Setup Review and select existing reports.
Work with Cost Center Group For Report: (name of report) W749102A Select a record on the Work with Report Definition form, and select Cost Center Def. from the Row menu. Review and select existing report-specific cost center groups.
Edit Cost Center Group Definition For Report: (name of report) W749102C Click Add on the Work with Cost Center Group For Report: (name of report) form. Set up a report-specific cost center group.
Select Group Type W749102E Financial Reports (G7410), Financial Report Account Setup Select whether to work with global cost center groups or account groups.
Work with Cost Center Group W749102A Click the Cost Center Group button on the Select Group Type form.

Alternatively, select Global Cost Center from the Form menu on the Work with Report Definition form.

Review and select existing global cost center groups.
Edit Cost Center Group Definition W749102C Click Add on the Work with Cost Center Group form. Create a global cost center group and define the cost centers for the group.

4.3.3 Setting Up Global Cost Center Groups

Access the Edit Cost Center Group Definition form.

Group

Enter a name for the group that you create.

Group Description

Enter a description for the group that you create.

From Cost Center

Enter the beginning of a range of business units that you want to include in this cost center group.

To Cost Center

Enter the end of a range of business units that you want to include in this cost center group.

4.4 Setting Up Account Groups for Financial Statement Reports

This section provides an overview of account groups and discusses how to set up account groups.

4.4.1 Understanding Account Groups

You create account groups to associate one or more general ledger accounts with a cost center group. You can group accounts by:

  • Account

  • Object

  • Object/subsidiary

  • Category code 21, 22, or 23

4.4.1.1 Types of Account Groups

Similar to setting up cost center groups, you can set up account groups to use for any report, or set up an account group to use for only one report. An account group that you can use for any report is a global account group. An account group that you can use for only one report is a report-specific account group. For example, you might create a global account group to include all accounts for owners' equity. You could then use that account group in both a profit and loss report and a balance sheet report.

You create a report-specific account group only when you use the Financial Report Setup program to set up report layouts. You can create a global account group from either the Financial Report Setup program or the Financial Report Account Setup program.

4.4.2 Forms Used to Set up Account Groups

Form Name FormID Navigation Usage
Work with Report Definition W749101A Financial Reports (G7410), Financial Report Setup Review and select existing reports.
Work with Account Group For Report: (name of report) W749102A Select a record on the Work with Report Definition form and select Account Definition from the Row menu. Review and select existing report-specific account groups.
Define Account Group Type W749102B Click Add on the Work with Account Group For Report: (name of report) form. Select the account type to create.
Edit Account Group Definition For Report: (name of report) W749102C Select an account type and click OK on the Define Account Group Type form. Create a report-specific account group.
Select Group Type W749102E Financial Reports (G7410), Financial Report Account Setup Select whether to work with cost center groups or account groups.
Work with Account Group W749102A Click the Account Group button on the Select Group Type form.

Select Global Account from the Form menu on the Work with Report Definition form.

Review and select existing global account groups.
Define Account Group Type W749102B Click Add on the Work with Account Group form. Select the type of global account group to create.
Edit Account Group Definition W749102C Select an account type on the Define Account Group Type form, and click OK. Define the global account group.

You complete information about the account number, category code, or object and subsidiary, depending on the type of account group that you set up.


4.4.3 Setting Up Global Account Groups

Access the Edit Account Group Definition form.

The option that you select on the Define Account Group Type form determines the fields that appear on the Edit Account Group Definition form.

Group

Enter a name for the group that you create.

Group Description

Enter a description for the group that you create.

Generic Reference (optional)

Enter additional text to describe the group.

You can use this field to enter any government-required codes for the account.

Group Type

The system displays a value and description from the Group Type (74/GT) user-defined code (UDC) table.

The group type that the system displays and associates with the group that you create depends on the Account Type option that you selected on the Define Account Group Type form. For example, if you selected Category Code 22 on the Define Account Group Type form, the system associates and displays the code C22.

From Object

Enter the beginning of a range of object accounts to include in the account group.

This field appears only when you select By Object on the Define Account Group Type form.

To Object

Enter the end of a range of object accounts to include in the account group.

This field appears only when you select By Object on the Define Account Group Type form.

From Object.Sub

Enter the beginning of a range of object and subsidiary accounts to include in the account group.

This field appears only when you select By Object/Subsidiary on the Define Account Group Type form.

To Object.Sub

Enter the end of a range of object and subsidiary accounts to include in the account group.

This field appears only when you select By Object/Subsidiary on the Define Account Group Type form.

Account Number

Enter the account number to include in the account group.

This field appears only when you select By Account on the Define Account Group Type form.

From Category Code

Enter the beginning of a range of category codes that you include in the account group. The value that you enter must exist in the system 09 UDC table for the category code that you selected on the Define Account Group Type form. For example, if you selected Category Code 21 on the Define Account Group Type form, the value that you enter must exist in the 09/21 UDC table.

This field appears only when you select By Category Code 21, By Category Code 22, or By Category Code 23 on the Define Account Group Type form.

To Category Code

Enter the end of a range of category codes that you include in the account group. The value that you enter must exist in the system 09 UDC table for the category code that you selected on the Define Account Group Type form. For example, if you selected Category Code 21 on the Define Account Group Type form, the value that you enter must exist in the 09/21 UDC table.

This field appears only when you select By Category Code 21, By Category Code 22, or By Category Code 23 on the Define Account Group Type form.

4.5 Setting Up Layouts for Financial Statement Reports

This section provides an overview of report layouts and discusses how to:

  • Define report layouts

  • Define report sections

  • Define report columns

  • Define report rows

  • Set up cell definitions

4.5.1 Understanding Report Layouts

You set up report layouts to define the data and appearance for financial statement reports. You define sections, columns, rows, and cells, and specify the data, formatting, and formulas and functions that the system applies when you generate financial statement reports.

Before you begin setting up report layouts, you should verify with your government authorities the required data and format for the reports that you create.

As you create your report layouts, you can add new or modify existing account groups and cost center groups. You use Form and Row menus to select existing global account or cost center groups that you set up in the Financial Report Account Setup program. Additionally, you can create report-specific account or cost center groups as you create the report layouts.

4.5.1.1 Sections

Sections are the first components that you define for your report layout. For example, when you define the sections for a balance sheet report, you might define sections for assets, liabilities, and owners' equity. Each section might include a title, columns and rows, and a total for the section. When you define sections, you specify:

  • Whether the section is visible in the report.

  • Title and cost center group for the section.

  • Section header information, including the section title, the number of columns, and the layout for static text columns.

  • Section footer information, including whether the section total is shown on the report and the title for the total, and whether the system inserts a section break after the section.

4.5.1.2 Columns

The system enables you to work with two types of columns: static columns and variable columns. Static columns include text. You can change the default values for the text, but cannot apply any formulas or functions to these static columns. The system provides five static columns that you can use as headings for rows. If you do not need to use all of the static columns, indicate that the columns should not be visible in the report when you modify columns.

Variable columns are columns for which you can apply formulas and functions. You define the number of variable columns for a section when you define the sections. You can also add additional columns when you select to work with columns.

When you work with variable columns, you can specify the title for the column and whether to apply a formula, function, or factor to the column. Formulas and functions are discussed in another section of this overview. Factors are defined in the Factor to Apply (74/FR) UDC table.

4.5.1.3 Rows

You define rows for each section that you create. You can define a row to include:

  • A title

  • A single account

  • An account group

  • A formula

The data that you enter for a row varies depending on whether you specify the row as a title row, single account row, and so on. For example, if you specify that a row is for a title, you can enter text for the title. If you specify that a row is for a single account, you can enter the account number. When you edit a row for an account group, you can also select to edit the account detail. For example, if the row spans three columns, you can define the detail for the accounts for each column, including whether the total for the account appears on the reports and the description of the total.

4.5.1.4 Cells

You can modify cells in rows to override the column or row calculations for a particular cell. You can modify cells in any row except when the row is defined as a title row (row type = TIT). Rows defined as a single account or an account group row (row type = GAC or SAC) enable you to apply a function to the cell when the column that includes the cell is defined as a function column. Rows that are defined as a formula row (row type = FOR) enable you to apply a formula to the cell when the column is defined as a function or a formula column.

This table shows the cell overrides:

Row Type Function Column Formula Column
Single Account or Group Account Can override column function with a cell function Cannot override column formula
Formula Can override the row formula with a cell formula Can override both the row and column formulas with a cell formula

4.5.1.5 Formulas

You define formulas to specify the mathematical functions that the system applies to columns, rows, or cells. Refer to columns, rows, and cells using these conventions:

  • Enter sections as Sxxx, where xxx is the section number.

  • Enter columns as Cxx, where xx is the column number.

  • Enter rows as Rxxxx, where xxxx is the row number.

  • Reference cells using both the column and row number.

    For example, enter R0020C01 to refer to the cell at the intersection of row 20 and column 01 for the current section. Enter S003R0020C01 to refer to the intersection of row 20 and column 01 for the third section.

    Note:

    If you do not define the section, row, or cell, the system uses the current position.
  • Use standard arithmetic symbols.

    For example, use + for addition, - for subtraction, * for multiplication, and / for division.

  • Enclose the section, column, or row reference in brackets.

    For example, write a formula for adding the amounts in columns 01 and 02 as [C01]+[C02].

4.5.1.6 Functions

JD Edwards EnterpriseOne software provides predefined functions that you use when you define rows and cells. You select a function from the hard-coded values in the Function (74/FA) UDC table:

Codes Description 01 Description 02
(blank)    
AUDITAC_CR Audit Activity 13,14 - Credit AND13+AND14
AUDITAC_DB Audit Activity 13,14 - Debit ANC13+ANC14
AUDITACTIV Audit Activity 13,14 AN13+AN14
CURRPER_CR Current period - Credit ANCxx
CURRPER_DB Current period - Debit ANDxx
CURRPERIOD Current period Anxx
INCETODATE Inception to date APYC + (AN01 + Anxx)
PRIORYNET Prior Year Net APYN Prior Year Net
PRIORYREND Prior Year End Balance (APYC) APYC Balance Forward amount
YEARTODATE Year to date AN01 + Anxx
YTD_CR Year to date - Credit ANC01 + ANCxx
YTD_DB Year to date - Debit AND01 + ANDxx

4.5.2 Forms Used to Define Report Layouts

Form Name FormID Navigation Usage
Work with Report Definition W749101A Financial Reports (G7410), Financial Report Setup Review and select existing report definitions.
Revise Report Definition W749101B Click Add on the Work with Report Definition form. Associate a cost center and report type with a new report name.
Work With Section Definitions W749101D Select a row, and then select Edit Sections from the Row menu on the Work with Report Definition form. Review and select existing records.
Revise Section Definition W749101E Click Add on the Work With Section Definitions form. Add a new section for the report.
Work with Column Definitions W749101F Select a report section on the Work With Section Definitions form, and select Edit Columns from the Row menu. Review and select existing columns for the report.

The system displays five static columns and displays the number of variable columns that you specified on the Revise Section Definition form.

Revise Column Definition W749101G Select a column on the Work with Column Definitions form, and click Select. Modify column text and add information about formulas or functions for the column.
Work with Row Definition W749101H Select a section on the Work With Section Definitions form, and select Edit Rows from the Row menu. Review and select existing rows for the section.
Revise Row Definition W749101I Click Add on the Work with Row Definition form. Define attributes for the row.
Work with Cell Definition W749101J Select a row on the Work with Row Definition form, and select Edit Cell from the Row menu. Review and select existing records.
Revise Cell Definition W749101K Click Add on the Work with Cell Definition form. Set up a formula or function for a specific cell in a row.

You select the row on the Work with Row Definition form and select the column on the Revise Cell Definition form to work with a specific cell.


4.5.3 Defining Report Layouts

Access the Revise Report Definition form.

Report Name

Enter a name for the report layout.

Report Description

Enter a description of the report layout.

Report Type

Enter a value that exists in the Report Type Classification (74/RC) UDC table to specify whether the report layout is for a balance sheet report, a profit and loss report, or other type of report.

Cost Center Group

Enter a value that exists in the F749102 table that represents the grouping of cost centers (business units) for the report layout. You set up cost center groups by using the Financial Report Account Setup program.

4.5.4 Defining Report Sections

Access the Revise Section Definition form.

Section Number

When you create a new section, the system completes this field with the next available number. You can change this number if you are modifying a section.

Each section has its own line and column definitions. The Section Number field specifies to the report template its position in the layout.

Title (Short)

Enter a brief description for the title.

Cost Center Group

Enter the cost center group for the section. You can enter an existing report-specific cost center group or enter an existing global cost center group by selecting the Show Public Group check box on the Select Cost Center Group For Report: (report name) form. You can also create a new report-specific cost center group.

Visible

Select to make the section visible in the report.

Title (Long)

Enter the section title as you want it to appear in the report.

Number of Columns

Enter the number of variable columns for the section. Variable columns are columns that you can define with formulas and functions.

Layout for Static Columns

Select one of these options:

  • Ref1 - Desc - Ref2

  • Standard - 1 References

  • Standard - 2 References

  • Standard - 3 References

  • Summary - Desc & Columns

Section Show Total

Select to print a total for the section.

Section Break After

Select to create a page break after this section.

Total Title

Enter the text that appears next to the total for the section. For example, you might enter Total, Total Assets, or some other description of the total.

4.5.5 Defining Report Columns

Access the Work with Column Definition form.

Visible

Select to make the column visible in the report.

The system automatically includes five static columns. Static columns include only text, such as a title or heading for a line. If you do not want these columns to appear in the report, clear this check box for the columns.

Formula Column

Select to enable the entry of a formula for the column. When you select this option, the system enables the fields on the Formula tab.

Function Column

Select to enable the entry of a function for the column. When you select this option, the system enables the fields on the Function tab.

Col. Title Short 1and Col. Title Short 2

Enter a short description of the column title. This description does not appear on the report.

Col. Title Long 1and Col. Title Long 2

Enter the text for the column title as you want it to appear on the report.

4.5.5.1 Formula

Formula to Apply

Enter the formula that the system applies to the column. Use these conventions:

  • Enter sections as Sxxx, where xxx is the section number.

  • Enter columns as Cxx, where xx is the column number.

  • Enter rows as Rxxxx, where xxxx is the row number.

  • Reference cells using both the column and row number.

    For example, enter R0020C01 to refer to the cell at the intersection of row 20 and column 01 for the current section. Enter S003R0020C01 to refer to the intersection of row 20 and column 01 for the third section.

    Note:

    If you do not define the section, row, or cell, the system uses the current position.
  • Use standard arithmetic symbols.

    For example, use + for addition, - for subtraction, * for multiplication, and / for division.

  • Enclose the section, column, or row reference in brackets.

    For example, write a formula for adding the amounts in columns 01 and 02 as [C01]+[C02].

Factor To Apply

Enter a value that exists in the Factor to Apply (74/FR) UDC table to specify how the system displays positive and negative numbers.

Show Total

Select to show a total for the section.

4.5.5.2 Function

Function to Apply

Enter a value that exists in the Function (74/FC) UDC table to specify the function of the column. For example, you might select a value that inserts the prior year end balance, the period, or the inception to date.

Fiscal Year Offset

Indicate the fiscal year by performing one of these actions:

  • Leave this field blank to use the current year.

  • Enter the last two digits of a year to use that year. For example, enter 07 for the year 2007.

  • Enter a number to increment the current fiscal year. For example, enter +1 to increment the year by one.

Note:

The value that you enter here overrides the value in the processing option for the fiscal year.
Period Number Offset

Indicate the period by performing one of these actions:

  • Leave this field blank to use the current period.

  • Enter a period number.

  • Enter a number to increment the current period. For example, enter +1 to increment the period by one.

Note:

The value that you enter here overrides the value in the processing option for the period.
Ledger Type

Enter a value that exists in the Ledger Type (09/LT) UDC table to identify the ledger type of the account.

Note:

The value that you enter here overrides the values for ledger types in the processing options.
Currency Code

Enter the currency code of the account. The value that you enter here overrides the processing option.

Factor To Apply

Enter a value that exists in the Factor to Apply (74/FR) UDC table to specify how the system displays positive and negative numbers.

Show Total

Select to show a total for the section.

4.5.6 Defining Report Rows

Access the Revise Row Definition form.

Row Number

The system assigns the next available number to a row that you create. You can change the row number for new or existing rows.

Note:

The system assumes that row 001 is a title row. If you change row 001 to be other than a title, the system issues a warning.
Visible

Select to make the row visible in the report.

You might include a nonvisible row if you need a row that exists only to hold calculations.

Row Type

Select a type of row. Values are:

  • Formula

  • Group account

  • Single account

  • Title

4.5.6.1 Title

The system enables the fields on this tab when you select a row type of Title.

Row Description

Enter the text that you want to appear as the title of the row.

Lines After

Enter the number of empty lines that you want the system to insert after this row. You can specify up to 50 lines.

4.5.6.2 Account Group

The system enables the fields on this tab when you select a row type of Group Account.

Cost Center Group

Enter the cost center group for the row. You can enter an existing report-specific cost center group, enter an existing global cost center group, or create a new report-specific cost center group.

Account Group

Enter the account group for the row. You can enter an existing report-specific account group, enter an existing global account group, or create a new report-specific account group.

Reference

Enter additional text to describe the row. The text that you enter appears in the row.

Lines After

Specify the number of blank lines that the system inserts in the report. You can specify up to 50 lines.

Include Accounts Amounts in the Total

Specify whether the amount for the row is included in the total for the section.

You might exclude the account amounts from the total if the amount is included in another line. For example, if you have a formula that adds rows 5 and 6, you would likely specify that lines 5 and 6 are excluded from the totals because the amount for these lines was subtotaled elsewhere.

4.5.6.3 Account Detail

You can select this tab when working with a row type for an account group.

Show Account Detail

Select to include on the report the account details of the accounts that are included in the account group.

Column Reference

Select a type of account for each of the columns spanned by the row. Values are:

(blank)

Category Code 21

Category Code 22

Category Code 23

Cost Center

Object Account

Subsidiary

Show Total

Select the check box for each column for which you want to show the total.

Total Description

Enter a description of the total for each column for which you show the total.

4.5.6.4 Formula

The system enables the fields on this tab when you select a row type of Formula.

Row Description

Enter text that the system uses to describe the row. The text that you enter appears in the report.

Reference

Enter additional text to describe the row. The text that you enter appears in the row.

Formula to Apply

Enter the formula for the row. The system uses the formula that you enter for each column of the row. Use these conventions:

  • Enter sections as Sxxx, where xxx is the section number.

  • Enter columns as Cxx, where xx is the column number.

  • Enter rows as Rxxxx, where xxxx is the row number.

  • Reference cells using both the column and row number.

    For example, enter R0020C01 to refer to the cell at the intersection of row 20 and column 01 for the current section. Enter S003R0020C01 to refer to the intersection of row 20 and column 01 for the third section.

    Note:

    If you do not define the section, row, or cell, the system uses the current position.
  • Use standard arithmetic symbols.

    For example, use + for addition, - for subtraction, * for multiplication, and / for division.

  • Enclose the section, column, or row reference in brackets.

    For example, write a formula for adding the amounts in columns 01 and 02 as [C01]+[C02].

Lines After

Specify the number of blank lines that the system inserts in the report. You can specify up to 50 lines.

Include Account Amount in the Total

Specify whether the amount for the row is included in the total for the section.

You might exclude the account amounts from the total if the amount is included in another line. For example, if you have a formula that adds rows 5 and 6, you would likely specify that lines 5 and 6 are excluded from the totals because the amount for these lines was subtotaled elsewhere.

4.5.6.5 Single Account

The system enables the fields on this tab when you select a row type of Single Account.

Account Number

Enter the account number.

Reference

Enter additional text that the system prints in the row.

Lines After

Specify the number of blank lines that the system inserts in the report. You can specify up to 50 lines.

Include Account Amount in the Total

Specify whether the amount for the row is included in the total for the section.

You might exclude the account amounts from the total if the amount is included in another line. For example, if you have a formula that adds rows 5 and 6, you would likely specify that lines 5 and 6 are excluded from the totals because the amount for these lines was subtotaled elsewhere.

4.5.7 Setting Up Cell Definitions

Access the Work with Row Definition form.

To set up a cell definition:

  1. On the Work with Row Definition form, select the row that includes the cell for which you want to define a formula or function, and select Edit Cell from the Row menu.

    You cannot select a row type TIT (title).

  2. Click Add on the Work with Cell Definition form.

    The system displays the Revise Cell Definition form with fields on the Formula tab enabled if the row that you selected is a row type of FOR (formula).

    The system enables the fields on the Function tab if the row that you selected is a row type of GAC (Group Account) or SAC (single account).

  3. On the Revise Cell Definition form, complete the Column Number field with the number of the column that includes the cell for which you want to define a formula or function.

    Alternatively, you can use the Previous Column and Next Column buttons to navigate to the correct column.

  4. Complete the remaining fields, as necessary.

4.5.7.1 Formula

Formula to Apply

Enter the formula for the cell. Use these conventions:

  • Enter sections as Sxxx, where xxx is the section number.

  • Enter columns as Cxx, where xx is the column number.

  • Enter rows as Rxxxx, where xxxx is the row number.

  • Reference cells using both the column and row number.

    For example, enter R0020C01 to refer to the cell at the intersection of row 20 and column 01 for the current section. Enter S003R0020C01 to refer to the intersection of row 20 and column 01 for the third section.

    Note:

    If you do not define the section, row, or cell, the system uses the current position.
  • Use standard arithmetic symbols.

    For example, use + for addition, - for subtraction, * for multiplication, and / for division.

  • Enclose the section, column, or row reference in brackets.

    For example, write a formula for adding the amounts in columns 01 and 02 as [C01]+[C02].

Factor to Apply

Enter a value that exists in the Factor to Apply (74/FR) UDC table to specify how the system displays positive and negative numbers.

4.5.7.2 Function

Function to Apply

Enter a value that exists in the Function (74/FC) UDC table to specify the function of the column. For example, you might select a value that inserts the prior year-end balance, the period, or the inception to date.

Period Number Offset

Indicate the period by performing one of these actions:

  • Leave this field blank to use the current period.

  • Enter a period number.

  • Enter a number to increment the current period. For example, enter +1 to increment the period by one.

Fiscal Year Offset

Indicate the fiscal year by performing one of these actions:

  • Leave this field blank to use the current year.

  • Enter the last two digits of a year to use that year. For example, enter 07 for the year 2007.

  • Enter a number to increment the current fiscal year. For example, enter +1 to increment the year by one.

Ledger Type

Enter the ledger type of the account.

Currency Code

Enter the currency code of the account.

Factor To Apply

Enter a value that exists in the Factor to Apply (74/FR) UDC table to specify how the system displays positive and negative numbers.