Survival Guide
  U H Home U H Home Search University of Houston
 
University of Houston Human Resources
 HOME
Survival Guide Home
 
 FINANCE
Accounts Payable
Baseline Standards and Cash Handling
Budget Journals
Business Continuity Planning
Credit Card Services
Getting Started
Gifts/Endowments
GL Journal Entries
Grant Reports
Misc. Responsibilities
Property Management
Purchasing
Reports
Requests/Work Orders
Tax Information
Understand Cost Centers

Finance Forms
 
 HUMAN RESOURCES
Benefits
Employment
HRIM
New Hire Orientation
PCD
Ethical Conduct of
Employees

Human Resource Forms
 
 PAYROLL
Direct Deposit
Direct Deposit and P.A.S.S
Hard Check Distribution
Payroll Deductions
Payroll Encumbrances
Payroll Reconciliation
Run Trial/Final Payroll
Suspense/Reallocations
Time and Effort
University Pay Glossary
University Pay Statement
Verification Report
W4s and P.A.S.S.
Payroll Forms



Reports
Running Reports - Leave Server Name Blank
Schedule a Report
Deleting Run Controls
Deleting Reports
Paper SCR Requirements
Report Matrix
Monthly Checklist
Fund Equity Report
Negative Fund Equity Report
Unbudgeted Fund Equity Report
Budget Summary Report
Expenditures by College/Division Queries
Department Verification Report
Downloading HR Reports to Excel
Late Payment Interest Query
Unposted Vouchers by Department Query
Open Commitment Query
Unposted GL Journals Query
Purchase Requisitions Not Completed Query
Budget Journals Not Approved Query
Reviewing HR Actions Query
Report Distribution


Open Commitment Query

Purpose
Useful to review problem transactions within a college/division/department.

1. Open Commitments

Navigation

  • Reporting Tools


  • Query Viewer


  • Type in UHS_OPEN_COMMITMENTS_DETAIL


  • Click Search


  • Click Run


  • Parameters: GL/PO Business Unit Like=00730; Fund Code Like=% (to see all); DeptID Like=H0058 (for College of Education Dean); Program Like=% (for all); Project/Grant Like=% (for all)


  • Click View Results


  • Click Download Results in Excel Spreadsheet


  • Feel free to delete any columns necessary in Excel to make the report easier to read.


  • You can use this report to determine if there are any problematic encumbrances.


  • You have successfully run the open commitment detail query.



  • _____________________


    View Sample Report