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 Descriptions
|
Prompt Name
|
Prompt Description
|
|
Department Prompt
|
- Tree: Select one or more department node.
- Department Search & Select: Search and Select for one or more departments.
|
|
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.
- All Voucher Types
- Online Vouchers
- Regular Vouchers
|
Report Results
Column Definitions
|
Indicated by Letter
|
Column Name
|
Column Description
|
|
A
|
Voucher
|
The system assigned Voucher ID number
- Online Voucher Style: DPR Direct Payment Request, VTE Visitors Expense Report, OTS Contracted Services, or blank indicating Accounts Payable entered the voucher
- Voucher Type: Regular or Batch
|
|
B
|
Voucher Line
|
Invoice line number.
- Distribution Line: chart string line number
|
|
C
|
Invoice Number
|
The number taken from the invoice or created by the department.
- Invoice Date: date taken from the invoice or date of service, as entered 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.
- Voucher Line Amount: invoice line amount
|
|
G
|
Voucher Purpose
|
As entered by department, left blank on vouchers entered by Accounts Payable.
- Line Description: taken from invoice or as entered by the department
|
|
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.
- Budget Date: date Budget Check was run
- Budget Line Status: Budget Check status; Not Budget Checked, Valid, Error
|
|
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 related NUFinancials inquires including check reconciliation, see View Payments to Vendors and Non-Employee
Keywords: BI "business intelligence" era reporting "Supply Chain" SC ffra nufin
Created: 2018-05-08 15:08:35
Updated: 2019-02-04 16:59:55