(CHN) Generating Financial Reports Dynamically

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

Click to jump to parent topicUnderstanding 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.

Click to jump to parent topicGenerating 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:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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.

Click to jump to top of pageClick to jump to parent topicSetting 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).

Click to jump to top of pageClick to jump to parent topicGenerating the Cash Flow Statement Items Details

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

Click to jump to parent topicGenerating the Statement of VAT Payables Information

This section provides an overview of the statement of VAT payables and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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).

Click to jump to top of pageClick to jump to parent topicSetting 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).

Click to jump to top of pageClick to jump to parent topicGenerating the Statement of VAT Payables Information

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

Click to jump to parent topicGenerating the Depreciation of Property Statement Items

This section provides an overview of the depreciation of property statement items and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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).

Click to jump to top of pageClick to jump to parent topicSetting 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).

Click to jump to top of pageClick to jump to parent topicPrinting the Depreciation of Property Statement Items

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

Click to jump to parent topicGenerating 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:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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).

Click to jump to top of pageClick to jump to parent topicSetting 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).

Click to jump to top of pageClick to jump to parent topicGenerating 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.

Click to jump to parent topicGenerating the Profit Appropriation Statement

This section provides an overview of the profit appropriation statement and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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).

Click to jump to top of pageClick to jump to parent topicSetting 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).

Click to jump to top of pageClick to jump to parent topicGenerating the Profit Appropriation Statement

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

Click to jump to parent topicGenerating the Names of the CNAO Flat Files

This section provides an overview of the CNAO flat file names and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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.

Click to jump to top of pageClick to jump to parent topicSetting 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.

Click to jump to top of pageClick to jump to parent topicGenerating the CNAO Flat File Names

Select GSSM Generator (G75CCNAO14), GSSM Generator.