New Purchasing Queries
March 3, 2020
Two new purchasing queries have been created:
- KS_PO_DISPTACH_HISTORY
Purpose – This query provides users access to the dispatch history on Purchase Orders (POs) for their Business Unit. Results include POs for which the user is not the buyer and those to which they do not have access to update for the buyer.
Search Criteria – Business Unit & PO
Display Results – Business Unit, PO Number, Supplier, Location, Change Order, Dispatch Method, Date and Time Dispatched, User
NOTE: Change Order ‘0’ is the original PO dispatch.
- KS_PO_CONTRACTS_BY_BU
Purpose – This query provides agency contracts by Business Unit that are active during a defined period and includes both maximum and released amounts.
Search Criteria – Business Unit, Contracts In Effect From & Contracts In Effect To dates
Display Results – Business Unit, Contract ID, Description, Contract Status, Supplier ID, Supplier Name, Contract Start Date, Contract Expire Date, Contract Maximum Amount, Contract Released Amount
Navigation-
Any Homepage > Utilities tile > Query Viewer
OR
NavBar > Navigator > Reporting Tools > Query > Query Viewer
For more information regarding these queries, please see the updated catalog on the SMART Web Catalog of SMART Reports, Queries and Inquiries.
Thank you, and if you have any concerns please submit a ManageEngine Service Desk request.