This chapter contains the following topics:
Section 15.1, "Understanding the Fixed Assets Information Required for CNAO Audit Files"
Section 15.3, "Setting Up the Fixed Asset Card Usage Information"
Section 15.5, "Generating the CNAO Audit Files for Fixed Assets"
You must generate an XML file to report your fixed assets transactions. The JD Edwards EnterpriseOne software for China includes methods that enable you to easily set up the fixed asset information and store it in the Modification Methods Information - CHINA (F75C201) and Asset Disposal Amounts - CHINA (F75C202) tables. The system generates an XML file with these fixed asset details:
Basic information
Category setting
Modification method
Depreciation method
Fixed asset usage
Fixed asset card
Fixed asset card - Real asset information
Fixed asset card usage information
Fixed asset decreasing information
Fixed asset decreasing information - Real asset information
Fixed asset modification information
This area includes all modifications except AT.
Fixed asset modification information
This area is applicable only for transfer locations.
Fixed asset modification information
This area includes only AT transactions.
This process flow shows the set up that you need to complete and the relationships between the setup programs to generate the fixed assets XML:
Figure 15-1 Process Flow for Setup of Fixed Assets
Use this table to assure that you complete all necessary steps to successfully generate the CNAO audit file for fixed assets 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. | |
Track the history of an asset. | You run the Track Fixed Asset History program (R75C202) to track the history of assets. | |
Set up the fixed asset card usage information. | You use the Setup Fixed Asset Card Usage Information program (P75C203) to set up the card usage information for the asset. | |
Set up the modification types and accounts for an asset. | You use the Setup Modification Method program (P75C201) to set up the modification method for an asset. | |
Generate the Fixed Asset CNAO XML file. | You run the Generate Fixed Asset XML (R75C201) to generate the XML file. |
This section provides an overview of the modification method setup, lists the forms used to set up the modification method, and discusses how to enter modification method details.
You use the Setup Modification Method program (P75C201) to create a link amongst the modification method, asset transaction description, and account information. You use this program to set up modification types and accounts for an asset.
The system saves the data that you enter to the F75C201 table, and writes the data to the fixed assets XML file when you run the Generate Fixed Asset XML - China - 12 program (R75C201).
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work with Modification Methods Information | W75C201A | Fixed Assets (G75C060), Setup Modification Method | Review and select existing asset ID records. |
W75C201B | Select a record and click Select on the Work with Modification Methods Information form. | Enter the modification method and account ID for the asset record. |
Access the Enter Modification Methods form.
Figure 15-2 Enter Modification Methods Form
Enter an asset ID from the Asset Master table (F1201) for which you want to add details.
Enter a value from UDC table 00/DT. The system stores this value in the F75C201 table.
Enter a value from the Account Master table (F0901). The system stores this value in the F75C201 table.
This section provides an overview of fixed asset card usage information setup, lists the forms used to enter fixed asset card usage details, and discusses how to enter fixed asset card usage details.
You use the Setup Fixed Asset Card Usage Information program (P75C203) to enter the fixed asset card usage information. You use this program to set up depreciation ratio for an asset for a period. You can also use this program to modify, copy, and delete existing information.
The system saves the data that you enter to the Fixed Assets Card Usage Information - CHINA table (F75C203), and writes the data to the fixed assets XML file when you run the Generate Fixed Asset XML - China - 12 program (R75C201).
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work With Fixed Asset Card Usage Information | W75C203A | Fixed Assets (G75C060), Setup Fixed Asset Card Usage Information | Review and select existing asset card usage records for an asset. |
W75C203B | Select a record and click Select on the Work With Fixed Asset Card Usage Information form. | Enter the depreciation distribution ratio for an asset record. |
Access the Enter Asset Card Usage Information form.
Figure 15-3 Enter Asset Card Usage Information Form
Enter the accounting period for which you want to enter the card usage details.
Enter a value for department number from UDC table 75C/DE. If you leave this blank, the system retrieves the responsible business unit of the asset from the Asset Master program (P1204).
Enter a decimal value with precision of two decimal places, for example, 0.11 to define the ration of depreciation distribution. This value should be less than or equal to 1, but should be a positive value. The default value for this field is 1.00.
This section provides an overview of the asset master history and discusses how to:
Run the Track Fixed Asset History program.
Set processing options for Track Fixed Asset History (R75C202).
You run the Track Fixed Asset History program to track the history of assets of a company for a specified period. You can run this report for a single asset or you can track the history of all assets of a company for a given period. You set processing options to specify data selection such as the company, asset, and accounting period.
This report retrieves data from the F1201 table and updates the Asset Master History File - CHINA table (F75C204). For ledger type AA, the report retrieves data from the Asset Account Balances File table (F1202).
If you run this report again for the same period, the system updates the asset record in the F75C204 table with the latest status of the asset. If you run this report by changing the asset value to update the past history of an asset, you must rollback the asset value to its actual current value after running the report.
Select Fixed Assets (G75C060), Track Fixed Asset History.
Processing options enable you to specify default values for programs and reports.
Specify the company for which you want to track history of assets. If you leave this processing option blank, the system runs the report for all companies.
Specify the asset number for which you want to track history. If you leave this field blank, the system tracks history for all assets.
Specify the period for which you run the report. If you leave this processing option blank, the system selects the period of the current date.
Specify the year for which you run the report. If you leave this processing option blank, the system selects the year of the current date.
This section provides an overview of the CNAO audit file for fixed assets and discusses how to:
Run the Generate Fixed Asset XML program.
Set processing options for Generate Fixed Asset XML (R75C201).
You use the Generate Fixed Asset XML program to generate the XML file to report fixed assets data elements. You set processing options to specify data selection such as the company, accounting year, starting month, and ending month. 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 system reads these tables to obtain the data for the XML file:
Asset Master File (F1201)
Asset Account Balances File (F1202)
Location Tracking (F1204)
Account Ledger (F0911)
Account Balances (F0902)
User Defined Code Types (F0004)
User Defined Code Values (F0005)
Modification Methods Information - CHINA (F75C201)
Asset Disposal Amounts - CHINA (F75C202)
Fixed Assets Card Usage Information - CHINA (F75C203)
Asset Master History File - CHINA (F75C204)
Select Fixed Assets (G75C060), Generate Fixed Asset XML.
Processing options enable you to specify default values for programs and reports.
Specify the company for which you generate the report. If you leave this processing option blank, the system generates the report for all companies
Specify the modification type for impairment by entering a value from UDC table 00/DT. The system uses this value to calculate impairment amount for the fixed assets XML file.
Specify the first period for which you run the report. If you leave this processing option blank, the system selects employee records beginning with the first payroll period of the year specified in the Accounting Year processing option.
Specify the last payroll period for which you run the report. If you leave this processing option blank, the system selects employee records beginning with the last payroll period of the year specified in the Accounting Year processing option.
Specify the accounting year of the report. You must enter a value in the format YYYY. The system uses this value to select the accounting details for the given period from the F0911 and F0902 tables.
You must complete this processing option.
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.
Specify the Chinese characters to precede the year for which you generate the XML file. For example, if you generate the file for the year 2010, the system prints the values that you enter before the numerals 2010.
Specify the batch type from UDC table 98/IT to indicate the value of the asset that should display in the Modification Information area on the XML.
Specify a value for the depreciation method 01 that needs to be displayed in the Depreciation Equation field of the XML.
Specify a value for the depreciation method 02 that needs to be displayed in the Depreciation Equation field of the XML.
Specify a value for the depreciation method 05 that needs to be displayed in the Depreciation Equation field of the XML.