Production Execution Controller Documentation

File: /controllers/productionExecutionController.php

Purpose: Manages manufacturing execution, BOM consumption, production output, and inventory updates

Last Updated: December 19, 2024

Total Functions: 17

Lines of Code: ~1,881

---

📋 Overview

The Production Execution Controller is the core component for executing manufacturing processes in the ERP system. It handles:

• Production execution based on task orders
• Bill of Materials (BOM) consumption tracking
• Raw material inventory deduction during production
• Finished goods output tracking
• Waste/damaged product management during production
• Inventory updates with buy price history
• Production costing calculations
• Daily accounting entries for manufacturing

Primary Functions

✅ Execute production orders from task orders
✅ Consume raw materials per BOM formulas
✅ Track finished goods output
✅ Manage production waste
✅ Update inventory quantities
✅ Calculate production costs
✅ Generate accounting entries
✅ Handle buy price history for FIFO/LIFO costing
✅ Support size/color variants in production

Related Controllers

• productionOrderController.php - Production order management
• taskOrderController.php - Task order creation
• productController.php - Product and BOM management
• storeController.php - Warehouse management
• storedetailController.php - Inventory management
• simpleManufactureSettingsController.php - Manufacturing settings
• productionEquationController.php - BOM equations
• dailyentryController.php - Accounting entries

---

🗄️ Database Tables

Primary Tables (Direct Operations)

Table Name	Purpose	Key Columns
`productionexecution`	Main production execution records	`id`, `taskorderid`, `num`, `notes`, `executiondate`
`productionexecutionproduct`	Raw materials consumed	`id`, `productionexecutionid`, `productid`, `quantity`, `actualquantity`
`productionexecutionoutput`	Finished goods produced	`id`, `productionexecutionid`, `productid`, `num`
`productionexecutionwaste`	Production waste/scrap	`id`, `productionexecutionid`, `productid`, `num`
`taskorder`	Source production orders	`taskorderid`, `name`, `num`, `startdate`, `enddate`
`taskorderproducts`	Task order materials list	`id`, `taskorderid`, `productid`, `quantity`

### Related Tables (Inventory & Costing)

Table Name	Purpose	Key Columns
`storedetail`	Current inventory quantities	`storedetailid`, `storeid`, `productid`, `productquantity`
`storereport`	Inventory movement history	`storereportid`, `productid`, `storeid`, `productquantity`, `processname`
`buypriceshistorybook`	Purchase price tracking	`id`, `storeid`, `productid`, `buyprice`, `buyquantity`, `sellquantity`
`sizecolorstoredetail`	Size/color variant inventory	`id`, `productid`, `sizeid`, `colorid`, `quantity`
`productionrate`	BOM header	`productionRateId`, `ratename`, `finalproductid`
`productionrateproduct`	BOM line items	`id`, `productionRateId`, `productid`, `quantity`

### Reference Tables

Table Name	Purpose	Key Columns
`product`	Product master data	`productId`, `productName`, `productBuyPrice`, `productSellPrice`
`store`	Warehouse/location master	`storeid`, `storeName`
`simplemanufacturesetting`	Manufacturing configuration	`id`, `storeid`, `reducestoreamount`

---

🔧 Key Functions

1. add() - Create Production Execution

Line: 549

Purpose: Creates a new production execution record from task order

Parameters:

• $_POST['taskorderid'] - Source task order ID
• $_POST['executiondate'] - Production execution date
• $_POST['notes'] - Production notes
• $_POST['storeid'] - Target warehouse for production

Process Flow:

┌─ Start Production Execution ─┐

▼

└─ Create storereport entry

▼

Return: Redirects to success/error page

---

2. executeAdd() - Process Material Consumption

Line: 702

Purpose: Handles raw material deduction from inventory during production execution

Parameters:

• Task order materials from database
• Production quantity from form
• Store ID for inventory updates

Process Flow:

┌─ Material Consumption ─┐

▼

└─ Generate storereport entry

▼

Code Example:

// Calculate material consumption based on BOM
$requiredQty = $productionQty * $bomQty * $conversionFactor;

// Reduce inventory
$newInventory = decreaseProductQuantity($storeDetailId, $currentQty, $requiredQty);

// Update buy price history for costing
getBuyPriceFromAndHandleBuyPricesHistoryBook($storeId, $productId, $sizeId, $colorId, $buyPrice, $requiredQty, 0);

---

3. execute() - Complete Production Process

Line: 1074

Purpose: Completes production by adding finished goods to inventory

Parameters:

• $_POST['productionexecutionid'] - Production execution ID
• $_POST['output_*'] - Output quantities for each product
• $_POST['waste_*'] - Waste quantities for each product

Process Flow:

┌─ Complete Production ─┐

▼

└─ Calculate new mean buy price

▼

└─ Record waste in system

▼

---

4. update() - Modify Production Execution

Line: 926

Purpose: Updates existing production execution with new quantities

Process Flow:

┌─ Update Production ─┐

▼

---

5. delete() - Remove Production Execution

Line: 1442

Purpose: Deletes production execution and reverses all inventory effects

Process Flow:

┌─ Delete Production ─┐

▼

└─ Create reversal storereport

▼

---

6. getBuyPriceFromAndHandleBuyPricesHistoryBook() - FIFO Costing

Line: 1746

Purpose: Manages buy price history for FIFO/LIFO inventory costing

Parameters:

• $storeId - Warehouse ID
• $productid - Product ID
• $sizeid, $colorid - Variant identifiers
• $productBuyPrice - Current buy price
• $soldQuantity - Quantity being consumed
• $type - 0=consumption, 1=return

Process Flow:

┌─ FIFO Costing Process ─┐

▼

└─ Remove fully consumed lots

▼

---

7. doInventoryDailyEntry() - Accounting Integration

Line: 1849

Purpose: Creates daily accounting entries for production costs

Parameters:

• $productionExecution - Production execution object

Process Flow:

┌─ Accounting Entry ─┐

▼

---

🔄 Business Logic Flow

Production Execution Workflow

┌─ Task Order Created ─┐

▼

┌─ Material Consumption Phase ─┐

1Get BOM for product

2Calculate required materials

3Check inventory availability

4Reduce raw material stock

5Update buy price history

6Record consumption

└─────────────────────────────┘

▼

┌─ Production Phase ─┐

1Execute manufacturing

2Record actual output

3Track waste/scrap

4Quality control check

└─────────────────────────┘

▼

┌─ Output Recording Phase ─┐

1Add finished goods to inventory

2Calculate production cost

3Update product mean buy price

4Generate accounting entries

└──────────────────────────────────┘

BOM Consumption Formula

Required Quantity = Production Qty × BOM Qty × Unit Conversion Factor

Example:
- Produce 100 units of Product A
- BOM requires 2.5kg Material X per unit
- Material X stored in grams (conversion factor = 1000)
- Required = 100 × 2.5 × 1000 = 250,000 grams

---

⚠️ Common Issues

1. Inventory Shortage During Production

Symptoms: Production fails with insufficient stock error

Causes:

• BOM consumption exceeds available inventory
• Incorrect unit conversion factors
• Concurrent production orders

Solutions:

• Implement inventory reservation system
• Add stock validation before production start
• Verify unit conversion in product setup

2. Buy Price History Inconsistencies

Symptoms: Incorrect cost calculations, negative inventory values

Causes:

• FIFO queue corruption during concurrent operations
• Manual inventory adjustments without price history updates

Solutions:

• Add database transactions for atomic operations
• Rebuild buy price history after manual adjustments
• Implement inventory locking during production

3. BOM Formula Calculation Errors

Symptoms: Wrong material consumption amounts

Causes:

• Missing or incorrect production rate equations
• Unit conversion factor mismatches
• Formula version control issues

Solutions:

• Validate BOM formulas before production
• Add audit trail for BOM changes
• Implement formula testing environment

---

🔗 Dependencies

Required Files

• ../public/impOpreation.php - Core operations
• ../public/config.php - Database configuration
• ../public/include_dao.php - Data access objects
• dailyentryfun.php - Accounting entry functions

Required DAOs

• ProductionexecutionDAO - Production execution data
• TaskorderDAO - Source task orders
• ProductionrateDAO - BOM formulas
• StoredetailDAO - Inventory management
• BuypriceshistorybookDAO - Costing history
• StorereportDAO - Inventory audit trail

Required Session Variables

• $_SESSION['userid'] - Current user ID
• $_SESSION['storenegative'] - Allow negative inventory flag

External Dependencies

• Smarty templating engine
• Daily entry accounting system
• Inventory management system
• Product variant (size/color) system

---

🧮 Manufacturing Formulas

Cost Calculation

// Weighted average cost per unit
$newMeanPrice = (($oldQuantity × $oldMeanPrice) + ($newQuantity × $newPrice)) / ($oldQuantity + $newQuantity);

// Total production cost
$totalCost = $materialCost + $laborCost + $overheadCost;

// Unit production cost  
$unitCost = $totalCost / $outputQuantity;

Inventory Valuation Methods

• FIFO (First In, First Out): Oldest purchase prices used first for consumption
• Weighted Average: Recalculated after each purchase/production
• Standard Cost: Predetermined costs updated periodically

---

Manufacturing Concepts Covered: Production Execution, BOM Management, Material Consumption, FIFO Costing, Inventory Valuation, Production Costing, Waste Tracking, Quality Control Integration, Accounting Integration

📚 ERP Docs

ProductionExecution Documentation

Production Execution Controller Documentation

📋 Overview

Primary Functions

Related Controllers

🗄️ Database Tables

Primary Tables (Direct Operations)

🔧 Key Functions

1. add() - Create Production Execution

2. executeAdd() - Process Material Consumption

3. execute() - Complete Production Process

4. update() - Modify Production Execution

5. delete() - Remove Production Execution

6. getBuyPriceFromAndHandleBuyPricesHistoryBook() - FIFO Costing

7. doInventoryDailyEntry() - Accounting Integration

🔄 Business Logic Flow

Production Execution Workflow

BOM Consumption Formula

⚠️ Common Issues

1. Inventory Shortage During Production

2. Buy Price History Inconsistencies

3. BOM Formula Calculation Errors

🔗 Dependencies

Required Files

Required DAOs

Required Session Variables

External Dependencies

🧮 Manufacturing Formulas

Cost Calculation

Inventory Valuation Methods