Inventory
This course covers the full Inventory module in Quickenerp. Learn how to set up warehouses, manage stock operations (receipts, deliveries, internal transfers), track products with lots/serials, configure replenishment rules, run physical counts, and understand inventory valuation methods.
| Responsible | System |
|---|---|
| Last Update | 07/21/2026 |
| Completion Time | 5 days 8 hours |
| Members | 1 |
Inventory Valuation
Configure on the Product Category. Go to Inventory > Configuration > Product Categories, select a category, edit the Inventory Valuation section.
Valuation Methods
| Method | Description |
|---|---|
| Standard Price | Fixed cost assigned to the product. No automatic recalculation. Variance is tracked. |
| Average Cost (AVCO) | Weighted average of all purchases. Updated on each receipt. |
| FIFO (First In First Out) | Oldest stock cost is used first. Each unit has its own cost layer. |
Accounting Valuation
| Setting | Behaviour |
|---|---|
| Manual / Periodic | No automatic journal entries. Run inventory adjustments to post valuation. |
| Automated | Every stock move creates accounting entries automatically. Requires a dedicated Inventory Valuation account. |
Inventory Valuation Report
Go to Inventory > Reporting > Inventory Valuation. See the current value of each product at each location. Columns: Quantity, Unit Cost, Total Value. Also shows layered cost history.
Stock Moves as Accounting Entries
With Automated Valuation, each stock move generates:
- Receipt: Debit Inventory, Credit Stock Input (or directly Credit Vendor if not separate).
- Delivery: Debit Cost of Goods Sold (COGS), Credit Inventory.
- Scrap: Debit Inventory Loss, Credit Inventory.
Review entries via: Product → Accounting → Journal Entries.
Inventory Overview
View allInventory Valuation
Configure on the Product Category. Go to Inventory > Configuration > Product Categories, select a category, edit the Inventory Valuation section.
Valuation Methods
| Method | Description |
|---|---|
| Standard Price | Fixed cost assigned to the product. No automatic recalculation. Variance is tracked. |
| Average Cost (AVCO) | Weighted average of all purchases. Updated on each receipt. |
| FIFO (First In First Out) | Oldest stock cost is used first. Each unit has its own cost layer. |
Accounting Valuation
| Setting | Behaviour |
|---|---|
| Manual / Periodic | No automatic journal entries. Run inventory adjustments to post valuation. |
| Automated | Every stock move creates accounting entries automatically. Requires a dedicated Inventory Valuation account. |
Inventory Valuation Report
Go to Inventory > Reporting > Inventory Valuation. See the current value of each product at each location. Columns: Quantity, Unit Cost, Total Value. Also shows layered cost history.
Stock Moves as Accounting Entries
With Automated Valuation, each stock move generates:
- Receipt: Debit Inventory, Credit Stock Input (or directly Credit Vendor if not separate).
- Delivery: Debit Cost of Goods Sold (COGS), Credit Inventory.
- Scrap: Debit Inventory Loss, Credit Inventory.
Review entries via: Product → Accounting → Journal Entries.
The Inventory Module
The Inventory module manages stock across warehouses. It integrates with Sales (delivery orders), Purchases (receipts), Manufacturing (raw materials & finished goods), and Accounting (valuation).
Core Concepts
| Concept | Model | Description |
|---|---|---|
| Warehouse | stock.warehouse | A physical location where stock is stored. Can have sub-locations (zones, aisles, bins). |
| Location | stock.location | A specific place within a warehouse (e.g. Row A, Shelf 3). Locations form a hierarchical tree. |
| Product | product.product | Items tracked in inventory. Type must be Storable for full tracking. |
| Stock Move | stock.move | A movement of products from one location to another. The atomic unit of inventory. |
| Picking | stock.picking | A group of stock moves. Types: Receipt, Delivery, Internal Transfer, Manufacturing Order. |
| Reordering Rule | stock.warehouse.orderpoint | Min/max stock trigger. Auto-creates replenishment when stock falls below minimum. |
| Route | stock.route | Defines the supply chain path: Buy, Manufacture, Dropship, Cross-Dock, etc. |
| Lot/Serial | stock.lot | Traceability: Lot numbers for batches, Serial numbers for individual units. |
Menu Structure
- Operations - Receipts, Delivery Orders, Internal Transfers, Manufacturing Orders.
- Master Data - Products, Reordering Rules, Inventory Adjustments.
- Traceability - Lots/Serial Numbers, Product Moves.
- Configuration - Settings, Warehouses, Locations, Routes, Product Categories.
- Reporting - Inventory Analysis, Inventory Valuation, Stock Forecast.
Reordering Rules
Go to Inventory > Master Data > Reordering Rules. Auto-trigger replenishment when stock drops below a threshold.
Creating a Reordering Rule
- Click Create.
- Product - Select the product to replenish.
- Location - The warehouse location (typically WH/Stock).
- Minimum Quantity - When stock reaches this level, trigger reorder.
- Maximum Quantity - Replenish up to this level.
- Multiple Quantity - Order in multiples (e.g. case of 12).
- Lead Time - Days from order to receipt (overrides product lead time).
- Route - Buy, Manufacture, or Internal Transfer.
- Save.
How the Replenishment Engine Works
- The scheduled action "Reordering Rules" runs (every few hours or daily).
- For each rule where virtual stock (forecasted) < minimum, a replenishment is created.
- The replenishment follows the product's route (Buy → PO, Manufacture → MO).
- The order quantity is max - forecasted (rounded to multiple quantity).
Virtual / Forecasted Stock
Quantity On Hand (QOH) - Physically in stock.
Forecasted Quantity - QOH + incoming - outgoing. This is what triggers reordering.
Manual Replenishment
Go to Inventory > Operations > Replenishment. View all products needing replenishment. You can:
- Click Order Once to create an immediate order.
- Click Create Reordering Rule for ongoing automation.