To analyze invoice date versus entered or payment dates |
Invoice Date versus Entered/Payment Dates |
To find a summary total of vouchers paid to set aside vendors |
Set Aside Voucher Summary |
To find a vendor's payment history based on a date range |
Vendor Payment History Query |
To find all expenditures in a date range by chartfield |
SAAAS Option 16, 5-8 |
To find all of the vouchers associated with a Journal ID. This can help reconcile the AP module to the general ledger |
Voucher Accounting Line by Journal ID |
To find all unpaid vouchers for a BU that have discount pay terms that are still candidates for an awarded discount |
Vouchers with pending discounts |
To find all vouchers where the payments terms do not match the contract payment terms |
Contract vs Voucher Pay Terms |
To find all vouchers with the payment handling code RA per Comptroller's Memorandum No. 2009 - 31 |
RA Vouchers with payment notes |
To find deleted vouchers (status of X) by accounting date |
Deleted vouchers by Accounting Date |
To find energy consumption information for prior to 7/1/2008 |
Voucher Energy Consumption < 07-01-08 |
To find energy consumption voucher information by utility code since 7/1/2008 |
Voucher Energy Consumption |
To find non-PO vouchers by one or more business units |
NonPO Vouchers by Bus Unit |
To find set aside vouchers used to be included in reporting to CHRO |
Set Aside Voucher Query |
To find telecomm expenditures that were charged by ITD telecomm division after 7/1/2011 |
Telecomm Expenditures after 7/1/2011 |
To find telecomm expenditures that were charged by ITD telecomm division prior to 7/1/2011 |
Telecomm Expenditures before 7/1/2011 |
To find the number of vouchers entered by UserID |
Number of vouchers by User ID |
To find the number payments by Business Unit and payment method |
Payment Count by Business Unit |
To find vendor check information if you know the vendor's FEIN |
Vendor Check Number by FEIN |
To find vendor check information if you know the vendor's name or part of the vendor's name |
Check Number by Vendor Name |
To find vendor information if you know the vendor name or part of the vendor name |
Vendor ID, name, SETID |
To find vendor informtion if you know the vendor ID |
Vendor search by VendorID |
To find vendors with credit balances |
Vendors with credit balances |
To find voucher and purchase order information where the AP and PO business units differ |
Internal Service BU reporting |
To find voucher loaded as a quick invoice or as an interface voucher upload |
RA Vouchers by Source |
To find voucher that have been deleted but may still need to be budget checked in order to create corrective accounting entries |
FYE Deleted Voucher by BU |
To find vouchers that are on hold by business unit |
Vouchers on Hold by BU |
To find vouchers that are posted under the asset account range from 55420 through 55890 |
Capital Asset Expenditures |
To find vouchers that have been budget checked but not yet paid. Ideal for month end reconciliation and verification |
Vouchers Budget Checked but Not Paid |
To find vouchers that have been budget checked but not yet posted. Ideal for month end reconciliation and verification |
Vouchers Budget Checked Not Posted |
To find vouchers that have been paid but not posted. Can be used for month end reconciliation and verification |
Vouchers Paid but Not Posted |
To find vouchers that have not been approved by the business unit |
Vouchers not approved by the Business Unit |
To find vouchers that have not been posted by the business unit |
Vouchers Not Yet Posted |
To find vouchers that were paid from accounts other than expenditure accounts (50000 range) |
Paid vouchers from non-expenditure accounts |
To find vouchers with discounts taken and discounts lost |
Vouchers, Pay Terms, Discounts |
To identify those vendors receiving payments coded as pass through funds to account 55050 for Federal Grant reporting |
55050 Sub-recipient Vendor Detail |
To verify appropriate account or utility codes |
Utility Vouchers, Utility, Account Codes |