The SC034 Corporate Card Activity Report is used to review which procurement card charges in My Wallet have been reconciled via an expense report. The SC034 can be used to review Unreconciled, Reconciled, or Both unreconciled and reconciled transactions. This is a real-time report; data is no from the previous business day.
Step 1 Navigate to the report
Begin by logging into Cognos Analytics.
- Click Team content, from the Navigation Panel.
- Click Finance, Facilities, and Research Administration folder.
- Click School or Central folder.
- Click Supply Chain folder.
- Click the report title to see the prompt page.
Step 2 Respond to prompts and run the report
- Respond to prompts as needed to filter the report. Thee report contains all chart strings to which you have access.
- Click Finish. Result: the report appears in HTML or your default format.
Prompt Descriptions
|
Prompt Name
|
Prompt Description
|
|
Date Options
|
- From Yesterday to Today: Use this prompt to automatically choose Submission Date Range for last two days. Tip: This is handy choice if you need to setup a recurring schedule
- For the Last 7 Days: Use this prompt to automatically choose Submission Date Range for last seven days. Tip: This is handy choice if you need to setup a recurring schedule
- User Defined Date Range: Use this prompt to filter report by From Submission Date To Submission Date (after 1/28/16)
|
|
Transaction Type
|
- Unreconciled: Use this prompt to filter report for Corporate Card transactions without an expense report.
- Reconciled: Use this prompt to filter report for Corporate Card transactions with an expense report. Tip: Chart string prompts become available when you choose this option.
- Both: Use this prompt to filter report by employee ID or name.
|
|
Card Holder
|
Search by entering all or part of a Card Holder Employee ID or by Name.
|
|
Merchant
|
Search by entering all or part of a Merchant Name.
|
|
Department Prompt
|
- Tree (As of Today): Select one or more department node.
- Department Search & Select: Search and Select for one or more departments.
|
|
Project Status.
|
Filter Project prompt and reports results by All Projects (Default), Active Project Only, Inactive Projects Only.
|
|
Project
|
Search and Select for one or more Project ID or its description.
|
|
Account
|
Search and Select for one or more Account ID or its description.
|
Report Results
Unreconciled report example
Reconciled report example
Unreconciled and Reconciled report example
Column Definitions
|
Indicated by Letter
|
Column Name
|
Column Description
|
|
A
|
Merchant
|
Business where the purchase was made.
|
|
B
|
Transaction Date
|
Date of purchase.
|
|
C
|
Transaction Load Date
|
Date transaction was uploaded to My Wallet.
|
|
D
|
Transaction ID
|
My Wallet transaction number.
|
|
E
|
Amount
|
Dollar amount charged in U.S. currency. Credits appear as a negative amount for merchant refunds.
|
|
F
|
Expense Report ID
|
Expense report number.
|
|
G
|
Expense Report Status
|
- blank – unreconciled
- Not submitted – saved and budget checked but not submitted
- Submitted - for approval
- Posted – fully approved and reconciled
|
|
H
|
Description
|
Line description from Detail tab in expense report.
|
|
I
|
Chart strings
|
Chart strings.
|
Keywords: bi "business intelligence" era reporting cognos analytics "supply chain" sc ffra nufin
Created: 2018-05-10 13:45:21
Updated: 2019-02-04 16:59:55