Understanding the SC028 Voucher Activity by DeptID Report in Cognos Analytics
The SC028 Cognos report is used to track Online Vouchers, Regular Vouchers (Accounts Payable entered), or All Voucher Types by Department (ID or tree) by a selected range of dates.
- This report prints best in landscape orientation on legal size paper.
- The report will only show the expense amount associated with the department or tree node selected as the prompt; this amount may not be the total of the Online Voucher if multiple departments were charged.
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 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.
- Click Finish. Result: the report appears in HTML or your default format.
Prompt Name |
Prompt Description |
---|---|
Department Prompt |
|
Entry Date Range |
Select a voucher entry date range. |
Accounting Date Range |
Select an Accounting Date Range. |
Voucher Types |
Select a voucher type choice to filter the report by.
|
Report Results
Column Definitions
Indicated by Letter |
Column Name |
Column Description |
---|---|---|
A |
Voucher |
The system assigned Voucher ID number
|
B |
Voucher Line |
Invoice line number.
|
C |
Invoice Number |
The number taken from the invoice or created by the department.
|
D |
Vendor ID, Vendor Name |
Vendor selected for this voucher. |
E |
Fund, Project, Account |
These are the related chart string values corresponding to the Department ID for which the report was run. |
F |
Total Voucher Amount |
Total invoice amount.
|
G |
Voucher Purpose |
As entered by department, left blank on vouchers entered by Accounts Payable.
|
H |
Accounting Date |
Determines which Fiscal Year and Accounting Period the expense is posted in; updated if the accounting period closes and the voucher has not been approved/posted.
|
I |
Workflow Status |
Pending (not submitted), In Workflow, Approved (paid), Denied (sent back). |
I |
Workflow Status |
Pending (not submitted), In Workflow, Approved (paid), Denied (sent back). |
J |
Payment Number |
Check number. |
K |
Entered By, Email |
voucher creator s name and email address. |
For additional assistance please contact the IT Support Center at 847-491-4357 (1-HELP) option 7, or consultant@northwestern.edu.