# STOCK REPORTS

# APPLE DISTRIBUTION STOCKS

This module is used to check the availability of Apple distribution products.

- **Filter Options**:  
    You can filter by product and select the warehouse(s).
- **Availability View**:  
    The system shows the available quantity in the selected warehouses. Next to the quantity, an **“i” (info) button** is available, which displays detailed stock breakdowns:
    
    
    - **Physical**: Quantity physically available in the warehouse.
    - **Allocated**: Quantity scanned or reserved in orders, but not yet packed.
    - **Committed**: Quantity scanned and packed in an order.
    - **Booking**: Quantity reserved for an order where stock is insufficient, so it is on hold.
- **Export Option**:  
    You can export the availability data to Excel by clicking the **“Export to Excel”** button.

<video controls="controls" height="394" poster="" width="788"><source src="https://mercantile-kb.s3.ap-southeast-1.amazonaws.com/OMS/Stock_report/210829cdd2154888a245f1de87aaa228b4321b99e6f540c0a24da2cd42696816567c655f4e3b42b4bf5c3eab5b0fe3e1187a6f9f942b410b8f1d45e75171b20b04e4d9ad.mov"></source></video>

# Used Phone stock

This module is used to check the availability of **Used Phones** across warehouses.

### Filter Options

You can filter the data by:

- Product
- Model
- Storage
- Other available attributes

### Availability View

The system displays the available quantity in the selected warehouses. Next to each quantity, an **“i” (info) button** provides a detailed breakdown:

- **Physical**: Quantity physically available in the warehouse.
- **Allocated**: Quantity scanned or reserved in orders, but not yet packed.
- **Committed**: Quantity scanned and packed in an order.
- **Booking**: Quantity reserved for an order where stock is insufficient, so it is kept on hold.

### Export Option

You can export the availability data to Excel by clicking the **“Export Product to Excel”** button.

  
<video controls="controls" height="394" width="788"><source src="https://mercantile-kb.s3.ap-southeast-1.amazonaws.com/OMS/Stock_report/e3993b3f676646b6a31766f530b2e45d1a2831d4454f4b949bca6fb52adfc38d3af23886966741c99d912b3dfed473bfd87f32b682934e3c82cf08fe3f6d92b9f10fa7f8.mov"></source></video>

# ALLOCATED DETAILS REPORT

- - This module is used to check whether products are **Allocated, Booked, or Committed** across warehouses.
        
        ### Filter Options
        
        You can filter the data by:
        
        
        - Product
        - Warehouse(s)
        
        ### Availability View
        
        The system displays the available quantity in the selected warehouses, along with a detailed stock breakdown:
        
        
        - **Physical**: Quantity physically available in the warehouse.
        - **Allocated**: Quantity scanned or reserved in orders, but not yet packed.
        - **Committed**: Quantity scanned and packed in an order.
        - **Booking**: Quantity reserved for an order where stock is insufficient, so it is kept on hold.
        
        ### Order-Level Details
        
        
        - By clicking the **“i” (info) button** next to the quantity, you can view the **order number and order details** where the product is Allocated, Committed, or Booked.
        - By clicking the **“i” button** next to the **order number**, you can see **all products in that order** along with their details.
        
        ---
    - <video controls="controls" height="394" width="788"><source src="https://mercantile-kb.s3.ap-southeast-1.amazonaws.com/OMS/Stock_report/d5b88622b582441783c0aebe943fe0b6c972c7a22cc44a1bbdd0ca2ea31c96d56f7c53feb062411d95d70d3cd7d3a6a8175b753aa54a443fa502ba1cb61f9dfdf778ce5b.mov"></source></video>
    -

# DXB DISTRIBUTION STOCKS

This module is used to check the availability of **Apple distribution products** across the Dubai subsidiary.

### Filter Options

- You can filter the data by **product**.

### Availability View

The system displays the available quantity in the **DAFZA** and **DCC** warehouses. Next to each quantity, an **“i” (info) button** provides a detailed stock breakdown:

- **Physical**: Quantity physically available in the warehouse.
- **Allocated**: Quantity scanned or reserved in orders, but not yet packed.
- **Committed**: Quantity scanned and packed in an order.
- **Booking**: Quantity reserved for an order where stock is insufficient, so it is kept on hold.

### Export Option

You can export the availability data to Excel by clicking the **“Export”** button.  
  
<video controls="controls" height="394" width="788"><source src="https://mercantile-kb.s3.ap-southeast-1.amazonaws.com/OMS/Stock_report/96bcff3e063b4a6bb59977239c191dfb153adb37d0404388bc850c7f3c6fd1a848ba3b9f30304cb8b49d16793fb3bb7b563630245d4d46f29149044f70588d39d5336c69.mov"></source></video>

# USED LIVE INVENTORY

This module is used to check the availability of **Used Live Inventory** across warehouses.

### Filter Options

You can filter the data by:

- Warehouse
- Model
- Storage
- Grade
- Color

### Availability View

Next to each product, the system displays detailed stock information, including:

- **Live Physical Inventory**: Quantity physically available in the warehouse.
- **In Transit**: Stock shipped from another warehouse but not yet received in the current warehouse.
- **Balance Quantity**: *(Live Physical Inventory + In Transit) – (Allocated + Committed)*
    
    > This represents the quantity that **is or will be available** in the warehouse.
- **Ready Stock**: *(Live Physical Inventory – (Allocated + Committed + Booked))*
    
    > This represents the quantity that is **immediately available for scanning**.
- **Allocated**: Quantity scanned or reserved in orders, but not yet packed.
- **Committed**: Quantity scanned and packed in an order.
- **Booking**: Quantity reserved for an order where stock is insufficient, so it is kept on hold.

### Order-Level Details

By clicking on a **product**, you can view the **orders** in which that product is Allocated, Committed, or Booked.  
  
<video controls="controls" height="394" width="788"><source src="https://mercantile-kb.s3.ap-southeast-1.amazonaws.com/OMS/Stock_report/dec240651e014153be524dcec0f6265cec3ad04948a0456da1f4b9e90eb95f9a5177e2d5967b49a780ac7974e17f3ee051d9a5a8c5204db6b3a2607b0fd30e3734e6495a.mov"></source></video>

# DISTRIBUTION LIVE INVENTORY

This module is used to check the availability of **Distribution Inventories** across warehouses.

### Filter Options

You can filter the data by:

- Warehouse
- Product / Model
- Storage
- Color

### Availability View

Next to each product, the system displays detailed stock information, including:

- **Live Physical Inventory**: Quantity physically available in the warehouse.
- **In Transit**: Stock shipped from another warehouse but not yet received in the current warehouse.
- **Balance Quantity**: *(Live Physical Inventory + In Transit) – (Allocated + Committed)*
    
    > Represents the quantity that **is or will be available** in the warehouse.
- **Ready Stock**: *(Live Physical Inventory – (Allocated + Committed + Booked))*
    
    > Represents the quantity that is **immediately available for scanning**.
- **Allocated**: Quantity scanned or reserved in orders, but not yet packed.
- **Committed**: Quantity scanned and packed in an order.
- **Booking**: Quantity reserved for an order where stock is insufficient, so it is kept on hold.

### Order-Level Details

By clicking on a **product**, you can view the **orders** in which that product is Allocated, Committed, or Booked.

  
<video controls="controls" height="394" width="788"><source src="https://mercantile-kb.s3.ap-southeast-1.amazonaws.com/OMS/Stock_report/fca2cf12789d45ea92010368bf5c8d1ccdcd5197a4684c06bd3a1f65ca5a57d0eefc0f7231b04777ad2f67c1d663542353ae71ee306f4b21a3c08d0a4262564799b2c1ef.mov"></source></video>