This chapter contains the following topics:
Section 8.1, "Understanding the Dynamic Generation of Reports"
Section 8.2, "Generating the Details of the Cash Flow Statement Items"
Section 8.3, "Generating the Statement of VAT Payables Information"
Section 8.4, "Generating the Depreciation of Property Statement Items"
Section 8.5, "Generating the Details of the Statement of Changes in Stockholder's Equity"
Section 8.6, "Generating the Profit Appropriation Statement"
You can specify the list of the cell numbers in which you need to display a specific item in the processing options of the respective reports. You can specify the cell numbers by mentioning the sequence number of the item and the column number. The sequence number is defined in the Report Format Definition program (P75C003). The column number is sequential with the first amount column starting with A. For example, if you want to display the item Beginning Amount in the report for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in the processing option Beginning Amount.This enables you to run your report dynamically, choosing the cell and the value in it, as per your requirement.
You can configure a cell with any of the following options:
Enter the beginning amount of the year for a specific natural account or a combination of natural accounts.
Enter the net amount of the period for a specific natural account.
Enter the total positive amount of all transactions for a particular year and a specific account. These positive amounts are listed in the Account Ledger table (F0911).
Enter the total negative amount of all transactions for a particular year and a specific account. These negative amounts are listed in the Account Ledger table (F0911).
Enter the closing balance of the particular period including the beginning balance of the same period.
Enter the closing balance of the particular period excluding the beginning balance of the period.
Enter the total positive amount of all transactions for a particular period and a particular account. These positive amounts are listed in the Account Ledger table (F0911).
Enter the total negative amount of all transactions for a particular period and a particular account. These negative amounts are listed in the Account Ledger table (F0911).
Enter amount that is retrieved from the respective table and is displayed after reversing the sign. That is, a positive value is displayed as negative and vice versa.
This section provides an overview of the cash flow statement items for large and small enterprises and discusses how to:
Set processing options for the China Cash Flow Statement Output – CNAO (R75C0910).
Generate the cash flow statement items details.
The cash flow statement shows the historical changes in cash and cash equivalents during a specified period of operations for a company. You use the China Cash Flow Statement Output – CNAO program (R75C0910) to generate the details of the cash flow statements from the JD Edwards EnterpriseOne system into TXT XML, and PDF files whose format is predefined. The details include the items and amounts calculated based on the JD Edwards EnterpriseOne general ledger and sub-modules.
You can specify if you are generating the cash flow statement for a large enterprise or for a small enterprise, in the processing option of the China Cash Flow Statement Output – CNAO program.
The report is generated on a monthly basis. The China Cash Flow Statement Output – CNAO program retrieves information from the Chart of Accounts (F75C007), Account Balances (F0902), Dynamic XML Output Generator (F75CDXM), Report Items (F75C003), Item – Natural Account Mapping (F75C004), Item – Formula (F75C005) and Account Ledger (F0911) tables.
Processing options enable you to specify the default processing for programs and reports.
Specify the code that identifies a specific organization, fund, or other reporting entity.
Specify the number that identifies the fiscal year of the company.
Specify a number (from 1 to 14) that identifies the current accounting period.
Specify the type of ledger used for domestic transactions.
If you leave this processing option blank, the system uses ledger AA.
Specify the type of ledger used for foreign transactions.
Blank: CA
Specify the language for the report. Values are:
1: English
2: Chinese
3: Both
Specify if the cash flow statement is for the large enterprise or for a small enterprise. Values are:
N: Large scale enterprise.
Y: Small scale enterprise.
Specify the address book number of the issuing organization.
Specify the unique statement number issued to you by the government.
Specify the path to which the system saves the output XML. If you do not complete this processing option, the system does not save the XML file.
Specify the path to which the system saves the text file. If you do not complete this processing option, the system does not save the text file.
Specify a value from UDC table 75C/MU to indicate the monetary unit, which is a scale of the actual amount. For example, if the actual amount is 145,000.00, a monetary unit of 1 displays the amount as 145,000.00 whereas a monetary unit of 10 displays the amount as 14,500.00. Examples are:
1: One yuan
100: Hundred yuan
Note: After scaling the values, the system rounds it to the nearest number. |
Specify the sequence number for the line item Effect of Foreign Exchange Rate Changes on Cash in the CNAO reports.
Effect of Foreign Exchange Rate Changes on Cash is a line item in the cash flow statement that is used to record the exchange gain or loss that occurs between the transaction date and the reporting date during the foreign currency transactions.
If you leave this processing option blank, the system uses 320.
Specify the net amount result that corresponds to the changes in the foreign exchange rate in the current year.
Specify the net amount effected corresponding to the changes in the foreign exchange rate in the last year. You complete this processing option for small enterprises only.
Specify the list of the cell numbers in which to display the beginning amount. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the period amount. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year to this period amount that includes the beginning balance amount. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year to this period amount that excludes the beginning balance. For example, if you want to display the year for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the period positive. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Period positive is the total positive amount of all transactions for a particular period and a specific account. These positive amounts are listed in the Account Ledger table (F0911).
Specify the list of the cell numbers in which to display the period negative. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Period negative is the total negative amount of all transactions for a particular period and a specific account. These negative amounts are listed in the Account Ledger table (F0911).
Specify the list of the cell numbers in which to display the amount with a reverse sign. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year positive. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year positive is the total positive amount of all transactions for a particular year and a specific account. These positive amounts are listed in the Account Ledger table (F0911).
Specify the list of the cell numbers in which to display the year negative. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year negative is the total negative amount of all transactions for a particular year and a specific account. These negative amounts are listed in the Account Ledger table (F0911).
Select CNAO-Cash flow statement (G75CCNAO9), Cash flow statement.
This section provides an overview of the statement of VAT payables and discusses how to:
Set processing options for Statement of VAT Payables (R75C0987).
Generate the Statement of VAT Payables information.
The statement of VAT payables consists of the details of the VAT that is payable to the government. You use the Statement of VAT Payables program (R75C0987) to generate the VAT payable information in the JD Edwards EnterpriseOne general ledger to the TXT, XML, and PDF files.
The Statement of VAT Payables program retrieves data from the Account master - Tag file - China Localization table (F75C091), Natural Account Set Up table (F75C006), China – Chart of Accounts Set Up table (F75C007), Report Items table (F75C003), and the Account Balances table (F0902).
Processing options enable you to specify the default processing for programs and reports.
Specify the code that identifies a specific organization, fund, or other reporting entity.
Specify the number that identifies the fiscal year of the company.
Specify a number (from 1 to 14) that identifies the current accounting period.
Specify the type of ledger used for domestic transactions.
If you leave this processing option blank, the system uses ledger type AA.
Specify the type of ledger used for foreign transactions.
If you leave this processing option blank, the system uses ledger type CA.
Specify the language for the report. Values are:
1: English
2: Chinese
3: Both
Specify the address book number of the issuing organization.
Specify the reporting date for which you run the program.
Specify the unique statement number issued to you by the government.
Specify the path to which the system saves the XML file. If you do not complete this processing option, the system does not save the XML file.
Specify the path to which the system saves the text file. If you do not complete this processing option, the system does not save the text file.
Specify a value from UDC table 75C/MU to indicate the monetary unit, which is a scale of the actual amount. For example, if the actual amount is 145,000.00, a monetary unit of 1 displays the amount as 145,000.00 whereas a monetary unit of 10 displays the amount as14,500.00. Examples are:
1: One yuan
100: Hundred yuan
Note: After scaling the values, the system rounds the amount to the nearest number. |
Specify the list of the cell numbers in which to display the beginning amount. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which you need to display the period amount. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell number in which to display the year–to–date amount including the beginning balance. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell number in which to display the year-to-date amount, excluding the beginning balance. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the period positive. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Period positive is the total positive amount of all transactions for a particular period and a specific account. These positive amounts are listed in the Account Ledger table (F0911).
Specify the list of the cell numbers in which to display the period negative. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Period negative is the total negative amount of all transactions for a particular period and a specific account. These negative amounts are listed in the Account Ledger table (F0911).
Specify the list of the cell numbers in which to display the amount with reverse sign. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year positive. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year positive is the total positive amount of all transactions for a particular year and a specific account. These positive amounts are listed in the Account Ledger table (F0911).
Specify the list of the cell numbers in which to display the year negative. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year negative is the total negative amount of all transactions for a particular year and a specific account. These negative amounts are listed in the Account Ledger table (F0911).
Select Statement of value added tax payables (G75CCNAO10), CNAO-Statement of value added tax payables.
This section provides an overview of the depreciation of property statement items and discusses how to:
Set processing options for Provision of Depreciation of Property Statement (R75C0905).
Provision for the depreciation of property statement items.
Property statements mention the details such as the total debt, short term investment, provision for loss and so on for a company. You use the Provision of Depreciation of Property Statement program (R75C0905) to generate the depreciation of items mentioned in the property statement. The system exports the depreciation amounts calculated from each general ledger of JD Edwards EnterpriseOne to the TXT and XML flat files and to the PDF file. The system runs the Provision of Depreciation of Property Statement program on an annual basis.
The Provision of Depreciation of Property Statement program uses the data from the Account Balances table (F0902), the Account Master table (F0901), and the Account Ledger table (F0911).
Processing options enable you to specify the default processing for programs and reports.
Specify the code that identifies a specific organization, fund, or other reporting entity.
Specify the number that identifies the fiscal year of the company.
Specify the type of ledger used for domestic transactions.
If you leave this processing option blank, the system uses ledger type AA.
Specify the type of ledger used for foreign transactions.
If you leave this processing option blank, the system uses ledger type CA.
Specify the language for the report. Values are:
1: English
2: Chinese
3: Both
Specify the address book number of the issuing organization.
Specify the unique statement number issued to you by the government.
Specify the path to which the system saves the XML file. If you do not complete this processing option, the system does not save the XML file.
Specify the path to which the system saves the text file. If you do not complete this processing option, the system does not save the text file.
Specify a value from UDC table 75C/MU to indicate the monetary unit, which is a scale of the actual amount. For example, if the actual amount is 145,000.00, a monetary unit of 1 displays the amount as 145,000.00 whereas a monetary unit of 10 displays the amount as14,500.00. Examples are:
1: One yuan
100: Hundred yuan
Note: After scaling the values, the system rounds the amount to the nearest number. |
Specify the reporting date for which you run the program.
Specify the list of the cell numbers in which to display the beginning amount. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year positive. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year positive is the total positive amount of all transactions for a particular year and a specific account. These positive amounts are listed in the Account Ledger table (F0911).
Specify the list of the cell number in which to display the year–to–date amount including the beginning balance. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell number in which to display the year-to-date amount, excluding the beginning balance. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the amount with reverse sign. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year negative. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year negative is the total negative amount of all transactions for a particular year and a specific account. These negative amounts are listed in the Account Ledger table (F0911).
Select Provision of depreciation of property statement (G75CCNA011), CNAO-Provision of depreciation of property statement.
This section provides an overview of the statement of changes in stockholder's equity and discusses how to:
Set processing options for Statement of Changes in Stockholder's Equity (R75C0906).
Generate the details of the statement of changes in stockholder's equity.
The statement of changes in stockholder's equity summarizes the revenues and expenses during the accounting period and shows the condition of accounts at the end of a particular period. You use the Statement of Changes in Stockholder's Equity program (R75C0906) to generate the information of the items and amounts calculated based on the corresponding JD Edwards EnterpriseOne accounts into the TXT, XML, and PDF files. Run this report annually.
The Statement of Changes in Stockholder's Equity program retrieves data from the Report Items table (F75C003), the Account Balances table (F0902), and the Account Ledger table (F0911).
Processing options enable you to specify the default processing for programs and reports.
Specify the code that identifies a specific organization, fund, or other reporting entity.
Specify the number that identifies the fiscal year of the company.
Specify the type of ledger used for domestic transactions.
If you leave this processing option blank, the system uses ledger type AA.
Specify the type of ledger used for foreign transactions.
If you leave this processing option blank, the system uses ledger type CA.
Specify the language for the report. Values are:
1: English
2: Chinese
3: Both
Specify the address book number of the issuing organization.
Specify the unique statement number issued to you by the government.
Specify the path to which the system saves the XML file. If you do not complete this processing option, the system does not save the XML file.
Specify the path to which the system saves the text file. If you do not complete this processing option, the system does not save the text file.
Specify a value from UDC table 75C/MU to indicate the monetary unit, which is a scale of the actual amount. For example, if the actual amount is 145,000.00, a monetary unit of 1 displays the amount as 145,000.00 whereas a monetary unit of 10 displays the amount as14,500.00. Examples are:
1: One yuan
100: Hundred yuan
Note: After scaling the values, the system rounds the amount to the nearest number. |
Specify the reporting date for which you run the program.
Specify the list of the cell numbers in which to display the beginning amount. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year positive. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year positive is the total positive amount of all transactions for a particular year and a specific account. These positive amounts are listed in the Account Ledger table (F0911).
Specify the list of the cell number in which to display the year–to–date amount including the beginning balance. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell number in which to display the year-to-date amount, excluding the beginning balance. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the amount with reverse sign. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year negative. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year negative is the total negative amount of all transactions for a particular year and a specific account. These negative amounts are listed in the Account Ledger table (F0911).
Select Statement of changes in stockholders' equity (G75CCNAO12), CNAO-Statement of changes in stockholders' equity.
This section provides an overview of the profit appropriation statement and discusses how to:
Set processing options for Profit Appropriation Statement (R75C0907).
Generate the profit appropriation statement.
You use the Profit Appropriation Statement program (R75C0907)to generate the profit appropriation information of a particular company, period, financial year, and ledger type into TXT, XML, and PDF files.
The report uses data from the Account master - Tag file - China Localization table (F75C091), China – Chart of Accounts Set Up table (F75C007), Natural Account Set Up table (F75C006), Report Items table (F75C003), and the Accounts Ledger table (F0911).
Processing options enable you to specify the default processing for programs and reports.
Specify the code that identifies a specific organization, fund, or other reporting entity.
Specify the number that identifies the fiscal year of the company.
Specify the type of ledger used for domestic transactions.
If you leave this processing option blank, the system uses ledger type AA.
Specify the type of ledger used for foreign transactions.
If you leave this processing option blank, the system uses ledger type CA.
Specify the language for the report. Values are:
1: English
2: Chinese
3: Both
Specify the address book number of the issuing organization.
Specify the unique statement number issued to you by the government.
Specify the path to which the system saves the XML file. If you do not complete this processing option, the system does not save the XML file.
Specify the path to which the system saves the text file. If you do not complete this processing option, the system does not save the text file.
Specify a value from UDC table 75C/MU to indicate the monetary unit, which is a scale of the actual amount. For example, if the actual amount is 145,000.00, a monetary unit of 1 displays the amount as 145,000.00 whereas a monetary unit of 10 displays the amount as14,500.00. Examples are:
1: One yuan
100: Hundred yuan
Note: After scaling the values, the system rounds the amount to the nearest number. |
Specify the reporting date for which you run the program.
Specify the list of the cell numbers in which to display the beginning amount. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year positive. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year positive is the total positive amount of all transactions for a particular year and a specific account. These positive amounts are listed in the Account Ledger table (F0911).
Specify the list of the cell number in which to display the year-to-date amount including the beginning balance. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell number in which to display the year-to-date amount, excluding the beginning balance. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the amount with reverse sign. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Specify the list of the cell numbers in which to display the year negative. For example, if you want to display the amount for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in this processing option.
Year negative is the total negative amount of all transactions for a particular year and a specific account. These negative amounts are listed in the Account Ledger table (F0911).
Select Profit appropriation statement (G75CCNAO13), CNAO-Profit appropriation statement.
This section provides an overview of the CNAO flat file names and discusses how to:
Set processing options for GSSM Generator (R75C0999).
Generate the CNAO flat file names.
Chinese standards require you to export the financial information such as fiscal period end, year-end reports, journals, and transactions into either XML or a TXT file and send it to CNAO for an audit. The XML and the TXT files have a specific format. You use the GSSM Generator program (R75C0999) to define the format and the names of these output flat files. This report generates a TXT file that contains the file names of the CNAO reports, the fields used in these reports, and the definition of each field. Each field is defined as:
[Field Name] [Data Type] [Field Length].
You specify the names of the CNAO reports in the processing option for each report.
Processing options enable you to specify the default processing for programs and reports.
Enter the filenames of the following flat files:
Specify a file name for the text file output of the Electronic Accounting Book report (R75C002).
Specify a file name for the text file output of the E1 Account to Natural Account Setup report (R75C0903).
Specify a file name for the text file output of the Account Balance and Period Amount report (R75C0902).
Specify a file name for the text file output of the Account Balance and Period Amount report (R75C0902).
Specify a file name for the text file output of the China Balance Sheet CNAO report (R75C111B).
Specify a file name for the text file output of the Income Statement report (R75C0904).
Specify a file name for the text file output of the China Cash Flow Statement Output – CNAO report (R75C0910).
Specify a file name for the text file output of the Statement of VAT Payables report (R75C0987).
Specify a file name for the text file output of the Provision of Depreciation of Property Statement report (R75C0903).
Specify a file name for the text file output of the Statement of Changes in Stockholder's Equity report (R75C0906).
Specify a file name for the text file output of the Profit Appropriation Statement (R75C0907).
Specify the path for the text file.
Select GSSM Generator (G75CCNAO14), GSSM Generator.