Reports

The following CGI infoAdvantage Reports are provided for the Fixed Assets area.  

Report Name

Description

Fixed Asset Property Accounting Addition Report

The report lists fixed assets and components that have been acquired for a given accounting period and fiscal year time frame. The transactions are grouped by Fund, Department, Fixed Asset Type and Event Category and include the corresponding posting amount. Totals are generated for Fund, Department, Fixed Asset Type and Event Category. The document identifier for each transaction is also included in the report to allow for easy tracking back to the original document in CGI Advantage Financial. Only the posting lines with posting codes F002, F012 and M001 are included in the report. If additional equivalent posting codes are created the report filters must be updated.

Fixed Asset by Type – Detail Report

The report lists fixed assets and components according to their fixed asset type. For each fixed asset the manufacturer, serial number, model number, asset location and value are included in the report. The fixed assets are grouped by Fixed Asset Type. Totals are generated for Fixed Asset Type.

Fixed Asset Transaction Detail Report

The report lists the details of transactions for each fixed asset and component for a given time frame. The transactions are grouped by Fund, Department, Unit, Fixed Asset Type and Fixed Asset Number. Totals are generated for Fund, Department, Unit, Fixed Asset Type and Fixed Asset Number. The document identifier for each transaction is also included in the report to allow for easy tracking back to the original document in CGI Advantage Financial. Transactions with posting code F001, F004, F005, F010, F020 and F040 are excluded from this report. If additional equivalent posting codes are created the report filters must be updated.

Fixed Asset Replacement Forecast Report

The report lists all the fixed assets and components due for replacement in a given time frame.  The fixed assets are grouped by Department and Fixed Asset Type. Totals of the Asset Value and Accumulated Depreciation are generated for Department and Fixed Asset Type. The replacement date is calculated as the sum between the acquisition or in-service date – whichever is later – and the useful life of the asset expressed in days. The replacement date is then evaluated against the time frame entered as a report parameter.

Statement of Fixed Assets by Dept. and Unit Report

The report lists the net asset value for fixed assets by Fund, Department, Unit and Fixed Asset Type. The net asset values are grouped by Fund, Department, Unit and Fixed Asset Type. Totals are generated for Fund, Department, Unit and Fixed Asset Type.