ctcLink Accounting Manual | 40.40.70 Useful Queries

QFS_AM_CNV_ASSET_VALIDATION

Query returns all assets with all activity in the college records. The query results are not limited to converted assets. The Conversion Depreciation Amount will only display depreciation through the ‘Fiscal Year Not Greater Than’ value entered in the query criteria. The Conversion Cost shows the cost for all assets whether the asset was part of conversion or was added later.

The following fields are included:

CTC_AM_DEPRECIATION_TRANS

This query shows depreciation for assets for the life of each asset by fiscal year with beginning period and ending period (Usually 1 through 12 except for the first year and the last year. Colleges should be able to use the results to demonstrate to an auditor depreciation by asset or filter by fund, etc. as of fiscal year-end by exporting to Excel and either filtering or creating a Pivot table

 

QFS_AM_ASSET_DEPR_BY_ACCTPRD

This query provides scheduled depreciation for a specifical fiscal year by period. This may be used to demonstrate to auditors increases in depreciation for the year or to reconcile any depreciation additions mid-year, etc.

QFS_AM_ASSET_COST

This is an excellent query for a physical inventory report. Shows location and serial # of asset IDs.

CTC_ACCTG_LINE_AM

This query shows all Asset Management transactions between specified dates. It allows colleges to identify specific types of accounting adjustments for the year and see the accounting supporting it. It is possible to filter it just by new additions for the year, retirements, etc. This will provide the details to show auditors of additions and retirements and new depreciation for the year like the CR2128 report.

The following fields are included: