Pursuant to an identified need, a new public query has been created in Peoplesoft Finance that will allow the user to see all payments made to a vendor in a fiscal year that have been posted to their Department. The query is titled QU_GL_DEPTANNUAL_VENDOR_DET, and it has been added to the list of public queries available, which can be found at the following link: http://www.queensu.ca/financialservices/support/accountsmove/pspublicqueries.html
Please note that it is possible to see the payments made to all vendors for the Department by entering a ‘%’ sign in the Vendor field on the selection screen. The results will be sorted by vendor and then by posting date. This report will allow departments to efficiently review their vendor payments, which should aid in both daily operations and in the budgeting process.
Please contact Financial Services with any questions you may have on this matter.
Queen's Financial Services