University of Illinois | Chicago . Springfield . Urbana-Champaign

EDW - FIN - Purchase Order/Invoices Universe

Description

The EDW - Finance - Purchase Order Invoices universe should be used for all reporting related to Requisitions, Purchase Orders, and Invoice Vouchers.  Using the new universe, you can create reports listing posted Requisitions for a specific unit, analyze PO's and their related Invoice Vouchers, and investigate items purchased and paid for.

Universe Guides

Find out how to use the Purchase Order universe to create reports:

• Quick Reference Guide: Purchase Order Invoice
• Detailed Universe Guide: Purchase Order Invoice
  
  

Query Clearinghouse

Query Clearinghouse is a web-based repository of sample BO reports, SQL code, and report templates available for shared use by UI report developers. The Query Clearinghouse sample reports should give you a great start to developing the reports you need to meet business needs in your office.  Examples of sample reports you’ll find in Query Clearinghouse:

• List of PO's, IV's, and Payments for a Fiscal year by Resp Chart & Org Details
• College and Dept listing by Chart and Fund listing by Org
• Listing of Financial Persons using the 3-digit Organization code embedded in the fund title
  
  

Solution Library

The solution library contains step-by-step instructions on how to create commonly requested reports, including a report template to get you started.  Examples of what you’ll find in the Solution Library:

• Purchase Order Listing

 

Business Concepts and Usage Notes

The Business Concepts and Usage Notes section of the DS website contains a variety of additional information that will assist you in understanding EDW data and using EDW products. Examples of what you’ll find in Business Concepts and Usage Notes:

• Purchase Order/Invoices Universe Usage Notes
• C-FOAPAL Guide
• Handling of NULL Values for Finance