13 Setting Up and Generating AP and AR Information for CNAO Audit Files
This chapter contains the following topics:
-
Section 13.1, "Understanding the AP and AR Information Required for CNAO Audit Files"
-
Section 13.2, "Generating Balances for AP and AR Transactions"
-
Section 13.3, "Generating the CNAO Audit Files for AP and AR"
13.1 Understanding the AP and AR Information Required for CNAO Audit Files
You must report the details of your accounts payable (AP) and accounts receivable (AR) information according to the requirements for CNAO version 2. According to the CNAO standard, you need to export all related financial information such as fiscal period end, year-end reports, journals and details of fixed assets, and payroll transactions into XML files for sending to CNAO for audit review. To address the new requirement, you need to generate the Generate AP & AR XML - China - 75C report (R75C010).
The Generate AP & AR XML - China - 75C report generates the XML output for the required AP & AR data elements in the format required by the Chinese government.
The mandatory reporting requirements for AR and AP module include these areas:
-
Document type.
You report the document type once.
-
Transaction type.
You report the transaction type once.
-
Receivable Balance Details in the Current Period.
You report the receivable balance details in the current period on a monthly basis.
-
Payable Balance Details in the Current Period.
You report the payable balance details in the current period on a monthly basis.
13.1.1 Process Flow for Setting Up and Generating the CNAO Audit File for AP and AR Details
This process flow shows the set up that you need to complete and the relationships between the setup programs to generate the AP and AR XML:
Figure 13-1 Process Flow of Setup for AR and AP XML Files
Description of ''Figure 13-1 Process Flow of Setup for AR and AP XML Files''
13.1.2 Checklist for Setting Up and Generating the CNAO Audit File for AP and AR Information
Use this table to assure that you complete all necessary steps to successfully generate the CNAO audit file for AP/AR information:
| 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. | |
| Verify that the CNAO document numbers have been generated. | You use the Generate CNAO Document Numbers program (R75C911) to generate CNAO document numbers for all JD Edwards EnterpriseOne document numbers. | |
| Verify that the XML element names are set up for the AP/AR file. | You use the Dynamic XML Element Names program (P75C013) to set up names for the sections headings and the section fields of the AP/AR XML file.
For example, instead of having the system print the term Document Type 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. |
|
| Generate balances for a customer or supplier and natural account number. | You run the Generate Balances for AP/AR - China report (R75C014). | |
| Generate the AP & AR CNAO XML file. | You run the AP & AR XML - China - 75C program to generate the XML file. |
13.2 Generating Balances for AP and AR Transactions
This section provides an overview of the balance update for AP and AR and discusses how to:
-
Run the Generate Balances for AP/AR - China program.
-
Set processing options for the Generate Balances for AP/AR - China program (R75C014).
13.2.1 Understanding the Balance Update for AP and AR
Run the Generate Balances for AP/AR - China program (R75C014) to generate balances for each unique combination of a customer or supplier and a natural account number. The system calculates balances for the fiscal year that you specify in the processing options. The system stores the balances for the specified fiscal year based on natural account number and customer or supplier in the AP/AR Balances - China table (F75C014).
If you run the report for the same processing option more than once, the system deletes the previous records from the F75C014 table. It then recalculates balances and inserts those in the F75C014 table.
You can run this report in proof or final mode. The system updates the F75C014 table only when you run the report in the final mode.
13.2.2 Running the Generate Balances for AP/AR - China Program
Select AP & AR Information (G75C055), Generate Balances for AP/AR - China.
13.3 Generating the CNAO Audit Files for AP and AR
This section provides an overview of the CNAO audit file for AP and AR and discusses how to:
-
Run the Generate AP & AR XML - China - 75C program.
-
Set processing options for AP & AR XML - China - 75C (R75C010).
-
Run the Generate Multiple Period AP & AR XML - China program.
-
Set processing options for Generate Multiple Period AP & AR XML - China (R75C011).
13.3.1 Understanding the CNAO Audit File for AP and AR
You run the Generate AP & AR XML - China - 75C program to generate the XML file to report AP and AR information. You set processing options to specify data selection, such as the accounting period and company. You also use the processing options to specify the location to which the program writes the XML output and the Chinese characters that the system prints in the title of the report.
The Generate AP & AR XML - China - 75C report generates the XML output for the required AP and AR data elements in the format required by the Chinese government. This report generates output for a specified accounting period.
You need to run the Generate Multiple Period AP & AR XML - China report to generate XML output for multiple periods or between a range of periods. However, you must have run the Generate AP & AR XML - China - 75C report for the period for which you are running the Generate Multiple Period AP & AR XML - China report.
You can also use the Generate Multiple Period AP & AR XML - China report to run the XML for a given period more than one time.
The system reads these tables to obtain the data for the XML file:
-
User Defined Code Types (F0004)
-
User Defined Code Values (F0005)
-
Accounts Payable Ledger (F0411)
-
Accounts Payable Matching Document Type (F0414)
-
Customer Ledger (F03B11)
-
Receipts Detail (F03B14)
|
Note: When you run the Generate AP & AR XML - China - 75C report, the system saves data to the AP & AR Multiple Period XML Workfile table (F75CUI05) and retrieves it from this table when you run the Generate Multiple Period AP & AR XML - China report. |
13.3.2 Running the Generate AP & AR XML - China - 75C Program
Select AP & AR Information (G75C055), Generate AP & AR XML - China - 75C.
13.3.3 Setting Processing Options for Generate AP & AR XML - China - 75C (R75C010)
Processing options enable you to specify default values for programs and reports.
13.3.3.1 Default
- Company
-
Specify the company for which you generate the report. You must complete this processing option.
- Reporting Century/Fiscal Year (XXXX)
-
Specify the accounting year of the report. You must enter a value in the format YYYY. The system uses this value to select the AP and AR records that have the specified accounting year. You must complete this processing option.
- Reporting Period Number (XX)
-
Specify the accounting month of the report. You must enter a value in the format XX where XX is the number of the month. The system uses this value to select the AP and AR records that have the specified accounting month. You must complete this processing option.
13.3.3.2 XML File Name
- XML File Path
-
Specify the location to which the system writes the XML file. You must have write permissions for the location that you specify. You must complete this processing option.
- Report Name in Chinese
-
Specify the Chinese name of the module for dynamic creation of the XML file name. The system suffixes this value with the accounting year, starting month, and ending month in this manner Filename + (Accounting Year + Starting month + Ending Month). For example, for the year 2010, starting and ending month as January, the report name will be Chinese Filename20100101.
13.3.4 Running the Generate Multiple Period AP & AR XML - China Program
Select AP & AR Information (G75C055), Generate Multiple Period AP & AR XML - China.
13.3.5 Setting Processing Options for Generate Multiple Period AP & AR XML - China (R75C011)
Processing options enable you to specify default values for programs and reports.
13.3.5.1 Default
- Company
-
Specify the company for which you generate the report. You must complete this processing option.
- Reporting Century/Fiscal Year (XXXX)
-
Specify the accounting year of the report. You must enter a value in the format YYYY. The system uses this value to select the AP and AR records that have the specified accounting year. You must complete this processing option.
- Reporting Period Number (XX)
-
Specify the accounting month of the report. You must enter a value in the format XX where XX is the number of the month. The system uses this value to select the AP and AR records that have the specified accounting month. You must complete this processing option.
13.3.5.2 XML File Name
- XML File Path
-
Specify the location to which the system writes the XML file. You must have write permissions for the location that you specify. You must complete this processing option.
- Report Name in Chinese
-
Specify the Chinese name of the module for dynamic creation of the XML file name. The system suffixes this value with the accounting year, starting month, and ending month in this manner Filename + (Accounting Year + Starting month + Ending Month). For example, for the year 2010, starting and ending month as January, the report name will be Chinese Filename20100101.