7 Exporting Financial Information into Flat Files for China
This chapter contains the following topics:
7.1 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).
7.1.1 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.
7.1.2 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 (G094115), 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. |
7.1.3 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.
7.1.4 Generating the Chart of Accounts
Select Chart of Accounts (G75CCNAO3), CNAO - China Chart of Accounts.
7.1.5 Setting Processing Options for China Chart of Accounts (R75C0901)
Processing options enable you to specify the default processing for programs and reports.
7.1.5.1 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.
7.2 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.
7.2.1 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).
7.2.2 Setting Processing Options for Account Balance and Period Amount (R75C0902)
Processing options enable you to specify the default processing for programs and reports.
7.2.2.1 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.
7.2.2.2 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.
7.2.3 Generating the Account Balance and Period Amount
Select Account Balance and Period Amount (G75CCNAO4), CNAO - Account Balance and Period Amount.
7.3 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.
7.3.1 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. |
7.3.2 Setting Processing Options for Journal Entry Information (R75C0911)
Processing options enable you to specify the default processing for programs and reports.
7.3.2.1 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
7.3.2.2 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.
7.3.3 Generating the Journal Entry Information in a Flat File
Select Journal Entry (G75CCNAO5), CNAO - China Journal Entry.
7.4 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.
7.4.1 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.
7.4.2 Setting the Processing Options for China Balance Sheet CNAO (R75C111B)
Processing options enable you to specify the default processing for programs and reports.
7.4.2.1 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.
7.4.2.2 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.
7.4.3 Generating the Balance Sheet Details in the Required Format
Select Balance Sheet (G75CCNAO6), CNAO - Balance Sheet Output.
7.5 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.
7.5.1 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.
7.5.2 Setting Processing Options for Income Statement (R75C0904)
Processing options enable you to specify the default processing for programs and reports.
7.5.2.1 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.
7.5.2.2 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.
7.5.3 Generating the Income Statement
Select Income Statement (G75CCNAO8), CNAO - Income Statement Output.