Inventory Management
Track what you have, where it is, and when it needs to be replenished.
How to use this solution
Use this solution to track and manage the goods, materials, parts, and supplies your business keeps in inventory.
- Real-time stock tracking: Track quantity on hand, quantity reserved, quantity available, inventory status, and the Location where stock is stored.
- Reorder management: Set minimum stock, maximum stock, and reorder levels to identify inventory that needs attention.
- Purchasing and supplier coordination: Connect inventory with your purchasing process to replenish Items when additional stock is required.
How the solution is organized
The solution is built around three connected business objects:
| Business object | What it represents | Information it contains |
|---|---|---|
| Item | A product, part, material, or supply | Product image, item name, SKU, item type, unit of measure, currency, purchase price, sales price, and status |
| Location | A warehouse, facility, stock room, or other place where inventory is stored | Location name, image, location type, full address, and status |
| Inventory Item | An Item stored at a specific Location | Item, location, minimum stock, maximum stock, reorder level, stock quantities, and status |
An Inventory Item connects one Item to one Location and tracks the inventory quantities for that combination. The same Item can have separate Inventory Item records in different warehouses, with each Location maintaining its own quantities and reorder levels.
Getting started
1. Create an Item
Create a record for each product, part, material, or supply you want to track.
Add information such as:
- Product image
- Item name
- SKU
- Item type
- Unit of measure
- Currency
- Purchase price
- Sales price
- Status
2. Create a Location
Create a record for each place where inventory is stored.
Add information such as:
- Location name
- Image
- Location type
- Full address
- Status
3. Create an Inventory Item
Create an Inventory Item to connect an Item with a Location.
Select the Item and Location, then enter:
- Minimum stock
- Maximum stock
- Reorder level
- Quantity on hand
- Quantity reserved
- Status
The Inventory Item becomes the operational record you use to manage stock at that Location.
Example
Suppose you stock Stainless Steel Bolt M8 in two warehouses.
Create the following records:
| Quantity | Record type | Record |
|---|---|---|
| 1 | Item | Stainless Steel Bolt M8 |
| 2 | Locations | Austin Warehouse and Dallas Warehouse |
Connect the Item to each Location by creating two Inventory Items:
| Item | Location |
|---|---|
| Stainless Steel Bolt M8 | Austin Warehouse |
| Stainless Steel Bolt M8 | Dallas Warehouse |
Each Inventory Item can maintain its own stock quantities, status, and reorder levels.
Make it yours
This solution is designed to be used as-is or customized to fit your business.
Add your own fields, views, forms, related records, workflows, and automations to match the way your business manages inventory.