Cost and Depreciation Reports

Purpose: Use this document as a reference for creating Asset Management Cost & Depreciation reports in ctcLink.

Audience: Finance and Asset Management staff.

You must have at least one of these local college managed security roles:

  • ZZ Asset Management Reporting

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

These reports use the data from the reporting tables that must be populated. See the Load The Reporting Tables QRG.

Cost and Depreciation Reports

All reports are generated via Run Controls.  Run Controls consist of a name and some parameters to pass to the process at run time.  The parameters may be different for different reports, and each run control is unique to a single report and user ID.  

  • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended.

Reports are viewed with Report Manager. Please refer to the Report Manager steps for further instructions.

Navigation: Asset Management > Financial Reports > Cost and Depreciation

Cost and Depreciation Report options
  1. Many asset report run control pages contain a section for Report Print Options.  This section is collapsed by default and must be expanded and populated for the report to create any output.
  2. Expand the section by selecting the arrow icon on the left side of the section.
  3. You can choose to organize the report by any of the available Chartfields by selecting the Chartfield in the Report By field.  This field is required.
  4. Each report has a default title that you can override.
  5. You must define both the CF (Chartfield) Template and the RF (Report Field) Template, and you will need to create templates for each report.  The first time you use a run control, you define the templates.  The templates can then be re-used for the same run control for subsequent reports of the same type.  After a template has been defined, you can edit it if needed.  Use the CF Template to select the which Chartfields to include in the report, and the order to display them.  You also choose which Chartfields you want to subtotal.
  6. Use the RF Template to choose available data fields to include in the report.
  7. Enter Title Override, if desired.
  8. Enter the Amount Length to display.  If the amount exceeds the length entered, the amount is shown as a series of asterisks.  If you enter an amount length of 4, and the amount retrieved is 15,000.00, the report will display ****.** in the Amount field.

Cost Activity

  1. These reports all use very similar Run Controls, such as this one for the Cost Activity Report.
  2. The Report Print Options were outlined in the section above.
  3. Enter or select your AM Business Unit.
  4. Enter or select Book Name = "WACTC".
  5. Enter a Fiscal Year/Period Range or a Date Range.
  6. Choose the Type of Report.
  7. The fields on the right are report filters.  Choose one, none, or multiples to generate the desired report.
  8. Enter your parameters then select Run.  
  9. After the process finished, view the report from the Report Manager link.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

Video Tutorial via Panopto

View the external link to Cost and Depreciation Reports. This link will open in a new tab/window.