This chapter contains the following topics:
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).
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.
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. |
Access the Map to Natural Account form.
The system displays the account ID of your JD Edwards EnterpriseOne system account.
Enter the corresponding natural account number.
Select Chart of Accounts (G75CCNAO3), CNAO - China Chart of Accounts.
Processing options enable you to specify the default processing for programs and reports.
Specify the path where the text file is to be generated and saved.
Specify the path where the XML file is to be generated and saved.
Specify the code that identifies your organization, fund, or other reporting entity.
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.
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).
Processing options enable you to specify the default processing for programs and reports.
Specify the path where the text file is to be generated and saved.
Specify the path where the XML file is to be generated and saved.
Specify the code that identifies a specific organization, fund, or other reporting entity.
Specify the type of ledger used for domestic transactions.
Blank: AA
Specify the type of ledger used for foreign transactions.
Blank: CA
Specify a number (from 1 to 14) that identifies the current accounting period.
Specify the number that identifies the fiscal year of the company.
Select Account Balance and Period Amount (G75CCNAO4), CNAO - Account Balance and Period Amount.
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.
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. |
Processing options enable you to specify the default processing for programs and reports.
Specify the path where the text file is to be generated and saved.
Specify the path where the XML file is to be generated and saved.
Specify the name of your journal preparer.
Specify the name of your bookkeeper.
Specify the name of your cashier.
Specify the type of ledger to use for domestic transactions.
Blank: AA
Specify the type of ledger to use for foreign transactions.
Blank: CA
Specify the code that identifies a specific organization, fund, or other reporting entity.
Specify the last two digits of the company fiscal year. For example, if the fiscal year is 2007, specify 07.
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).
Specify a number (from 1 to 14) that identifies the current accounting period.
Select Journal Entry (G75CCNAO5), CNAO - China Journal Entry.
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.
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.
Processing options enable you to specify the default processing for programs and reports.
Specify the code that identifies your organization, fund, or other reporting entity.
Specify the number that identifies the company fiscal year.
Specify a number (from 1 to 14) that identifies the current accounting period.
Specify the type of ledger to use for domestic transactions.
Blank: AA
Specify the type of ledger to use for foreign transactions.
Blank: CA
Specify the language for the report.
Specify the address book number of the issuing organization.
Specify the reporting date for your inference.
Specify the unique statement number issued to you by the government.
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.
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.
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. |
Select Balance Sheet (G75CCNAO6), CNAO - Balance Sheet Output.
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.
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.
Processing options enable you to specify the default processing for programs and reports.
Specify the code that identifies your organization, fund, or other reporting entity.
Specify the number that identifies the fiscal year.
Specify a number (from 1 to 14) that identifies the current accounting period.
Specify the type of ledger to use for domestic transactions.
Blank: AA
Specify the type of ledger to use for foreign transactions.
Blank: CA
Specify the language for the report.
Specify the address book number of the issuing organization.
Specify the reporting date for your inference.
Specify the unique statement number issued to you by the government.
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.
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.
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. |
Select Income Statement (G75CCNAO8), CNAO - Income Statement Output.