Understanding the CNAO Audit File for Fixed Assets

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)