Skip to main content

Stock Report Multi Uoms

📦 Stock Report – Multi UOMs​

The Stock Report – Multi UOMs provides a comprehensive view of inventory quantities in multiple Units of Measure (UOMs) for each product across warehouses and locations. This is especially useful for businesses that buy, store, and sell the same product in different units (e.g., cartons, boxes, pieces, kilograms, liters).

Instead of manually converting quantities, this report automatically displays stock levels in all relevant UOMs configured for each item, ensuring accuracy and saving time.

🎯 Purpose of the Report​

  • To monitor stock levels across multiple UOMs simultaneously.

  • To support sales and purchase teams in quoting and ordering in their preferred UOM.

  • To reduce errors in manual unit conversion.

  • To enhance warehouse and inventory management for products with varied packaging or measurement systems.

📌 Key Data Fields​

FieldDescription
Item Code / SKUUnique identifier for the product.
Item NameName or description of the product.
CategoryProduct category or type.
Warehouse / LocationStorage location of the item.
Primary UOM StockQuantity in the primary unit of measure (e.g., Pieces).
Alternate UOM Stock 1Quantity in the first alternate unit of measure (e.g., Cartons).
Alternate UOM Stock 2Quantity in the second alternate unit of measure (e.g., Kilograms).
Opening Stock (UOM)Quantity available at the start of the selected period.
Stock In (UOM)Quantity received during the period in each UOM.
Stock Out (UOM)Quantity issued/sold in each UOM.
Closing Stock (UOM)Quantity available at the end of the period in each UOM.
Conversion RateThe rate between each UOM and the primary UOM.

🔍 Filter & Search Options​

  • By Date / Date Range

  • By Warehouse / Location

  • By Item Category

  • By Item Code / Name

  • By Specific UOM

📊 Insights Provided​

  • Real-time stock visibility in all relevant units.

  • Easy reference for sales, purchases, and warehouse staff without conversion mistakes.

  • Clear view of stock movement in primary and alternate units.

📤 Export & Integration​

  • Export as Excel, CSV, or PDF for sharing with different departments.

  • Integrated with Sales Orders, Purchase Orders, and Stock Transfers to ensure UOM consistency.

  • Compatible with pricing in multiple UOMs, so teams can check stock before quoting.

✅ Benefits​

  • Eliminates manual conversion errors.

  • Improves cross-department communication when different teams use different UOMs.

  • Saves time by providing all UOM data in one place.

  • Enhances decision-making for bulk purchases or retail sales.

📈 Example Layout​

Item CodeItem NameWarehouseStock (Pieces)Stock (Cartons)Stock (Kg)Conversion Rate (Carton → Pieces)Conversion Rate (Kg → Pieces)
ITM-001Rice BagWH-015005010001 Carton = 10 Pcs1 Kg = 0.5 Pcs
ITM-002Water BottleWH-0224020-1 Carton = 12 Pcs-