This chapter contains the following topics:
Section 4.1, "Generating the Trial Balance by Category Code Report"
Section 4.2, "Generating the Trial Balance by Object Account Report"
Section 4.3, "Generating Financial Statement Reports for Hungary"
This section provides an overview of the Trial Balance by Cat. Code report and discusses how to:
Run the Trial Balance by Cat. Code program.
Set processing options for Trial Balance by Cat. Code (R74H9472).
Use the Trial Balance by Cat. Code report to print a statutory account (category code value) on a trial balance instead of the business unit.object.subsidiary account code. The category code indicates the account number, and the category code description indicates the account description. Use this report to obtain debit and credit totals, and to supplement your chart of accounts reporting for multinational companies and for statutory accounting.
This report is similar to the Debit/Credit T/B by Category Code program (R7409472). The Trial Balance by Cat. Code program uses the same logic as the Debit/Credit T/B by Category Code program, but displays opening balance and closing balance columns. The Trial Balance by Cat. Code program does not display the Cumulative YTD columns, but they are included in the opening balance. Additionally the summary sections of the two reports are different. The Trial Balance by Cat. Code program includes a summary of the account and a subtotal by account group. This group of accounts is defined by values in the Tax Summary Code (74H/TS) user-defined code (UDC) table.
Select General Ledger (G74H09), Trial Balance by Cat. Code.
Processing options enable you to specify default processing values.
Specify the fiscal year for the system to use when selecting records to print on this report. If you leave this processing option blank, the system uses the current fiscal year.
Specify the period number for the system to use when selecting records to print on this report. If you leave this processing option blank, the system uses the current period number.
Specify the ledger type for the system to use when selecting records to print on this report. Enter a valid ledger type from the F0025 table. If you leave this processing option blank, the system uses ledger type AA.
Use this processing option to specify the account category code (21–23) that the system prints on the report. Enter R0xx, where xx is the category code. If you leave this processing option blank, the system uses R021.
The value that you enter for this processing option is used only to print the category codes on the report. It is not used for data selection.
Enter a value that exists in the System Code (98/SY) UDC table to specify the system in which the summary accounts are defined. If you leave this processing option blank, the system uses the GL category codes.
Enter the UDC code that is associated with the value that you entered in the Product Code processing option to define summary accounts. If you leave this processing option blank, the system uses the GL category codes.
This section provides an overview of the Trial Balance by Object Account report and discusses how to:
Run the Trial Balance by Obj. Account program.
Set processing options for Trial Balance by Obj. Account (R74H9473).
Use the Trial Balance by Object Account program to print the total debit and credit amounts for each account in any given ledger.
This report is based on the Debit/Credit T/B by Object program (R09473). The Trial Balance by Obj. Account program uses the same logic as the Debit/Credit T/B by Object program, but displays opening balance, debit, credit, and closing balance columns. Additionally, the summary sections of the two reports are different. The Trial Balance by Cat. Code program includes a summary of the account and a subtotal by account group. This group of accounts is defined by values in the Tax Summary Code (74H/TS) UDC table.
Select General Ledger (G74H09), Trial Balance by Obj. Account.
Processing options enable you to specify default processing values.
Specify the period for which the trial balance prints. If you complete this processing option, you must also specify the fiscal year for the period in the Fiscal Year processing option. If you leave this processing option blank, the program uses the current period.
Specify the last two digits of the fiscal year for which the trial balance prints. For example, enter 07 for 2007. If you complete this processing option, you must also complete the Period Number processing option.
If you leave this processing option blank, the program uses the current fiscal year.
Specify the first, second, and third ledger type on which you want to report. Enter a value from UDC table 09/LT.
Specify whether to include accounts with zero balances in the selected period.
Specify whether you want a Balance column and a Difference column to print on the report. The Balance column prints the account's current balance, calculated from the table. This Balance column is then compared to the Cumulative YTD Total column on the report, which is calculated from the F0911 table. Any differences found between the Cumulative YTD Total column and the Balance column are printed in the Difference column on the report.
Specify whether the system summarizes all subsidiary accounts into one object account.
Specify whether you want totals for the GLGx automatic accounting instruction (AAI) ranges to print on the report. These totals print after the appropriate object account, according to the account ranges that are set up for the default company (company 00000) in AAI item GLGx. Totals are printed for these account ranges:
GLG2 - GLG3: Assets.
GLG3 - GLG5: Liabilities.
GLG5: YTD Income.
GLG6 - GLG7: Revenues.
GLG8 - GLG9: Cost of Goods Sold (COGS).
GLG11 - GLG13: Other Income.
GLG13 - GLG12: Other Expenses.
Specify how the system classifies accounts for purposes of subtotaling. The report classifies accounts by account number. You can classify by one, two, three, or four digits of the account number. The report includes a class total for each classification.
For example, if you classify accounts by two digits, the report includes a class total for accounts 1000 through 1099, another class total for accounts 1100 through 1199, and so on. If you classify accounts by three digits, the report includes a class total for accounts 1100 through 1110, another class total for accounts 1111 through 1119, and so on.
If you classify accounts by all four digits, each object account has its own class total; subsidiary accounts to a single object are included in the class total.
The system includes class totals at the level that you specify and at lower levels. For example, if you classify accounts by two digits, the report includes a class total for accounts 1000 through 1999, in addition to the class totals for accounts 1000 through 1099, 1100 through 1199, and so on.
Specify the mode in which you want to run this report.
Note: You can run this report in final mode only once for the selected period and fiscal year. The transactions that are printed in final mode do not appear if you run the report again. |
Specify an as if currency code in which to print amounts for this report. This processing option enables you to review amounts in a currency other than the currency in which they are stored. Only amounts that are associated with the AA ledger type are converted to the as if currency. If you leave this processing option blank, amounts do not print in an as if currency.
If you leave this processing option blank, the As If Currency column does not appear on the report.
Specify the date on which to retrieve the exchange rate for the as if currency from the F0015 table. If you enter a value for the As If Currency Code processing option and leave this processing option blank, the system uses the date that is specified in the Thru Date processing option for the exchange rate.
Enter a value that exists in the System Code (98/SY) to specify the system in which the summary accounts are defined. If you leave this processing option blank, the system uses the account master.
Enter the UDC code that is associated with the value that you entered in the Product Code processing option to define summary accounts. If you leave this processing option blank, the system uses the account master.
This section provides an overview of financial statement reports, lists a prerequisite, and discusses how to:
Run the Generate Financial Report program.
Set processing options for Generate Financial Report (R749110).
Use the Generate Financial Report program (R749110) to print profit and loss, balance sheet, and other financial statement reports for Hungary. 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.
Before you complete the tasks in this section, set up layouts for financial statement reports.
Select Financial Reports (G7410), Generate Financial Report.
Processing options enable you to set default processing values.
Specify the last two digits of the fiscal year for which the trial balance will be 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 processing option. If you leave this processing option blank, the program uses the fiscal year.
Enter the period for which the trial balance will be 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.
Enter the company for which you process records.
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)
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. |
Enter 1 to show account detail. Leave this processing option blank to suppress printing of account details.
Enter a value that exists in the Scale Factor (74/SF) UDC table to specify the factor by which the system divides the value.
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 center.
Specify whether to print amounts for accounts with subledgers. Enter a specific subledger number to use that ledger. Enter * 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.
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.
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 * (asterisk). 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. |
Enter a value that exists in the Ledger Types (09/LT) UDC table. You can specify up to four ledger types.
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.
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.
Enter the version of the program that is specified in the Report Layout processing option.
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.
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.
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.
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.