## (CHN) Generating Financial Reports Dynamically

This chapter provides an overview of the dynamic generation of the reports and discusses how to:

- Generate the details of the cash flow statement items.

- Generate the statement of value-added tax (VAT) payables information.

- Generate the depreciation of property statement items.

- Generate the details of the statement of changes in stockholder's equity.

- Generate the profit appropriation statement.

- Generate the names of the CNAO (China National Audit Office) flat files.

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

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

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

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

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

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.

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.

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

#### Generating the Cash Flow Statement Items Details

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

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

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

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

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

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

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.

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

#### Generating the Statement of VAT Payables Information

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

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

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

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

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

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

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.

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

#### Printing the Depreciation of Property Statement Items

Select Provision of depreciation of property statement (G75CCNA011), CNAO-Provision of depreciation of property statement.

### Generating the Details of the Statement of Changes in Stockholder's Equity

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.

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

#### Setting Processing Options for the Statement of Changes in Stockholder's Equity (R75C0906)

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

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

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.

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

#### Generating the Details of the Statement of Changes in Stockholder's Equity

Select Statement of changes in stockholders' equity (G75CCNAO12), CNAO-Statement of changes in stockholders' equity.

### Generating the Profit Appropriation Statement

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.

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

#### Setting Processing Options for Profit Appropriation Statement (R75C0907)

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

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

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.

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

#### Generating the Profit Appropriation Statement

Select Profit appropriation statement (G75CCNAO13), CNAO-Profit appropriation statement.

### Generating the Names of the CNAO Flat Files

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.

#### Understanding 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.

#### Setting Processing Options for GSSM Generator (R75C0999)

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

Filenames

Enter the filenames of the following flat files:

Electronic Accounting Book Export | Specify a file name for the text file output of the Electronic Accounting Book report (R75C002).
Chart of Account Export I - Natural Account | Specify a file name for the text file output of the E1 Account to Natural Account Setup report (R75C0903).
Account Balance and Period Amount Export | Specify a file name for the text file output of the Account Balance and Period Amount report (R75C0902).
Journal Entry Export Program | Specify a file name for the text file output of the Account Balance and Period Amount report (R75C0902).
Balance Sheet Export | Specify a file name for the text file output of the China Balance Sheet CNAO report (R75C111B).
Income Statement Export | Specify a file name for the text file output of the Income Statement report (R75C0904).
Cash Flow Statement | Specify a file name for the text file output of the China Cash Flow Statement Output – CNAO report (R75C0910).
Statement of Value Added Tax Payables | Specify a file name for the text file output of the Statement of VAT Payables report (R75C0987).
Provision for Depreciation of Property Statement | Specify a file name for the text file output of the Provision of Depreciation of Property Statement report (R75C0903).
Statement of Changes in Stockholder's Equity | Specify a file name for the text file output of the Statement of Changes in Stockholder's Equity report (R75C0906).
Profit Appropriation Statement | Specify a file name for the text file output of the Profit Appropriation Statement (R75C0907).

Path

Path for text file (Path should include filename. Eg. C:\GSSM.txt) | Specify the path for the text file.

#### Generating the CNAO Flat File Names

Select GSSM Generator (G75CCNAO14), GSSM Generator.