π Work In Progress (WIP)
π Overview
The Work In Progress (WIP) system in Concord CRM Inventory Module is designed to manage the transformation of raw materials (stocks) into finished goods. It tracks production stages, ensures FIFO-based raw material consumption, and updates the stock ledger accordingly.
ποΈ WIP Structure
π Basic Information
Product
Finished good to be created
Start Date
Date when the production process starts
End Date
Estimated or actual completion date
Status
in_progress
by default, changes to completed
after production
Note
Additional information about the production (textarea input)
Created By
User who created the WIP record
π₯ WIP Item Inputs
WIP requires selecting input materials (raw stocks) to consume for producing the final product.
Product(s)
Multiple stock items (raw materials) selected from current inventory
Quantity
Required quantity to consume for each item (β₯1)
Cost Price
Recorded from existing stock cost .
π Validation:
At least 1 item must be selected
Total available quantity must be sufficient across all warehouses
Consumption happens using FIFO from multiple warehouses if needed
βοΈ How WIP Works
1οΈβ£ Creating WIP
When a WIP is created:
Product, dates, note, and input items are selected
Stocks are immediately deducted using FIFO order (based on
created_at
) across warehousesA stock ledger entry is created for each consumed item with type:
WIP Consumption
β
WIP Completion
Action: Mark as Complete
Changes status from
in_progress
tocompleted
Prompts:
Quantity Filled: Quantity of finished goods produced
Optional Warehouse & Bin: Assign destination for finished goods
π Logic:
Finished goods are added to inventory
A stock ledger entry is created:
Type:
Transfer In
Reflects the creation of finished product
If warehouse/bin selected, product is placed there directly
π WIP Pages
π WIP List Page
π What you see:
Product (finished good)
Status (in_progress / completed)
Start and End Dates
Created By
Action buttons (View, Complete)
π WIP Detail Page
π What you see:
Basic WIP details
Input materials and consumed quantities
Ledger references
Completion info (quantity, location if assigned)
Notes and audit trail
β Key Features
π§Ύ Raw Material Consumption: Depletes inventory based on FIFO logic
π§ͺ Process Tracking: Logs production from start to finish
π·οΈ Flexible Assignment: Finished goods can be assigned to location immediately
π Stock Ledger Integration: All WIP movements are tracked in the ledger
π€ User Tracking: Creator and completer tracked
π Real-Time Inventory Impact: Immediate deduction from stock
π Business Rules
β Required Fields on Creation
Product (finished good)
Start Date
At least one WIP item (product + quantity)
Note
β
Validation Rules
Cannot create if requested quantity > total available stock across all warehouses
FIFO depletion logic must be respected
Completion requires valid quantity input
π Integration with Other Modules
π¦ Stock Management: Updates inventory during consumption and completion
π Stock Ledger: Auto-generates
WIP Consumption
andTransfer In
entriesποΈ Product Catalog: Ensures valid finished goods and raw materials
π€ User Management: Tracks responsibility
π Data Security
π‘οΈ Permission Based Access: Only authorized users can create or complete WIP
π Data Integrity: Transactions ensure accurate consumption and creation
π§Ύ Audit Trail: Full history of WIP actions and inventory impact
πΌ Common Use Cases
π
Daily Operations
Logging production of finished goods
Tracking material usage for each product
Assigning completed goods to storage
π Monthly/Quarterly Tasks
Production cost analysis
Raw material usage reports
Finished goods tracking by batch
Last updated