Advanced Inventory Management
Manage inventory across locations with structured receiving, issuing, and transaction history.
How to use this solution
Use this solution to manage the goods, materials, parts, and supplies your business keeps in inventory, including the movement of stock into and out of each location.
- 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.
- Goods receiving: Use Goods Receipts to record inventory received from a vendor. Posting a receipt updates the related Inventory Item quantities and records the movement.
- Goods issuing: Use Goods Issues to record inventory leaving a location. Posting an issue reduces the related Inventory Item quantities and records the movement.
- Inventory transaction history: Each posted receipt or issue creates an Inventory Transaction, providing a history of stock movements for each Inventory Item.
How the solution is organized
The solution is built around these connected business objects:
| Business object | What it represents | Information it contains |
|---|---|---|
| Item | A product, part, material, or supply | Name, SKU, item type, unit of measure, 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 |
| Vendor | The supplier associated with goods being received | Vendor name, contact information, address, payment terms, and status |
| Inventory Item | An Item stored at a specific Location | Item, location, stock quantities, reorder levels, and status |
| Goods Receipt | Inventory received into a Location | Vendor, item, location, received quantity, and other receipt information |
| Goods Issue | Inventory issued or removed from a Location | Item, location, issued quantity, and other issue information |
| Inventory Transaction | A stock movement created from a posted Goods Receipt or Goods Issue | The related Inventory Item, movement type, quantity, and transaction history |
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.
Included automations
This solution includes two managed automations:
| Automation | Runs when | Actions |
|---|---|---|
| GR Post Inventory | Inventory is posted from a Goods Receipt | Updates the related Inventory Item, adds the received quantity to stock, and creates an Inventory Transaction |
| GI Post Inventory | Inventory is posted from a Goods Issue | Updates the related Inventory Item, deducts the issued quantity from stock, and creates an Inventory Transaction |
These automations are included as part of the solution and cannot be edited.
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 a Vendor
Create records for the suppliers you receive inventory from.
Add information such as:
- Vendor name
- Contact information
- Address
- Payment terms
- Status
4. 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 used to track stock at that Location.
5. Receive Inventory
Create a Goods Receipt when stock arrives.
Select the appropriate Item, Location, and Vendor, enter the quantity received, and post the inventory.
The GR Post Inventory automation updates the Inventory Item and creates an Inventory Transaction.
6. Issue Inventory
Create a Goods Issue when stock leaves inventory.
Select the appropriate Item and Location, enter the quantity issued, and post the inventory.
The GI Post Inventory automation updates the Inventory Item and creates an Inventory Transaction.
Example
Suppose you stock ApexVision 27" Display Panels at the Northridge Distribution Center.
Create the following connected records:
| Quantity | Record type | Record |
|---|---|---|
| 1 | Item | ApexVision 27" Display Panel |
| 1 | Location | Northridge Distribution Center |
| 1 | Vendor | Northstar Display Supply |
| 1 | Inventory Item | ApexVision 27" Display Panel at Northridge Distribution Center |
The following stock movements can then be recorded:
| Event | What you do | Result |
|---|---|---|
| 10 displays arrive from the Vendor | Create and post a Goods Receipt for 10 units | The Inventory Item quantity increases by 10 and an Inventory Transaction records the receipt |
| 3 displays leave inventory | Create and post a Goods Issue for 3 units | The Inventory Item quantity decreases by 3 and an Inventory Transaction records the issue |
This provides both the current inventory position and a history of how stock moved.
Make it yours
Customize this solution by adding your own fields, views, forms, related records, and workflows to match the way your business manages inventory.
The included inventory posting automations are managed as part of the solution and cannot be edited.