Understanding the Fixed Asset Ledger

After you run the Revaluation Journal and post the adjustments to the general ledger, you can generate the Fixed Asset Ledger report to send to the government. The system uses the information that is set up for the legal company in the Fixed Asset Ledger Set up program (P76P502) to determine the amounts to retrieve for each column on the report. Because the amounts to retrieve are based on a specific document type, which is set up in the Fixed Asset Ledger Set up program, the person reviewing the report can see the movement of the asset from the initial setup, through the accumulated depreciation and the revaluation process.

You can generate the fixed asset ledger in either proof or final mode. The report is the same regardless of the mode that you select, however, in final mode, the system assigns a folio number to each page that it retrieves from the Next Numbers table (F0002). Because this folio number is a legal document number, you should validate that the information on the report is correct before you generate it in final mode.

When you run Fixed Asset Ledger, the system retrieves the information that prints on the report from these tables:

  • F1201

    The system retrieves information about the asset, such as the asset number, description, and acquisition date.

  • F1202

    The system retrieves the beginning balance and period net posting amounts for the asset.

  • F0911

    The system retrieves the amounts for each column that you specify in the Fixed Asset Ledger Setup program based on the corresponding document type.

    The system uses the asset setup code, which you enter in a processing option, to determine which setup records to retrieve. For example, if you set up document type DP for the Depreciation column, the system retrieves the amounts associated with document type DP for each asset for the period and year specified.

The system prints the information that it retrieves in these columns on the report:

  • Begin Balance

  • Revaluation

  • Exchange Rate Differences

  • Improvements

  • Deductions

  • Depreciation

  • Inflation Adjustment

The system also uses the AAI items FCxx and FDxx to retrieve the amounts associated with the cost and accumulated depreciation accounts which it prints on the report.

When you run the program in final mode, the system assigns the next number for each page based on the company and fiscal year.

Note: This report must be generated to print on legal paper. You must customize the program to accommodate this requirement; otherwise, the report does not display all of the columns or the required folio number.