(CHN) Setting Up for Exporting Financial Information In China

This chapter provides an overview of the standards introduced in China to ensure the correctness of accounting data and discusses how to:

Set up the XML output file structure of the CNAO reports.
Set up the natural account structure.
Generating the natural account information.
Set up the natural account information.
Assign report items to natural accounts or formulas.
Set up the organization details in the electronic accounting book.

Understanding the Standards to Ensure Correctness of Accounting Data

The China National Audit Office (CNAO) and Standardization Administration of China jointly issued the standard Information Technology – Data Interface of Accounting Software to enable better data interchange between the enterprises in China and the government, and to ensure completeness and correctness of accounting data.

As per the standard, you need to export the financial information such as fiscal period end, year-end reports, journals, and transactions, into an XML, TXT or PDF file and send it to CNAO for an audit. In order to do this, you need to first set up the JD Edwards EnterpriseOne system for China.

Setting Up the XML Output File Structure of the CNAO Reports

This section provides an overview of the output file structure required for the CNAO reports and discusses how to set up the structure of the XML output files of the CNAO reports.

Understanding the Output File Structure of the CNAO Reports

The CNAO requires the reports to be in a specific XML format. In order to make the report generation dynamic and to enable the you to create the XML report as and when required, the JD Edwards EnterpriseOne system enables you to enter the elements of the report in the Dynamic XML Output Generator program (P75CDXM). In this application, you enter the report name as the parent element and the field names as the child elements. You also specify the values that you wish to assign to the parent and child elements.

When you run the CNAO reports, the system uses the elements and values that you have defined and generates the output XML file. This application enables you to print the XML files in the format as required by the CNAO.

Forms Used to Set Up the File Structure of the CNAO Reports

Form Name	FormID	Navigation	Usage
Work With XML Structure Details	W75CDXMC	Setup (G75CCNAO1), Dynamic XML Output Generator	Review the XML structure details of the reports.
Add/Update Parent Element	W75CDXMD	Click Add on the Work With XML Structure Details form.	Enter the parent element details of the reports.
Add/ Update Child Element Records	W75CDXME	Enter the required details on the Add/Update Parent Element form and click OK.	Enter the child element details of the report.

Setting Up the Structure of the XML Output Files

Access the Work With XML Structure Details form.

Parent Element Name	The system retrieves the value from the UDC table 75C/DX and displays it. This name will be printed in your Dynamic XML reports.
XML Constant	Enter the XML constant as required by the report and assign a value to it.
Attribute Value	Enter the value for the XML constant. This value will be printed in your XML report.
Parent Element Identifier	Enter a value from UDC table 75C/DX to specify the identifier for the parent element. Values are: 1: Electronic Accounting Book 2: Chart of Accounts 3: Account Balance and Period Amount 4: Journal Entry 5: Balance Sheet 6: Income Statement 7: Cash Flow Statement 10: Dep of Property Statement 11: Statement of Changes in SE 12: Profit Appropriation Statement 8: Cash Flow Statement Small 9: Statement of VAT Payables
Child Element Name	Enter the name of the fields as the child element names. The child elements will be displayed in the XML report with their respective constants and attribute values.
Attribute Value	Enter the attribute value for the child element.

Setting Up the Natural Account Structure

This section provides an overview of the natural account structure and discusses how to set up the natural account structure.

Understanding the Natural Account Structure

You use the Natural Account Structure Setup program (P75C006) to store the mode and the natural account structure of the company. This program updates the Natural Account Set Up table (F75C006).

Forms Used to Set Up the Natural Account Structure

Form Name	FormID	Navigation	Usage
Work with Natural Account Structure	W75C006A	Setup (G75CCNAO1), Natural Account Structure Setup	Review the accounting structure and mode of a company.
Add/Update Natural Account Structure	W75C006B	Click Add on the Work with Natural Account Structure form. Select a record on the Work with Natural Account Structure form and click Select.	Enter the company accounting structure and natural accounting mode of the company.

Form Name

FormID

Navigation

Usage

Work with Natural Account Structure

W75C006A

Setup (G75CCNAO1), Natural Account Structure Setup

Review the accounting structure and mode of a company.

Add/Update Natural Account Structure

W75C006B

Click Add on the Work with Natural Account Structure form.

Select a record on the Work with Natural Account Structure form and click Select.

Enter the company accounting structure and natural accounting mode of the company.

Setting Up the Natural Account Structure

Access the Work with Natural Account Structure form.

Company

Enter the code that identifies your organization, fund, or other reporting entity.

Accounting Structure

Enter the accounting structure of your company.

Natural Account Mode

Enter the mode of your natural account.

In mode 1, the natural account is defined as the JD Edwards EnterpriseOne object + subsidiary. For example, if the object is 1110 and the subsidiary is 0101, the natural account number will be 11100101.

In mode 2, the accounts are separate from the JD Edwards EnterpriseOne accounts and are stored as natural account numbers.

Generating the Natural Account Information

This section provides an overview of how to generate the natural account information and discusses how to:

Set processing options for the E1 Account to Natural Account Setup program (R75C0903).
Generate the JD Edwards EnterpriseOne account numbers as natural account numbers.

Understanding the Generation of the Natural Account Information

The China chart of accounts is divided into two modes. In mode 1, you use the JD Edwards EnterpriseOne chart of accounts which consists of the object and the subsidiary. However, as you need the reports in the natural account number format in China, you use the E1 Account to Natural Account Setup report (R75C0903) to generate the chart of accounts information in the natural account number format.

In mode 2, the accounts are separate from the JD Edwards EnterpriseOne accounts and are stored as natural account numbers. Therefore, you do not need to generate the report separately here.

The system calculates the account level for both modes.

Setting Processing Options for E1 Account to Natural Account Setup (R75C0903)

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

Selection

Company

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

When you run the Natural Account Setup report, the account details for this company will be saved in the F075C091 and the F75C007 tables.

Generating the JD Edwards EnterpriseOne Account Numbers as Natural Account Numbers

Select Setup (G75CCNAO1), E1 Account to Natural Account Setup.

Setting Up the Natural Account Information

This section provides an overview of the China chart of accounts and discusses how to enter the natural account information.

Understanding the China Chart of Accounts

You use the China Chart of Accounts program (P75C007) to enter the natural account information.

You use the E1 Account to Natural Account Setup program (R75C0903) to generate the account numbers stored in the JD Edwards EnterpriseOne system as natural account numbers, if you are a mode 1 customer.

The natural account information is stored in the Account Master table (F0901), the Account master - Tag file - China Localization table (F75C091) and the China – Chart of Accounts Set Up table (F75C007).

If you are using the JD Edwards EnterpriseOne chart of accounts, the system generates the values in some of the fields of the China Chart of Accounts program such as the natural account number, level, and description. You will need to enter the values for the other fields.

If you are using the natural account numbers, you will need to enter the values for all the fields of the China Chart of Accounts program.

Forms Used to Set Up the Natural Account Information

Form Name	FormID	Navigation	Usage
Work With China - Chart of Accounts	W75C007A	Setup (G75CCNAO1), China Chart of Accounts Setup	Review the natural account details of a company.
Add/Update China Chart of Accounts	W75C007B	Click Add on the Work With China - Chart of Accounts form. Select a record on the Work With China - Chart of Accounts form and click Select.	Enter or update the natural account details.

Form Name

FormID

Navigation

Usage

Work With China - Chart of Accounts

W75C007A

Setup (G75CCNAO1), China Chart of Accounts Setup

Review the natural account details of a company.

Add/Update China Chart of Accounts

W75C007B

Click Add on the Work With China - Chart of Accounts form.

Select a record on the Work With China - Chart of Accounts form and click Select.

Enter or update the natural account details.

Entering the Natural Account Information

Access the Work With China - Chart of Accounts form.

Natural Account Number	Enter the natural account number. This is the standard account number used by the Chinese industry.
Natural Account Description	Enter the description of your natural account.
Operation - Credit or Debit	Enter a value from UDC table 75C/OP to specify if you are debiting or crediting the given item from the total. Values are: +: Debit −: Credit
Account Type	Enter the account type for China localization. Examples are: Asset Liability Cost Owner's equity Profit and loss
Account Level	The system calculates the account level. For example, if the account number is 11101111 and the accounting structure is 4,2,2,1, the account level is three.
Currency	Enter the code that identifies the currency of a natural account.

Assigning Report Items to Natural Accounts or Formulas

This section provides an overview of the report items assignment and discusses how to assign a report item to a natural account or a formula.

Understanding the Assignment of Report Items

You use the Report Item – Natural Account Mapping program (P75C003) to define the format of the reports and choose the items that need to be generated in the CNAO reports.

Each row in a report is a report item. In the Report Item – Natural Account Mapping program, you assign the report items to natural account numbers or formulas. A formula can be the sum or difference of the other rows. While generating the report, the items specified in the Report Item – Natural Account Mapping program along with the details of the assigned account, such as the report item, item description, amount, and so on is printed. This gives you the flexibility to customize your reports dynamically.

Forms Used to Assign Report Items to Natural Accounts

Form Name	FormID	Navigation	Usage
Work With Report Format Definition	W75C003B	Setup (G75CCNAO1), Report Format Definition	Review the report items.
Add Report Items	W75C003E	Click Add on the Work With Report Format Definition form. Select a record on the Work With Report Format Definition form and click Select.	Define each report item by entering the details.
Add/Update Natural Accounts	W75C003A	Select a record, and then select Natural Accounts from the Row menu on the Add Report Items form.	Enter the natural account number to be associated with the report item and also specify if it is to be debited or credited from the total amount.
Add/Update Formula	W75C003C	Select a record, and then select Formula from the Row menu on the Add Report Items form.	Enter the formula associated with the report item.

Assigning a Report Item to a Natural Account

Access the Work With Report Format Definition form.

Report ID	Enter the unique identification number for each report required for CNAO.
Item Description English	Enter a description for the report item in English.
Item Description Chinese	Enter a description for the report item in Chinese.
Sequence Number	Enter the sequence number for the line item used in the CNAO report.
Line Number	Enter a line number for the line item used in the CNAO report.
Item Orientation	Enter a value from UDC table 75C/ON to indicate on which side of the report the item is to be displayed. Values are: 1: Display item on the left side. 2: Display item on the right side.

Setting Up the Organization Details in the Electronic Accounting Book

This section provides an overview of the electronic accounting book and discusses how to:

Enter the organization setup details using the electronic accounting book.
Generate the organization setup details.
Set processing options for CNAO - Electronic Accounting Book (R75C002).

Understanding the Electronic Accounting Book

You use the Electronic Accounting Book program (P75C002) to enter the details of the organization. This program updates the Electronic Accounting Book table (F75C002), which stores the details of the organization setup. You use the CNAO - Electronic Accounting Book program (R75C002) to generate the details of the organization setup.

Forms Used to Enter the Organization Setup Details

Form Name	FormID	Navigation	Usage
Work with Electronic Accounting Book	W75C002A	Electronic Accounting Book (G75CCNAO2), Electronic Accounting Book	Review the details of your organization setup.
Add/Update Accounting Book	W75C002B	Click Add on the Work with Electronic Accounting Book form. Select a record on the Work with Electronic Accounting Book form and click Select.	Enter the details of the organization setup.

Form Name

FormID

Navigation

Usage

Work with Electronic Accounting Book

W75C002A

Electronic Accounting Book (G75CCNAO2), Electronic Accounting Book

Review the details of your organization setup.

Add/Update Accounting Book

W75C002B

Click Add on the Work with Electronic Accounting Book form.

Select a record on the Work with Electronic Accounting Book form and click Select.

Enter the details of the organization setup.

Entering the Organization Setup Details Using the Electronic Accounting Book

Access the Work with Electronic Accounting Book form.

Electronic Book Name	Enter a name for your electronic book.
Electronic Book Number	The system assigns a number to your electronic book in a sequential order using the next numbers. Note. Set up the next number in the second location of the next number table for system code 75C.
Company Name	Enter the code that identifies your organization, fund, or other reporting entity.
Functional Currency	Enter the functional currency of your electronic accounting book.
Accounting Structure	Enter the natural accounting structure of your company.
Organization ID	Enter the number assigned to your organization or enterprise.
Enterprise Industry	Enter the type of industry for the enterprise.
Enterprise Quality	Enter the type of the enterprise.
ERP Software Company	Enter the ERP Software Development Company. For example, Oracle Software Research and Development Center.
Fiscal Year	Specify the number that identifies the fiscal year.

Generating the Organization Setup Details

Select Electronic Accounting Book (G75CCNAO2), Electronic Accounting Book.

Setting the Processing Options for CNAO - Electronic Accounting Book (R75C002)

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

Default

1. Path for the Text File If Blank - Text File not Generated	Specify the path where the text file is to be generated and saved.
2. Path for the XML File If Blank - XML File not Generated	Specify the path where the XML file is to be generated and saved.