(CHN) Exporting Financial Information into Flat Files

This chapter discusses how to:

Generate the chart of accounts information.
Generate the account balance and period amount.
Generate the journal entry information.
Generate the balance sheet information.
Generate the income statement information.

Generating the Chart of Accounts Information

This section provides an overview of the formats of the output files to send to the China National Audit Office (CNAO) for audit review, and discusses how to:

Enter a natural account for each of the JD Edwards EnterpriseOne system accounts.
Generate the chart of accounts.
Set processing options for the China Chart of Accounts program (R75C0901).

Understanding the Output File Formats to Send to CNAO

You export the financial information such as fiscal period end, year-end reports, journals, and transactions into either XML or flat files and send to the CNAO for review. The flat files should be in simplified Chinese.

The JD Edwards EnterpriseOne system generates the chart of accounts data into a flat file that has a predefined format. The flat file includes the information of the JD Edwards EnterpriseOne accounts and the general ledger.

Use the China Chart of Accounts program (P75C0901) to enter the natural account information if your accounts are separate from the JD Edwards EnterpriseOne accounts and are stored as natural account numbers.

The China Chart of Accounts program (R75C0901) generates the chart of accounts in the TXT and XML formats.

Forms Used to Enter a Natural Account for Each JD Edwards EnterpriseOne System Accounts

Form Name	FormID	Navigation	Usage
Map to Natural Accounts	W75C0901B	Configured Hub Intercompany Setup (G0941125), Review and Revise Accounts Select a record on the Work with Accounts form and click Select. Select a record and select Regional Info from the Row menu.	Enter the natural account numbers for each account of the JD Edwards EnterpriseOne system.

Form Name

FormID

Navigation

Usage

Map to Natural Accounts

W75C0901B

Configured Hub Intercompany Setup (G0941125), Review and Revise Accounts

Select a record on the Work with Accounts form and click Select.

Select a record and select Regional Info from the Row menu.

Enter the natural account numbers for each account of the JD Edwards EnterpriseOne system.

Entering a Natural Account for Each of the JD Edwards EnterpriseOne System Accounts

Access the Map to Natural Account form.

Account ID	The system displays the account ID of your JD Edwards EnterpriseOne system account.
Natural Account Number	Enter the corresponding natural account number.

Generating the Chart of Accounts

Select Chart of Accounts (G75CCNAO3), CNAO - China Chart of Accounts.

Setting Processing Options for China Chart of Accounts (R75C0901)

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

Details

Path for text file (If blank - Text file not generated.)	Specify the path where the text file is to be generated and saved.
Path for XML file (If blank - XML file not generated.)	Specify the path where the XML file is to be generated and saved.
Company	Specify the code that identifies your organization, fund, or other reporting entity.

Generating the Account Balance and Period Amount

This section provides an overview of the account balance and period amount and discusses how to:

Set processing options for Account Balance and Period Amount (R75C0902).
Generate the account balance and period amount.

Understanding the Account Balance and Period Amount

Use the Account Balance and Period Amount program (R75C0902) to generate the journal entry information of each natural account of the JD Edwards EnterpriseOne general ledger to the flat files. This report is run on a monthly or period basis.

The report uses data from the Account Balances table (F0902), the China Chart of Accounts Set Up table (F75C007), and the Account master - Tag file - China Localization table (F75C091).

Setting Processing Options for Account Balance and Period Amount (R75C0902)

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

Display

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 - Text File not Generated	Specify the path where the XML file is to be generated and saved.

Selection

1. Company	Specify the code that identifies a specific organization, fund, or other reporting entity.
2. Ledger Type for Domestic Transactions	Specify the type of ledger used for domestic transactions. Blank: AA
3. Ledger Type for Foreign Transactions	Specify the type of ledger used for foreign transactions. Blank: CA
4. Period	Specify a number (from 1 to 14) that identifies the current accounting period .
5. Fiscal Year	Specify the number that identifies the fiscal year of the company.

Generating the Account Balance and Period Amount

Select Account Balance and Period Amount (G75CCNAO4), CNAO - Account Balance and Period Amount.

Generating the Journal Entry Information

This section provides an overview of how to export the journal entry information to flat files and discusses how to:

Set processing options for the Journal Entry Information program (R75C0911).
Generate the journal entry information in a flat file.

Understanding the Export of Journal Entry Information to Flat Files

Use the Journal Entry Information program (R75C0911) to export the journal entry information into the flat files. The flat file is generated in the TXT and XML formats.

Note. Set up the next number in the third location of the next number table for system code 75C.

Setting Processing Options for Journal Entry Information (R75C0911)

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

Default

Path for text file (If blank - Text file not generated.)	Specify the path where the text file is to be generated and saved.
Path for XML file (If blank - XML file not generated.)	Specify the path where the XML file is to be generated and saved.
Journal Preparer	Specify the name of your journal preparer.
Book Keeper	Specify the name of your bookkeeper.
Cashier	Specify the name of your cashier.
Ledger Type for domestic transactions	Specify the type of ledger to use for domestic transactions. Blank: AA
Ledger Type for foreign transactions	Specify the type of ledger to use for foreign transactions. Blank: CA

Selection

Company	Specify the code that identifies a specific organization, fund, or other reporting entity.
Fiscal Year	Specify the last two digits of the company fiscal year. For example, if the fiscal year is 2007, specify 07.
Century	Specify the calendar century associated with the year. Enter the first two digits of the year. For example, 20 indicates any year beginning with 20 (2007, 2008).
Period Number	Specify a number (from 1 to 14) that identifies the current accounting period .

Generating the Journal Entry Information in a Flat File

Select Journal Entry (G75CCNAO5), CNAO - China Journal Entry.

Generating the Balance Sheet Information

This section provides an overview of output formats for the balance sheet data and discusses how to:

Set processing options for the China Balance Sheet CNAO program (R75C111B).
Generate the balance sheet details in the required format.

Understanding the Output Formats for the Balance Sheet Information

The JD Edwards EnterpriseOne system generates the data that includes the balance sheet items and the corresponding amount for these items from the JD Edwards EnterpriseOne general ledger, into TXT, XML, and PDF files.

Use the China Balance Sheet CNAO program (R75C111B) to generate the TXT, XML, and PDF outputs for the balance sheet of a particular company, period, ledger type, and financial year.

Setting the Processing Options for China Balance Sheet CNAO (R75C111B)

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

Selection

1. Company	Specify the code that identifies your organization, fund, or other reporting entity.
2. Fiscal Year	Specify the number that identifies the company fiscal year.
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 to use for domestic transactions. Blank: AA
5. Foriegn Ledger Type BLANK = CA	Specify the type of ledger to use for foreign transactions. Blank: CA
6. Language Required 1 - English 2 - Chinese 3 - Both	Specify the language for the report.

Display

1. Issued Organisation	Specify the address book number of the issuing organization.
2. Reporting Date	Specify the reporting date for your inference.
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 for the output XML to be saved. In case you do not specify the path, the system will not save the XML file.
5. Path for TXT Output BLANK = TXT Output not required.	Specify the path for the text file to be saved. In case you do not specify the path, the system will 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 1, 45,000.00, a monetary unit of 1 displays the amount as $ 1, 45,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.

Generating the Balance Sheet Details in the Required Format

Select Balance Sheet (G75CCNAO6), CNAO - Balance Sheet Output.

Generating the Income Statement Information

This section provides an overview of the income statement format and discusses how to:

Set processing options for the Income Statement program (R75C0904).
Generate the income statement information.

Understanding the Income Statement Format

You use the Income Statement program (R75C0904) to generate the income statement information in the format as prescribed by the CNAO. It generates the data from the JD Edwards EnterpriseOne system into TXT XML, and PDF files whose format is predefined. The report includes the items and amounts calculated based on the balance of each account of the JD Edwards EnterpriseOne general ledger. The report is also generated in the PDF format.

Setting Processing Options for Income Statement (R75C0904)

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

Selection

1. Company	Specify the code that identifies your organization, fund, or other reporting entity.
2. Fiscal Year	Specify the number that identifies the fiscal year.
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 to use for domestic transactions. Blank: AA
5. Foreign Ledger Type BLANK = CA	Specify the type of ledger to use for foreign transactions. Blank: CA
6. Language Required 1 - English 2 - Chinese 3 - Both	Specify the language for the report.

Display

1. Issued Organisation	Specify the address book number of the issuing organization.
2. Reporting Date	Specify the reporting date for your inference.
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 for the output XML to be saved. In case you do not specify the path, the system will not save the XML file.
5. Path for TXT Output BLANK = TXT Output not required.	Specify the path for the text file to be saved. In case you do not specify the path, the system will 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 1, 45,000.00, a monetary unit of 1 displays the amount as $ 1, 45,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.

Generating the Income Statement

Select Income Statement (G75CCNAO8), CNAO - Income Statement Output.