PeopleSoft Inventory query modified on 02/10/15

posted Feb 12, 2015, 10:43 AM by Peyri Herrera
For districts that use PeopleSoft inventory only

The project team modified the Inventory query formerly named M_02000_STORES_LIST. It is now called M_STORES_LIST and can be used by all districts that use PeopleSoft Inventory. It contains the following columns: SetID, Business Unit, Item ID, Family, Description, UOM, Standard Price, Qty Available, Supplier, Supplier Item ID, Reorder Point (Min), Max Qty, and Reorder Qty.
Stores List Query

Use the M_STORES_LIST query to display the warehouse items with the following information:
  • Available Quantity at the time the query was run
  • Price and UOM to provide as a catalog to your sites
  • Supplier Information such as the Supplier ID and Supplier Item ID
  • Minimum and Maximum Quantity setup on item(s) for replenishment processes
Directions: To run this query, navigate to Main Menu > Reporting Tools > Query > Query Viewer. In the Query Name field, enter M_STORES_LIST, then click Search. Click HTML or Excel. When prompted, enter your SetID (district number) and Business Unit (warehouse number). Click View Results.