1. Home
  2. Financial Reporting
  3. What are some common queries to monitor vouchers and travel activity?

What are some common queries to monitor vouchers and travel activity?

To access the mostly used Financial System queries, follow the instructions outlined below.

  1. Log in to MyPack Portal.
  2. Click on the Financial System Homepage.
  3. Click on the Financials Quick Nav tile.
  4. Click on Monitoring Tools & Reports.
  5. Click on Query_Viewer (Rpt).
  6. Use the drop-down menu next to Search By to select Query Name.
  7. Enter the query name into the adjacent blank field.
  8. Click o Search.
  9. Within the results select Excel to run the query.

Common queries to monitor voucher activity include:

QueryDescription
Q_Vchr_List_Not_PD_2DIGIT_OUCListing of unpaid vouchers by 2-digit department id
Q_Voucher_List_Not_Paid_BY_OUCListing of unpaid vouchers by OUC
Q_Vchr_PendingCollege_by_OUCListing of vouchers needing college/campus approval
Q_VCHR_INCOMPLETE_BY_OUCListing of vouchers not routed by OUC
NC_VCHR_NOTICE_PENDINGListing of pending vouchers with AP notifications
NC_VCHR_NOTICE_APPROVEDListing of resolved/approved vouchers with previous AP notifications
** Search Q_ to view additional queries.

Common queries to monitor travel activity include:

QueryDescription
NC_TRAV_REIMBS_BY_OUCThe query returns pending and paid reimbursements within a date range.
NC_TRAVEL_SEARCHThe query returns open travel authorizations by OUC
NC_TRAV_SUBMITTED_NOT_APPRVThe query returns all open travel documents for an OUC and what approval levels have occurred.

To run additional standard queries for all transaction types, follow the instructions outlined below.

  1. Navigate to MyPack Portal.
  2. Click on Financial System Homepage.
  3. Click on the Queries and Reports tile.
  4. Select the appropriate transaction type from the drop-down menu.
  5. Enter the required fields.

Updated on August 3, 2022

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support