Voucher Report
This article covers how to run and interpret the Voucher report on the Purchasing dashboard.
This user guide assumes basic knowledge of Data Warehouse. View the Data Warehouse Basics guides for more information.
What does this report show?
The Voucher report allows you to view and search voucher and payment information. This report includes all vouchers/payments, not just the ones related to purchase orders.
1. Log in to the CSUF Data Warehouse (OBIEE).
2. Click on Dashboards and select Purchasing.
- Click on the Dashboards menu in the CSUF Data Warehouse.
- Select Purchasing.
3. Click the Voucher tab on the Purchasing dashboard.
Report Overview
The Voucher report will show you all vouchers for your department(s) since July 2010 by default.
When you access the report, your personal settings for the report (page) appear. If you have not set up your personal settings, the system defaults will automatically populate.
Report Filters
The first section of the report contains the available filters. Utilize the filters to narrow down your report results or find specific values.
Leaving a filter blank is equivalent to selecting all available values with values associated with them (e.g., if you leave Department blank, your report will show all vouchers for all of the departments that you have access to).
| Filter |
Description |
|---|---|
| Business Unit | The Business Unit to which the transaction was posted. All purchase requisitions are under FLCMP. |
| Voucher # | The ID number assigned to the voucher. |
| Invoice # | The ID number assigned to the invoice. |
| Invoice Date | The specific date or range of dates for which you wish to view invoice information. |
| Division | The specific campus division(s) for which you wish to view data. |
| Sub-Division | The specific campus sub-division(s) for which you wish to view data. |
| Sub-Division/College | The specific campus college(s) for which you wish to view data. |
| Department/College | The specific department ID(s) for which you wish to view data along with the name associated with the department ID(s). |
| Vendor ID | The number associated in the CFS system with vendors/suppliers. |
| Vendor Name | The name of vendors/suppliers in the CFS system. |
Report Parameters
Just under the report filters are the report parameters for the report results table.
Total Number of Records Retrieved will be the total number of rows in the search results table.
Any other filters that you have selected in the report filters will also appear in this section.
Report Results Table
The second section of the report contains the report results table.
Column Descriptions
| Column |
Description |
|---|---|
| BUSINESS UNIT | The Business Unit to which the transaction was posted. All purchase requisitions are under FLCMP. |
| VOUCHER ID | The ID number assigned to the voucher. |
| INVOICE ID | The ID number assigned to the invoice. |
| INVOICE DATE | The date of the invoice. |
| VOUCHER AMOUNT | The total amount of the voucher. |
| VENDOR NAME | A combination of the Vendor/Supplier ID number and the Vendor/Supplier Name for the purchase. For vouchers not related to purchase orders, this may be the Customer ID/Customer Name. |
| LINE DESCRIPTION | The description of the transaction. |
| PO ID | The purchase order number associated with the transaction (if applicable). |
| DEPARTMENT | A combination of the Department ID and Department Name of the department to whom the transaction is billed. |
| PAYMENT ID | The ID number assigned to the payment. |
Voucher Detail
You can click on the VOUCHER ID hyperlink to view more detail about the requisition.
1. Click on the VOUCHER ID to view additional details.
2. Click on the Voucher Detail pop-up that appears.
Voucher Detail Column Descriptions
| Column |
Description |
|---|---|
| VOUCHER ID |
The ID number assigned to the voucher. |
| INVOICE ID |
The ID number assigned to the invoice. |
| INVOICE DATE |
The date of the invoice. |
| VOUCHER AMOUNT |
The total amount of the voucher. |
| VENDOR_NAME |
A combination of the Vendor/Supplier ID number and the Vendor/Supplier Name for the purchase. For vouchers not related to purchase orders, this may be the Customer ID/Customer Name. |
| ACCOUNT |
The Account chartfield code to be billed for the charges. |
| ACCOUNT DESCRIPTION |
The name associated with the Account chartfield code to be billed for the charges. |
| FUND |
The Fund chartfield code to be billed for the charges. |
| FUND DESCRIPTION |
The name associated with the Fund chartfield code to be billed for the charges. |
| DEPTID |
The Department ID chartfield code to be billed for the charges. |
| DEPARTMENT DESCRIPTION |
The name associated with the Department ID chartfield code to be billed for the charges. |
| PROGRAM |
The Program chartfield code to be billed for the charges. |
| PROGRAM DESCRIPTION |
The name associated with the Program chartfield code to be billed for the charges. |
| CLASS |
The Class chartfield code to be billed for the charges. |
| CLASS DESCRIPTION |
The name associated with the Class chartfield code to be billed for the charges. |
| PROJECT |
The Project chartfield code to be billed for the charges. |
| PROJECT DESCRIPTION |
The name associated with the Project chartfield code to be billed for the charges. |
Need More Help?
For technical assistance with the Data Warehouse, please contact the IT Help Desk at [email protected] or 657-278-7777.
For questions about getting access to the Data Warehouse or how to use the reports, please contact IT Training at [email protected] or 657-278-5647.
For questions about purchase requisitions or purchase orders, contact Contracts & Procurement at [email protected] or 657-278-5230.