Checklist for Setting Up and Generating the CNAO Audit File for GL

Use this table to assure that you complete all necessary steps to successfully generate the CNAO audit file for GL:

Complete

Action

Comments

Verify that alternate descriptions of currency code translations are set up.

You set up the alternate descriptions in the Translation (75C/TR) UDC table.

Enter general ledger information.

You use the GL Basic Information - China program (P75C009) to set up the basic GL information such as company, COA rule, journal header field, and so on.

See Setting Up Information for GL

Verify that the needed subsidiary items exist.

You use the Work With Subsidiary Information program (P75C010) to verify the existing subsidiary items.

See Setting Up Subsidiary Information for the Shared Info XML File

Associate subsidiary items to an account.

You use the Account - Subsidiary Cross Reference - China program (P75C011) to associate subsidiary items to an account.

See Associating Subsidiary Items to an Account

Process GL information for cash flow.

You use the Select GL transactions for Cash Flow - China program (P75C015) to select GL transactions for cash flow.

See Working With GL Information for Cash Flow

Generate subsidiary information for accounts transactions.

You run reports to generate subsidiary information for different transactions:

  • Generate Subsidiary Info for AP - China program (R75C091) for AP information.

  • Generate Subsidiary Info for AR - China program (R75C092) for AR information.

  • Generate Subsidiary Info for Purchase Order- China program (R75C093) for purchase order information.

  • Generate Subsidiary Info for Sales Order - China program (R75C094) for sales order information.

  • Generate Subsidiary Info for GL - China program (R75C095) for general ledger information.

You can also run all these reports sequentially by running the Subsidiary Info Reports - China (R75C090) report.

See Generating Subsidiary Information for Accounts Transactions

Generate report item data.

You run these reports to generate report item data for transactions:

  • China Income Statement CNAO v2 program (R75C904).

  • Statement of Changes in Stockholder's equity CNAO v2 program (R75C906).

  • China Cash Flow Statement CNAO v2 program (R75C910).

  • China Balance Sheet CNAO v2 program (R75C912).

See Generating Report Item Data for Financial Information

Generate the CNAO document numbers.

You use the Generate CNAO Document Numbers program (R75C911) to generate CNAO document numbers for all JD Edwards EnterpriseOne document numbers.

See Generating CNAO Document Numbers

Update subsidiary balances file.

You use the Update Subsidiary Balances File - China program (R75C902) to update the balances in the F75C902 table.

See Updating Subsidiary Balances File

Revise beginning balance for subsidiary items.

You use the Subsidiary Balances Revision - China program (P75C902) to revise the beginning balance for the subsidiary items attached to an account.

See Updating Subsidiary Balances File

Verify that the XML element names are set up for the GL file.

You use the Dynamic XML Element Names program (P75C013) to set up names for the sections headings and the section fields of the GL XML file.

For example, instead of having the system print the term Chart of Account for the heading of that section, you can enter a different string, including Chinese characters, that the system will print in the XML output file.

See Setting Up Dynamic File Names

Generate the GL CNAO XML file.

You run the Generate GL XML - China program (R75C009) to generate the XML file.

See Generating the CNAO Audit Files for GL