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.
Use the M_STORES_LIST query to display the warehouse items with the following information:
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.