9.2 Asset Detail Reports

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

Audience: Finance staff, 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.

Asset Detail Reports

Navigation:  NavBar > Navigator > Asset Management > Financial Reports > Asset Details

  1. The Asset Details menu displays.  Use it to create reports on Acquisitions, Locations, History, and several others.  The most common reports are shown below.
Asset Details menu
  1. 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.
  2. Reports are viewed with the Report Manager.  See the Running and Retrieving Reports QRG for more detail about run controls and the Report Manager.
  3. 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.
Report Print Options collapsed
  1. Expand the Report Print Options section by selecting the arrow on the left side of the section.
  2. You can choose to organize the report by any of the available Chartfields by selecting a Chartfield in the Report By field.  This field is required.
  3. Each report has a default Title that you can Override.
  4. 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.  
    1. Select the Update/Add CF Template link 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.  See the ChartField Format Template screenshot below.
    2. Select the Update/Add RF Template link to choose available data fields to include in the report.  See the Report Fields Format Template screenshot below.
Report Print Options expanded
Chart Field Format Template window
Report Fields Format Template window
Acquisitions

This report lists all acquisitions for a specified Fiscal Year/Period range or Date range, and can be generated in Detail or Summary form.

  1. Remember to supply the Report Print Options as explained above.
  2. Enter or select your AM Business Unit.
  3. Enter or select "WACTC" as the Book Name.
  4. Select a Fiscal Year/Period Range, or
  5. Alternatively, select a Date Range.
  6. Choose your desired Type of Report.
  7. The fields down the right side are report filters.  You can choose one or more filters to tailor the report to your requirements, or leave them all blank to report all asset acquisitions.
  8. Enter your parameters then select Run.  
  9. After the process is finished, view the report from the Report Manager link.
Acquisition Run Control
Assets by Location

This report does not require any Report Print Options.

  1. Enter or select your AM Business Unit.
  2. Enter or select "WACTC" as the Book Name.
  3. Select a Fiscal Year/Period Range, or
  4. Alternatively, select a Date Range.
  5. Choose your desired Type of Report.
  6. The fields down the right side are report filters.  You can choose one or more filters to tailor the report to your requirements, or leave them all blank to report all asset acquisitions.
  7. Enter your parameters then select Run.  
  8. After the process is finished, view the report from the Report Manager link.
By Location Run Control
Asset History

This report run control does not require any parameters.  When you run the report, the Process Scheduler Request page will list five separate History reports that have been defined.  Choose one or more reports and select OK.

  1. View the report(s) from the Report Manager link.
History Run Control
  1. Process complete.