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 allWarehouses
Go to Inventory > Configuration > Warehouses. A default warehouse (WH) is created automatically.
Creating a Warehouse
- Click Create.
- Warehouse Name - e.g. "Main Warehouse", "East Coast DC", "Returns Center".
- Short Name - Abbreviation (e.g. MAIN, EAST, RET). Used in location names.
- Address - Physical address of the warehouse.
- Company - In multi-company setups.
- Routes - Default supply routes for this warehouse.
- Save. The warehouse automatically creates a location hierarchy: WH/Stock, WH/Input, WH/Output, WH/Scrap.
Location Types
| Type | Purpose |
|---|---|
| Physical (Internal) | Actual storage locations. Stock is tracked here. |
| View | Parent locations that group children. No stock directly at view locations. |
| Vendor Location | Virtual location representing goods not yet received. |
| Customer Location | Virtual location for delivered goods. |
| Production | Virtual location for goods in manufacturing. |
| Inventory Loss | Virtual location for inventory adjustments and scrap. |
Location Hierarchy Example
- WH (Warehouse, View)
- WH/Stock (Physical - main stock area)
- WH/Stock/Aisle-A (View)
- WH/Stock/Aisle-A/Shelf-01 (Physical)
- WH/Stock/Aisle-A/Shelf-02 (Physical)
- WH/Stock/Aisle-B (View)
- WH/Input (Physical - goods awaiting put-away)
- WH/Output (Physical - goods ready for dispatch)
- WH/Scrap (Physical - damaged/waste goods)
Multi-Warehouse Setup
Multiple warehouses share the same product catalog but track stock independently. Use routes to transfer stock between warehouses. Enable in Settings → "Multi-Warehouse".
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.
Inventory Counts
Go to Inventory > Operations > Inventory Adjustments.
Creating an Inventory Count
- Click Create.
- Location - Select the area to count.
- Inventory Date - When the count happens.
- Click Start Inventory - This locks the stock and pre-fills current quantities.
- Product lines appear with their current quantity.
- Enter the actual counted quantity in the Counted Quantity column.
- Leave Scrapped Quantity if some units are damaged.
- Click Apply All to post the adjustment.
Cyclic Counts
For ongoing cycle counting, enable in Settings → "Cycle Counting". Create a count per product or location on a regular schedule. Quickenerp groups all cycle counts for review & validation.
ABC Analysis
Categorize products by value:
- A - High-value, count more frequently (e.g. monthly).
- B - Mid-value, count quarterly.
- C - Low-value, count annually.
Set ABC category on the product form to automate cycle count frequency.
Inventory Adjustment Reporting
After applying an adjustment, the difference is recorded:
- Positive variance - Stock increases, value is added.
- Negative variance - Stock decreases, value is removed (inventory loss).
Go to Inventory > Reporting > Inventory Analysis to see adjustment history.