🏭 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

Field
Description

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.

Field
Description

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 warehouses

  • A stock ledger entry is created for each consumed item with type: WIP Consumption


βœ… WIP Completion

Action: Mark as Complete

  • Changes status from in_progress to completed

  • 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 and Transfer 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