Generating Financial Reports Dynamically for China

8.1 Understanding the Dynamic Generation of Reports

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:

Beginning amount: Enter the beginning amount of the year for a specific natural account or a combination of natural accounts.
Period amount: Enter the net amount of the period for a specific natural account.
Year positive: 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).
Year negative: 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).
Year to this period (including beginning balance): Enter the closing balance of the particular period including the beginning balance of the same period.
Year to this period (excluding beginning balance): Enter the closing balance of the particular period excluding the beginning balance of the period.
Period positive: 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).
Period negative: 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).
Amount with reverse sign: 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.

8.2 Generating the Details of the Cash Flow Statement Items

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.

8.2.1 Understanding the Cash Flow Statement Items for Large and Small Enterprises

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.

8.2.2 Setting Processing Options for China Cash Flow Statement Output – CNAO (R75C0910)

Processing options enable you to specify the default processing for programs and reports.

8.2.2.1 Selection

1. Company

Specify the code that identifies a specific organization, fund, or other reporting entity.

2. Fiscal Year

Specify the number that identifies the fiscal year of the company.

3. Period Number

Specify a number (from 1 to 14) that identifies the current accounting period.

4. Domestic Ledger Types BLANK = AA

Specify the type of ledger used for domestic transactions.

If you leave this processing option blank, the system uses ledger AA.

5. Foreign Ledger Type BLANK = CA

Specify the type of ledger used for foreign transactions.

Blank: CA

6. Language Required

Specify the language for the report. Values are:

1: English

2: Chinese

3: Both

7. Type Of Enterprise

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.

8.2.2.2 Display

1. Issued Organisation

Specify the address book number of the issuing organization.

2. Statement Number

Specify the unique statement number issued to you by the government.

3. Path for XML Output

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.

4. Path for TXT Output

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.

5. Monetary Unit

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.

6. Sequence Number for "Effect of Foreign Exchange Rate Changes on Cash" Item

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.

7. Current Year Amount for "Effect of Foreign Exchange Rate Changes on Cash" Item

Specify the net amount result that corresponds to the changes in the foreign exchange rate in the current year.

8. Last Year Amount for "Effect of Foreign Exchange Rate Changes on Cash" item.

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.

8.2.2.3 Sequence Number List

List of Sequence Number displaying "Beginning Amount"

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.

List of Sequence Number displaying "Period Amount"

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.

List of Sequence Number displaying "Year to this period" (Including Beginning Balance)

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.

List of Sequence Number displaying "Year to this period" (Non including Beginning Balance)

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.

List of Sequence Number displaying "Period Positive"

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

List of Sequence Number displaying "Period Negative"

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

List of Sequence Number displaying "amount with reverse sign"

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.

List of Sequence Number displaying "Year Positive"

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

List of Sequence Number displaying "Year Negative"

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

8.2.3 Generating the Cash Flow Statement Items Details

Select CNAO-Cash flow statement (G75CCNAO9), Cash flow statement.

8.3 Generating the Statement of VAT Payables Information

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.

8.3.1 Understanding the Statement of VAT Payables

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

8.3.2 Setting Processing Options for Statement of VAT Payables (R75C0987)

Processing options enable you to specify the default processing for programs and reports.

8.3.2.1 Selection

1. Company

Specify the code that identifies a specific organization, fund, or other reporting entity.

2. Fiscal Year

Specify the number that identifies the fiscal year of the company.

3. Period Number

Specify a number (from 1 to 14) that identifies the current accounting period.

4. Domestic Ledger Types BLANK = AA

Specify the type of ledger used for domestic transactions.

If you leave this processing option blank, the system uses ledger type AA.

5. Foreign Ledger Type BLANK = CA

Specify the type of ledger used for foreign transactions.

If you leave this processing option blank, the system uses ledger type CA.

6. Language Required

Specify the language for the report. Values are:

1: English

2: Chinese

3: Both

8.3.2.2 Display

1. Issued Organisation

Specify the address book number of the issuing organization.

2. Reporting Date

Specify the reporting date for which you run the program.

3. Statement Number

Specify the unique statement number issued to you by the government.

4. Path for XML Output BLANK = XML Output not required.

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.

5. Path for TXT Output BLANK = TXT Output not required.

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.

6. Monetary Unit

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.

8.3.2.3 Sequence Number List

List of Sequence Number displaying "Beginning Amount"

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.

List of Sequence Number displaying "Period Amount"

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.

List of Sequence Number displaying "Year to this period" (Including Beginning Balance)

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.

List of Sequence Number displaying "Year to this period" (Non including Beginning Balance)

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.

List of Sequence Number displaying "Period Positive"

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

List of Sequence Number displaying "Period Negative"

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

List of Sequence Number displaying "amount with reverse sign"

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.

List of Sequence Number displaying "Year Positive"

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

List of Sequence Number displaying "Year Negative"

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

8.3.3 Generating the Statement of VAT Payables Information

Select Statement of value added tax payables (G75CCNAO10), CNAO-Statement of value added tax payables.

8.4 Generating the Depreciation of Property Statement Items

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.

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

8.4.2 Setting Processing Options for Provision of Depreciation of Property Statement (R75C0905)

Processing options enable you to specify the default processing for programs and reports.

8.4.2.1 Selection

1. Company

Specify the code that identifies a specific organization, fund, or other reporting entity.

2. Fiscal Year

Specify the number that identifies the fiscal year of the company.

3. Domestic Ledger Types BLANK = AA

Specify the type of ledger used for domestic transactions.

If you leave this processing option blank, the system uses ledger type AA.

4. Foreign Ledger Type BLANK = CA

Specify the type of ledger used for foreign transactions.

If you leave this processing option blank, the system uses ledger type CA.

5. Language Required

Specify the language for the report. Values are:

1: English

2: Chinese

3: Both

8.4.2.2 Display

1. Issued Organisation

Specify the address book number of the issuing organization.

2. Statement Number

Specify the unique statement number issued to you by the government.

3. Path for XML Output BLANK = XML Output not required.

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.

4. Path for TXT Output BLANK = TXT Output not required.

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.

5. Monetary Unit

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.

6. Reporting Date

Specify the reporting date for which you run the program.

8.4.2.3 Sequence Number List