This article lists the public EPM queries and descriptions for this topic. Please review available public queries below before making a new query.
EPM public query names and descriptions for Inventory
- IN CO-59 All Inv Depletions (DOCX) - The query shows the depletion amount for a specified period.
- IN CO-59 All Inv Receptions (DOCX) - This query provides the dollar value (to four significant digits) for purchases made for the Inventory module; aids users responsible for completing the annual CO-59 report.
- Inventory Counting Event (DOCX) - This query returns data recorded by an inventory counting event by inventory business unit and a range of counting event ID's. It was created to assist agency staff in performance of physical inventory.
- Inv Items with No Actual Cost (DOCX) - This query identifies active inventory items that do not have a default actual cost by inventory business unit.
- Average Price versus Last PO Price (DOCX) - This Query is run by Inventory Business Unit. It compares the Max Average Item Cost with the Last PO Price and shows the difference.
- Obsolete Inventory (DOCX) - This query returns active inventory items by inventory business unit with no activity; receipts, transfers, or depletions, for the previous 2 years from date of execution. Cycle count adjustments are excluded. This query can be used to identify obsolete inventory items
- Multiple Storage Locations/Item (DOCX) - This query provides a list of inventory items by Business Unit that are stored in multiple storage locations.
More resources