7 Generating Financial Statement Reports for the Czech Republic

This chapter contains the following topics:

7.1 Understanding Financial Statement Reports

Use the Generate Financial Report program (R749110) to print profit and loss, balance sheet, and other financial statement reports for the Czech Republic. You use the Financial Report Setup (P749101) and Financial Report Account Setup (R749102) programs to identify the layout of the report and the accounts to include, and then use the Generate Financial Report program to print the reports that you set up.

7.2 Running the Generate Financial Report Program

Select Financial Reports (G7410), Generate Financial Report.

7.3 Setting Processing Options for Generate Financial Report (R749110)

Processing options enable you to set default processing values.

7.3.1 Period

1. Fiscal Year

Specify the last two digits of the fiscal year for which the report is printed. For example, enter 07 for 2007. If you complete this processing option, you must also specify the ending period number in the Period Number - General Ledger processing option. If you leave this processing option blank, the program uses the fiscal year that is defined for the JD Edwards EnterpriseOne General Accounting system on the Company Setup form and recorded in the Company Constants table (F0010).

2. Period Number - General Ledger

Enter the period for which the report is printed. If you complete this processing option, you must also specify the fiscal year for the ending period in the Fiscal Year processing option. If you leave this processing option blank, the program uses the current period that is defined for the JD Edwards EnterpriseOne General Accounting system on the Company Setup form and recorded in the Company Constants table.

3. Company

Enter the company for which you process records.

7.3.2 Print

4. Account Number Format

Specify the format for printed account numbers. Values are:

1 or blank: Standard account number (The default is business unit.object.subsidiary)

2: Short account ID (The system assigns)

3: Third G/L number (Your organization can assign during account setup)

5. Accounts with Zero Balances

Specify whether the system includes or omits accounts with zero balances for the specified period. Values are:

Blank: Include accounts with zero balances.

1: Omit accounts with zero balances.


Note:

Accounts that are assigned a posting edit code of N print even when you set this processing option to 1. Accounts that are assigned a posting edit code of N are header accounts, which do not have balances.

6. Show Account Detail

Enter 1 to show account detail. Leave this processing option blank to suppress printing of account details.

7. Scale Factor

Enter a value that exists in the Scale Factor (74/SF) user-defined code (UDC) table to specify the factor by which the system divides the value.

7.3.3 Cost Center / Subledger

7. Cost Center Group

Enter a value to override the cost center group definition in the report setup. The cost center group represents a subset of cost centers. Financial reports use the cost center group to filter the accounts that belong to the specified cost centers.

8. Subledger - G/L

Specify whether to print amounts for accounts with subledgers. Enter a specific subledger number to use that ledger. Enter * (asterisk) to include all subledgers. Leave this processing option blank to include only accounts without subledgers.

If you complete this processing option, you must also complete the Subledger Type processing option.

9. Subledger Type

Enter a value that exists in the Subledger Type (00/ST) UDC table to specify the table containing the subledger numbers. For example, subledger type A identifies the Address Book Master table (F0101). If you complete this processing option, you must also complete the Subledger - G/L processing option.

7.3.4 Currency Code

10. Currency Code - From

Specify the currencies that the system includes in the report when you post account balances by currency. To limit the report to amounts for a specific currency code, enter the code for the currency. The value that you enter must exist in the Currency Codes table (F0013). To include amounts for all currencies, enter *. Leave this processing option blank if you do not post balances by currency.


Note:

If you specify the CA ledger type in the Ledger Type processing option, and the CA ledger type includes amounts for multiple currencies, the totals will be meaningless unless you enter a specific currency code for this processing option.

7.3.5 Ledger

11. Ledger Types

Enter a value that exists in the Ledger Types (09/LT) UDC table. You can specify up to four ledger types.

7.3.6 Layout

12. Report Name

Enter a report name that you set up in the Financial Report Setup program (P749101). The system uses this value to determine the report specifications.

13. Report Layout

Enter a value that exists in the Reports Layout (74/RL) UDC table to specify whether the report is generated in landscape or portrait mode.

14. Version

Enter the version of the program that is specified in the Report Layout processing option.

15. Title Line 1

Enter the text that the system prints for the first line of the report title. If you leave this processing option blank, the system does not print a title.

16. Title Line 2

Enter the text that the system prints for the second line of the report title. If you leave this processing option blank, the system does not print a second line.

7.3.7 Process

17. Reuse Last Account Definition

Enter 1 to reuse the account structure that was created by the last run. You can reuse the account structure only when recalculating or reprinting. If you enter 1 but have changed the report template or account structure, your system might generate invalid data.

18. Clear Work Files

Enter 1 to clear the work files. Oracle recommends that you clear the work files only when required, such as when the Work Center generates a message that you must do so.