Skip to main content

Inventory On-Hand

The Inventory On-Hand Dashboard provides insights into current stock levels, product valuation, and inventory movement. This dashboard helps businesses manage inventory efficiently, track stock availability, and optimize procurement decisions.

Key Metrics at a Glance:​

  • Valuation: The total value of inventory on hand.
  • Unit Cost: The average cost per unit of inventory.
  • Quantity In: The total quantity of new inventory received.
  • Quantity Out: The total quantity of inventory issued or sold.
  • Quantity On Hand: The current stock available.
  • Quantity Invoiced: The total quantity of inventory that has been invoiced.

Visual Components:​

  • Inventory Value by Product Group: A pie chart displaying the distribution of inventory value across different product categories.
  • On-Hand Inventory Quantity (by Warehouse): A bar chart showing the inventory distribution across multiple warehouses.
  • Detailed Inventory Item Listing / Valuation: A detailed table displaying:
    • Item Groups
    • Unit Cost
    • Quantity In, Out, and On Hand
    • Invoiced Quantity
    • Inventory Valuation (Average, Latest, and Manual)
    • Latest Cost

Benefits of this Dashboard:​

  • Stock Level Monitoring: Provides real-time visibility into available inventory.
  • Cost Control: Tracks unit costs and valuation to manage procurement efficiently.
  • Warehouse Optimization: Helps in assessing stock distribution across multiple locations.
  • Inventory Movement Analysis: Monitors stock inflows and outflows to identify trends.
  • Data-Driven Decision-Making: Supports better purchasing and restocking strategies.

Filtering​

You can filter the dashboards using these filtering panels:

  • Company
  • Warehouse
  • Item Group
  • Item
  • Supplier Group Code
  • Supplier