Excel to CI Asset Upload
Purpose: Use this document as a reference to upload multiple assets at one time into in ctcLink.
Audience: Finance or Asset Management staff/supervisors.
You must have at least one of these local college managed security roles:
- ZZ AM Interface Processing
You must also set these User Preference Definitions:
If you need assistance with the above security roles or User Preference Definitions, please contact your local college supervisor or IT Admin to request role access.
Excel to CI (Component Interface) Upload
- Complete the Excel to CI Template - Asset Additions to add multiple assets into ctcLink at one time.
- Please note the following items on the Template:
- Columns that have a "~” after the name in row 19, are required fields.
- Please use the information in row 18 to see if the character (alphanumeric), date, or number values must be entered for that field/column.
- Do not complete/enter information into the columns that are highlighted in color other than white.
- Column AH, Manufacturing Plant, is where to enter the custodial department number and name without adversely affecting any processing in Asset Management.
- Upon template completion, email the completed Excel to CI Template to [email protected].
- Follow the QRG Upload Assets and Data through Interface Transactions to upload the assets into AM within ctcLink.
To fully process the upload assets in AM, continue with the appropriate QRGs:
0 Comments
Add your comment