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

This chapter provides an overview of the setup of accounts and layouts for financial statement reports and discusses how to:

Set up user-defined codes (UDCs).
Set up cost center groups for financial statement reports.
Set up account groups for financial statement reports.
Set up layouts for financial statement reports.

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.

Setting Up UDCs for Financial Statement Reports

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

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

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

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

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

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

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

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.

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.

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).

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.

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.

Setting Up Account Groups for Financial Statement Reports

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

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

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 cost center 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.

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.

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.

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

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.

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.

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.

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.

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

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].

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

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.

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.

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 exisiting 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.

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 1 and 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.

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.

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.

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

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.

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.

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.

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.

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.

Setting Up Cell Definitions

Access the Work with Row Definition form.

To set up a cell definition:

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).
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).
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.
Complete the remaining fields, as necessary.

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.

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.