Kansas Department of Administration

New Purchasing Queries

March 3, 2020

Two new purchasing queries have been created:


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.


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


Any Homepage > Utilities tile > Query Viewer


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.

« Back

© 2024 Kansas Department of Administration. All rights reserved.