Announcements - Reporting

New Purchasing Queries

Two new purchasing queries have been created:

 

  1. 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.

  1. 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.