This chapter contains the following topics:
Section 4.1, "Understanding the Setup of Accounts and Layouts for Financial Statement Reports"
Section 4.2, "Setting Up UDCs for Financial Statement Reports"
Section 4.3, "Setting Up Cost Center Groups for Financial Statement Reports"
Section 4.4, "Setting Up Account Groups for Financial Statement Reports"
Section 4.5, "Setting Up 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.
Before you set up and generate financial statement reports, set up these UDCs.
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 |
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 |
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 |
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 |
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 |
This section provides an overview of cost center groups and discusses how to set up global 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.
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).
Access the Edit Cost Center Group Definition form.
Enter a name for the group that you create.
Enter a description for the group that you create.
Enter the beginning of a range of business units that you want to include in this cost center group.
Enter the end of a range of business units that you want to include in this cost center group.
This section provides an overview of account groups and discusses how to set up 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
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.
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.
Enter a name for the group that you create.
Enter a description for the group that you create.
Enter additional text to describe the group.
You can use this field to enter any government-required codes for the account.
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.
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.
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.
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.
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.
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.
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.
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.
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
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 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.
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.
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.
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 |
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].
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 |
| 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. |
Access the Revise Report Definition form.
Enter a name for the report layout.
Enter a description of the report layout.
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.
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.
Access the Revise Section Definition form.
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.
Enter a brief description for the title.
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.
Select to make the section visible in the report.
Enter the section title as you want it to appear in the report.
Enter the number of variable columns for the section. Variable columns are columns that you can define with formulas and functions.
Select one of these options:
Ref1 - Desc - Ref2
Standard - 1 References
Standard - 2 References
Standard - 3 References
Summary - Desc & Columns
Select to print a total for the section.
Select to create a page break after this section.
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.
Access the Work with Column Definition form.
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.
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.
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.
Enter a short description of the column title. This description does not appear on the report.
Enter the text for the column title as you want it to appear on the report.
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].
Enter a value that exists in the Factor to Apply (74/FR) UDC table to specify how the system displays positive and negative numbers.
Select to show a total for the section.
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.
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. |
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. |
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. |
Enter the currency code of the account. The value that you enter here overrides the processing option.
Enter a value that exists in the Factor to Apply (74/FR) UDC table to specify how the system displays positive and negative numbers.
Select to show a total for the section.
Access the Revise Row Definition form.
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. |
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.
Select a type of row. Values are:
Formula
Group account
Single account
Title
The system enables the fields on this tab when you select a row type of Title.
Enter the text that you want to appear as the title of the row.
Enter the number of empty lines that you want the system to insert after this row. You can specify up to 50 lines.
The system enables the fields on this tab when you select a row type of Group Account.
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.
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.
Enter additional text to describe the row. The text that you enter appears in the row.
Specify the number of blank lines that the system inserts in the report. You can specify up to 50 lines.
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.
You can select this tab when working with a row type for an account group.
Select to include on the report the account details of the accounts that are included in the account group.
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
Select the check box for each column for which you want to show the total.
Enter a description of the total for each column for which you show the total.
The system enables the fields on this tab when you select a row type of Formula.
Enter text that the system uses to describe the row. The text that you enter appears in the report.
Enter additional text to describe the row. The text that you enter appears in the row.
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].
Specify the number of blank lines that the system inserts in the report. You can specify up to 50 lines.
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.
The system enables the fields on this tab when you select a row type of Single Account.
Enter the account number.
Enter additional text that the system prints in the row.
Specify the number of blank lines that the system inserts in the report. You can specify up to 50 lines.
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.
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.
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].
Enter a value that exists in the Factor to Apply (74/FR) UDC table to specify how the system displays positive and negative numbers.
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.
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.
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.
Enter the ledger type of the account.
Enter the currency code of the account.
Enter a value that exists in the Factor to Apply (74/FR) UDC table to specify how the system displays positive and negative numbers.