University of Houston Human Resources
Survival Guide Home
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
Benefits
Employment
HRIM
New Hire Orientation
PCD
Ethical Conduct of
Employees
Human Resource Forms
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
Running Reports - Leave Server Name Blank
Purpose
Useful to review problem transactions within
a college/division/department.
1. Unposted Vouchers by Department
Navigation
Reporting Tools
Query Viewer
Type in UHS_AP_Unposted_Vouchers
Click Search
Click Run
Parameters: AP Business Unit=00730;
Department=H0058 (for College of Education);
Accounting Date Less Than=Today’s Date
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 vouchers.
You have successfully run the unposted
voucher by department query.
________________________________
View Sample Report
|
