Inventory Item

The inventory record for an Item at a specific location, warehouse, bin, or condition.

Manage Inventory Item Records in AnyDB

The Inventory Item business object represents the inventory record for an Item at a specific location, warehouse, bin, or condition. It provides a central place to track quantities, stock thresholds, location, status, and related inventory transactions.

Description

Use the Inventory Item object to manage the stock position of an Item at a specific Location. It can connect inventory to the underlying Item and Location records, track on-hand, reserved, and available quantities, maintain minimum and maximum stock levels, define a reorder point, and automatically indicate the current stock status.

Included Fields

Inventory Item

  • Inventory ID
  • Inventory Status
  • Item Reference
  • Item Name
  • SKU
  • UOM
  • Image

Location

  • Location Reference
  • Location Name
  • Bin

Inventory Quantities

  • Quantity On Hand
  • Quantity Reserved
  • Quantity Available

Stock Levels

  • Minimum Stock
  • Maximum Stock
  • Reorder Point
  • Status

Other

  • Notes

Common Uses

  • Stock Tracking: Maintain inventory quantities for an Item at a specific location.
  • Availability Tracking: Monitor on-hand, reserved, and available quantities.
  • Replenishment Planning: Define minimum stock levels and reorder points.
  • Location Inventory: Track the same Item independently across different locations or bins.
  • Inventory Monitoring: Identify no-stock, low-stock, reorder, and in-stock conditions.
  • Transaction History: Review inventory transactions associated with the inventory record.

Related Business Objects

Inventory

Procurement

Operations

Assets

Included Features

  • Automatic Inventory ID generation
  • Item reference
  • Item name lookup from the referenced Item
  • SKU lookup from the referenced Item
  • Unit of measure lookup from the referenced Item
  • Item image lookup from the referenced Item
  • Location reference
  • Location name lookup from the referenced Location
  • Bin tracking
  • Inventory status tracking
  • Quantity on hand tracking
  • Quantity reserved tracking
  • Automatic available quantity calculation
  • Minimum and maximum stock levels
  • Reorder point tracking
  • Automatic stock status calculation
  • Stock status indicators for No Stock, Low Stock, Reorder, and In Stock
  • Related Inventory Transaction listing
  • Rich text notes