TLC Resource Portal

M3 How to Search Inventory Availability-Countertop SOP


Process Flow: How to check M3 Product Availability 

  • Prior to providing Resolution: Always check M3 (MMS081) for product availability
  • Prior to Processing M3 Order: Always Re-check M3 (MMS081) for product availability
  •  Only reference "Avail Inv" column: Column must reflect a "Positive quantity" . If column is "Blank" or a "Negative" quantity -> Product is OOS or "Unavailable" for CR order processing


Understanding the M3 inventory columns


WHSON-HANDRESRVDAvail invAlloc qtyOn OrderAlloc net

Alloc Net SSStock

TLC Warehouse Location







Total product quantity in  warehouse locationInventory is Reserved for Retail Team Pending Orders"

-Inventory is "Not Available" for CR Order Processing 
Total inventory qty available for CR order processing.

**CR Only references this column for Order Processing

- Qty must reflect a "Positive Qty" to process order
Total Inventory qty allocated to orders in queue awaiting shippingPlease do not reference - information may be incorrectPlease do not reference:
For Warehouse use only

Note:
West Bend Major Appliance Category

- Reach out to Level 3 for approval


Onshore Level 3 will advise resolution




Note: The majority of counter products are located in PKY (Paris KY)






If Not available in PKY -

But avail. in the following locations reach out to Level 3 support approval to proceed

APA
EPA
HNJ
SNV
WFL






 



***Click Link for West Bend Major Appliance Product List: https://westbend.com/pages/major-appliances



M3 -Column breakdown (M3: MMS081 View)

- Please reference bottom of article for Additional Snip Its of Product Availability





How To Steps:

Step 1. Log into M3 

A) Left side tool bar: Click "Favorites" & drop down list will appear

- Select : MMS081 Availability. Display All Warehouses 





 Step 2:  Top right - "Filter Options" location

 I. Sorting order Field: Select ->1-Whs,oh,ord,res 

     - Choosing a different sorting order will not reflect true Countertop product availability


II. Item Number Field: Enter full M3 Part (SKU) Number: (Example: PSCRN83456

-Units: Enter Full Model (SKU) Number: (Example: MM900HDS)

     

III.  Whs Field: Field will auto populate "PPN"

-Backspace to remove this info : This will allow you to view all warehouse locations

   

 ** M3 now reflects Product Availability 





Full View of all warehouse locations and product availability


 


   


Do not know the Product Code -Use Search engine below. 

How To Steps to: Search by product name (description)

 - Search is broad & does not reflect real time inventory availability. Inly to be used to locate Part Code "or" Full Model Number (SKU)

- After locating , you will then need to search MMS081 for product availability 


Step 1. Log into M3 

A) Click "Favorites"

- Click "Mashup Library" -> Drop will reflect

- Select : item_Overview_DIS



Screen Populates

- Click "Search for item" field

- "Search box" populates: There are 2 ways to locate the product with this view

  A) Part Search: Enter the name of the part (Example: Auger)  & hit "Enter" .  Scroll until you locate the part   



    B) Part Search: Enter only a partial Model SKU (Unit) number , that the spare part is associated with (Example: VSJ843) & hit "Enter" , the part list will populate
- Example: VSJ843 is a partial model (SKU) Number -> Full Model Number is: VSJ843QS, VSJ843RS, OR VSJ843QR
- Please note: This search does not always pull "All" parts associated with the Model (Unit) Number 

- If you click the "Product Group" column 2 times it will show all (Example: Omega) together. 






3 Examples of product available for CR order processing

Example 1:




Example 2:



Example 3:





3 Examples of Product "All Reserved" or "OOS" -> Not available for CR order processing

Example 1: All stock quantity reflects "Resrvd qty" & "Avail Inv" reflects a "Negative" quantity



Example #2:  Product OOS



Example #4: All stock quantity reflects "Resrvd qty" & "Avail Inv" reflects a "Negative" quantity







Key words

M3 Inventory

How to search inventory

Part Inventory

M3 Part Inventory

Inventory 

Juicer Inventory

West Bend Inventory

Chef's Choice Inventory

Yonanas Inventory

Excalibur Inventory

Zeroll Inventory 

Kalorik Inventory

Vinturi Inventory


1/3/2024: Update: Only update-> I slightly changed the format of the article.  No changes with Process procedures. 





Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.