Production Costing & Analysis

Overview

• What you’ll learn:
  • The different costing methods in iDempiere: Standard Cost, Average Invoice, Average PO, FIFO, LIFO, Last Invoice, and Last PO
  • How to query and manage product costs using the MCost API — getCurrentCost(), getSeedCosts(), and weighted average calculations
  • How MCostDetail provides transaction-level cost tracking linked to source documents for audit trails
  • How the IndentedBOM process performs multi-level BOM cost rollup across all component levels
  • How costs flow through the production lifecycle when MProduction.completeIt() executes
• Prerequisites: Lessons 24–25 and Lesson 35 — Production Overview, Inventory & Warehouse Management, Advanced Production & BOM Management
• Estimated reading time: 22 minutes

Introduction

Understanding the cost of production is fundamental to profitability analysis, pricing decisions, and financial reporting. An ERP system must not only track what was produced and consumed, but calculate what it cost — at every level of the bill of materials, using the organization’s chosen costing methodology.

iDempiere’s costing system is built around three core classes: MCost (product cost records), MCostDetail (transaction-level cost entries), and MCostElement (cost type definitions). The IndentedBOM process brings these together for multi-level BOM cost analysis. In this lesson, you’ll learn how these components work together to track, calculate, and report production costs.

Costing Methods

iDempiere supports multiple costing methods, configured at the Accounting Schema level. Each method determines how the CurrentCostPrice in MCost is calculated and maintained.

Available Methods

MCostElement — Cost Type Definitions

Each cost record is associated with a MCostElement that defines what type of cost it represents:

• Material: Raw material and component costs
• Labor: Direct labor costs
• Burden (Overhead): Factory overhead and indirect manufacturing costs (machine depreciation, factory utilities, supervision)
• Outside Processing: Costs for operations performed by external vendors

The combination of costing method and cost element allows iDempiere to maintain detailed cost breakdowns — for example, tracking material cost using FIFO while tracking labor cost as a standard cost.

MCost API: Querying Product Costs

The MCost class provides the primary interface for accessing product cost information. Each MCost record is uniquely identified by a composite key: Product + ASI + Organization + Accounting Schema + Cost Type + Cost Element.

Key Properties

Querying Current Cost

// Get the current cost for a product
MProduct product = MProduct.get(ctx, productId);
BigDecimal currentCost = MCost.getCurrentCost(
    product,
    0,          // ASI (0 = aggregate across all lots)
    trxName);
System.out.println("Current cost: " + currentCost);

// Get cost for a specific organization
BigDecimal orgCost = MCost.getCurrentCost(
    product,
    orgId,
    0,          // ASI
    trxName);

// Get seed costs (initial/standard costs)
BigDecimal seedCost = MCost.getSeedCosts(
    product,
    0,          // ASI
    new Timestamp(System.currentTimeMillis()),
    trxName);

// Get last invoice price
BigDecimal lastInvoicePrice = MCost.getLastInvoicePrice(
    product,
    0,          // C_BPartner_ID (0 = any vendor)
    trxName);

// Get last PO price
BigDecimal lastPOPrice = MCost.getLastPOPrice(
    product,
    orgId,
    trxName);

Updating Cost Records

// Get the MCost record for modification
MCost cost = MCost.get(product, 0, // ASI
    acctSchema, orgId, costElementId, trxName);

if (cost != null) {
    // Add cost and quantity (updates weighted average internally)
    cost.add(amount, quantity);
    cost.saveEx();

    // Or set weighted average directly
    cost.setWeightedAverage(totalAmount, totalQuantity);
    cost.saveEx();

    System.out.println("Updated cost: " + cost.getCurrentCostPrice());
}

Cost Detail Tracking with MCostDetail

MCostDetail provides the transaction-level audit trail for all cost changes. Every time a cost-affecting transaction occurs — receiving goods, issuing materials, completing production — a cost detail record is created linking the cost change to its source document.

MCostDetail Structure

// Query cost details for a specific product
String sql = "SELECT cd.Amt, cd.Qty, cd.Created, "
    + "cd.M_InOutLine_ID, cd.C_OrderLine_ID, cd.M_ProductionLine_ID "
    + "FROM M_CostDetail cd "
    + "WHERE cd.M_Product_ID = ? AND cd.C_AcctSchema_ID = ? "
    + "ORDER BY cd.Created DESC";

PreparedStatement pstmt = DB.prepareStatement(sql, trxName);
pstmt.setInt(1, productId);
pstmt.setInt(2, acctSchemaId);
ResultSet rs = pstmt.executeQuery();

while (rs.next()) {
    BigDecimal amt = rs.getBigDecimal("Amt");
    BigDecimal qty = rs.getBigDecimal("Qty");
    Timestamp created = rs.getTimestamp("Created");

    String source = "Unknown";
    if (rs.getInt("M_ProductionLine_ID") > 0)
        source = "Production";
    else if (rs.getInt("M_InOutLine_ID") > 0)
        source = "Receipt/Shipment";
    else if (rs.getInt("C_OrderLine_ID") > 0)
        source = "Purchase Order";

    System.out.println(created + " | " + source
        + " | Amt=" + amt + " | Qty=" + qty);
}
DB.close(rs, pstmt);

Multi-Level BOM Cost Rollup with IndentedBOM

The IndentedBOM process is the tool for analyzing costs across all levels of a product’s BOM. It recursively expands the BOM, calculates component costs at each level, and writes the results to the T_BOM_Indented temporary table.

IndentedBOM Parameters

How IndentedBOM Works

1. Reads the product’s master BOM
2. For each BOM line, retrieves the component’s current cost from MCost
3. Calculates extended cost: QtyBOM × CurrentCostPrice
4. If a component has its own BOM, recursively expands one level deeper
5. Writes each level to T_BOM_Indented with level indicators
6. Accumulates total cost across all levels

Implementing a Custom BOM Cost Calculator

While IndentedBOM handles the standard cost rollup, you may need custom cost calculations. Here’s how to implement a recursive BOM cost calculator using the iDempiere API:

public class BOMCostCalculator {

    public static class CostBreakdown {
        public String productName;
        public int level;
        public BigDecimal qtyRequired;
        public BigDecimal unitCost;
        public BigDecimal extendedCost;

        public CostBreakdown(String name, int lvl, BigDecimal qty,
                BigDecimal cost, BigDecimal extended) {
            this.productName = name;
            this.level = lvl;
            this.qtyRequired = qty;
            this.unitCost = cost;
            this.extendedCost = extended;
        }
    }

    /**
     * Recursively calculate BOM cost.
     */
    public List<CostBreakdown> calculateCost(Properties ctx,
            int productId, BigDecimal qty, String trxName) {

        List<CostBreakdown> breakdown = new ArrayList<>();
        MProduct product = MProduct.get(ctx, productId);
        MPPProductBOM bom = MPPProductBOM.getDefault(product, trxName);

        if (bom != null) {
            expandCost(ctx, bom, qty, 0, breakdown, trxName);
        }
        return breakdown;
    }

    private void expandCost(Properties ctx, MPPProductBOM bom,
            BigDecimal parentQty, int level,
            List<CostBreakdown> breakdown, String trxName) {

        MPPProductBOMLine[] lines = bom.getLines();

        for (MPPProductBOMLine line : lines) {
            MProduct component = MProduct.get(ctx, line.getM_Product_ID());
            BigDecimal compQty = line.getQtyBOM().multiply(parentQty);

            // Check if this is a phantom that should be expanded
            if (line.isPhantom() && component.isBOM()) {
                // Expand phantom — don't add cost for phantom itself
                MPPProductBOM subBOM = MPPProductBOM.getDefault(
                    component, trxName);
                if (subBOM != null) {
                    expandCost(ctx, subBOM, compQty, level + 1,
                        breakdown, trxName);
                }
            } else {
                // Leaf component — get its cost
                BigDecimal unitCost = MCost.getCurrentCost(
                    component, 0, trxName);
                BigDecimal extCost = compQty.multiply(unitCost);

                breakdown.add(new CostBreakdown(
                    component.getName(), level,
                    compQty, unitCost, extCost));
            }
        }
    }

    /**
     * Sum all component costs.
     */
    public BigDecimal getTotalCost(List<CostBreakdown> breakdown) {
        return breakdown.stream()
            .map(b -> b.extendedCost)
            .reduce(BigDecimal.ZERO, BigDecimal::add);
    }
}

// Usage:
BOMCostCalculator calc = new BOMCostCalculator();
List<CostBreakdown> breakdown = calc.calculateCost(
    ctx, finishedProductId, new BigDecimal("100"), trxName);

System.out.println("=== BOM Cost Analysis ===");
for (CostBreakdown cb : breakdown) {
    String indent = "  ".repeat(cb.level);
    System.out.printf("%s%s: qty=%.2f × $%.4f = $%.2f%n",
        indent, cb.productName,
        cb.qtyRequired, cb.unitCost, cb.extendedCost);
}
System.out.printf("TOTAL: $%.2f%n", calc.getTotalCost(breakdown));

Production Cost Flow

When MProduction.completeIt() executes, costs flow through the system:

Component Consumption

For each component consumption line (negative MovementQty):

1. The component’s MCost.CurrentQty is decreased
2. An MCostDetail record is created with a negative amount (cost relief)
3. For average costing, the weighted average price may be recalculated
4. For FIFO/LIFO, the appropriate cost layer is consumed

Finished Product Receipt

For the end-product line (positive MovementQty):

1. The finished product’s MCost.CurrentQty is increased
2. The cost is calculated as the sum of consumed component costs
3. An MCostDetail record is created with the production cost
4. For standard costing, any variance between standard and actual cost is posted to variance accounts

Standard Cost Variance

When using standard costing, the actual production cost (sum of component actual costs) may differ from the product’s standard cost. This difference is posted as a Production Variance in the accounting entries:

Production Variance = Actual Cost – Standard Cost

A positive variance (unfavorable) means actual costs exceeded standard; a negative variance (favorable) means actual costs were lower. Monitoring these variances helps identify cost inefficiencies, unexpected price changes in components, or the need to update standard costs.

Key Takeaways

• Costing Methods (Standard, Average, FIFO, LIFO, Last Price) determine how CurrentCostPrice is maintained in MCost. The method is configured at the Accounting Schema level.
• MCost provides static methods (getCurrentCost(), getSeedCosts(), getLastInvoicePrice()) for querying costs, and instance methods (add(), setWeightedAverage()) for updating them.
• MCostDetail creates an audit trail linking every cost change to its source document (receipt, invoice, production, movement).
• IndentedBOM performs multi-level cost rollup by recursively expanding BOMs and calculating component costs at each level.
• Production cost flow decreases component costs and increases finished product costs. Standard costing captures variances between standard and actual costs for financial analysis.

What’s Next

You have now completed the Production module curriculum. To validate your knowledge, visit the Certification Exam Center and attempt the Production module coding exercises. You can also continue with the Financial Management — Cost Management lesson for a broader view of costing across all iDempiere modules.

// Get the current cost for a product
MProduct product = MProduct.get(ctx, productId);
BigDecimal currentCost = MCost.getCurrentCost(
    product,
    0,          // ASI (0 = aggregate across all lots)
    trxName);
System.out.println("Current cost: " + currentCost);

// Get cost for a specific organization
BigDecimal orgCost = MCost.getCurrentCost(
    product,
    orgId,
    0,          // ASI
    trxName);

// Get seed costs (initial/standard costs)
BigDecimal seedCost = MCost.getSeedCosts(
    product,
    0,          // ASI
    new Timestamp(System.currentTimeMillis()),
    trxName);

// Get last invoice price
BigDecimal lastInvoicePrice = MCost.getLastInvoicePrice(
    product,
    0,          // C_BPartner_ID (0 = any vendor)
    trxName);

// Get last PO price
BigDecimal lastPOPrice = MCost.getLastPOPrice(
    product,
    orgId,
    trxName);

// Get the MCost record for modification
MCost cost = MCost.get(product, 0, // ASI
    acctSchema, orgId, costElementId, trxName);

if (cost != null) {
    // Add cost and quantity (updates weighted average internally)
    cost.add(amount, quantity);
    cost.saveEx();

    // Or set weighted average directly
    cost.setWeightedAverage(totalAmount, totalQuantity);
    cost.saveEx();

    System.out.println("Updated cost: " + cost.getCurrentCostPrice());
}

// Query cost details for a specific product
String sql = "SELECT cd.Amt, cd.Qty, cd.Created, "
    + "cd.M_InOutLine_ID, cd.C_OrderLine_ID, cd.M_ProductionLine_ID "
    + "FROM M_CostDetail cd "
    + "WHERE cd.M_Product_ID = ? AND cd.C_AcctSchema_ID = ? "
    + "ORDER BY cd.Created DESC";

PreparedStatement pstmt = DB.prepareStatement(sql, trxName);
pstmt.setInt(1, productId);
pstmt.setInt(2, acctSchemaId);
ResultSet rs = pstmt.executeQuery();

while (rs.next()) {
    BigDecimal amt = rs.getBigDecimal("Amt");
    BigDecimal qty = rs.getBigDecimal("Qty");
    Timestamp created = rs.getTimestamp("Created");

    String source = "Unknown";
    if (rs.getInt("M_ProductionLine_ID") > 0)
        source = "Production";
    else if (rs.getInt("M_InOutLine_ID") > 0)
        source = "Receipt/Shipment";
    else if (rs.getInt("C_OrderLine_ID") > 0)
        source = "Purchase Order";

    System.out.println(created + " | " + source
        + " | Amt=" + amt + " | Qty=" + qty);
}
DB.close(rs, pstmt);

public class BOMCostCalculator {

    public static class CostBreakdown {
        public String productName;
        public int level;
        public BigDecimal qtyRequired;
        public BigDecimal unitCost;
        public BigDecimal extendedCost;

        public CostBreakdown(String name, int lvl, BigDecimal qty,
                BigDecimal cost, BigDecimal extended) {
            this.productName = name;
            this.level = lvl;
            this.qtyRequired = qty;
            this.unitCost = cost;
            this.extendedCost = extended;
        }
    }

    /**
     * Recursively calculate BOM cost.
     */
    public List<CostBreakdown> calculateCost(Properties ctx,
            int productId, BigDecimal qty, String trxName) {

        List<CostBreakdown> breakdown = new ArrayList<>();
        MProduct product = MProduct.get(ctx, productId);
        MPPProductBOM bom = MPPProductBOM.getDefault(product, trxName);

        if (bom != null) {
            expandCost(ctx, bom, qty, 0, breakdown, trxName);
        }
        return breakdown;
    }

    private void expandCost(Properties ctx, MPPProductBOM bom,
            BigDecimal parentQty, int level,
            List<CostBreakdown> breakdown, String trxName) {

        MPPProductBOMLine[] lines = bom.getLines();

        for (MPPProductBOMLine line : lines) {
            MProduct component = MProduct.get(ctx, line.getM_Product_ID());
            BigDecimal compQty = line.getQtyBOM().multiply(parentQty);

            // Check if this is a phantom that should be expanded
            if (line.isPhantom() && component.isBOM()) {
                // Expand phantom — don't add cost for phantom itself
                MPPProductBOM subBOM = MPPProductBOM.getDefault(
                    component, trxName);
                if (subBOM != null) {
                    expandCost(ctx, subBOM, compQty, level + 1,
                        breakdown, trxName);
                }
            } else {
                // Leaf component — get its cost
                BigDecimal unitCost = MCost.getCurrentCost(
                    component, 0, trxName);
                BigDecimal extCost = compQty.multiply(unitCost);

                breakdown.add(new CostBreakdown(
                    component.getName(), level,
                    compQty, unitCost, extCost));
            }
        }
    }

    /**
     * Sum all component costs.
     */
    public BigDecimal getTotalCost(List<CostBreakdown> breakdown) {
        return breakdown.stream()
            .map(b -> b.extendedCost)
            .reduce(BigDecimal.ZERO, BigDecimal::add);
    }
}

// Usage:
BOMCostCalculator calc = new BOMCostCalculator();
List<CostBreakdown> breakdown = calc.calculateCost(
    ctx, finishedProductId, new BigDecimal("100"), trxName);

System.out.println("=== BOM Cost Analysis ===");
for (CostBreakdown cb : breakdown) {
    String indent = "  ".repeat(cb.level);
    System.out.printf("%s%s: qty=%.2f × $%.4f = $%.2f%n",
        indent, cb.productName,
        cb.qtyRequired, cb.unitCost, cb.extendedCost);
}
System.out.printf("TOTAL: $%.2f%n", calc.getTotalCost(breakdown));

// Get the current cost for a product
MProduct product = MProduct.get(ctx, productId);
BigDecimal currentCost = MCost.getCurrentCost(
    product,
    0,          // ASI (0 = aggregate across all lots)
    trxName);
System.out.println("Current cost: " + currentCost);

// Get cost for a specific organization
BigDecimal orgCost = MCost.getCurrentCost(
    product,
    orgId,
    0,          // ASI
    trxName);

// Get seed costs (initial/standard costs)
BigDecimal seedCost = MCost.getSeedCosts(
    product,
    0,          // ASI
    new Timestamp(System.currentTimeMillis()),
    trxName);

// Get last invoice price
BigDecimal lastInvoicePrice = MCost.getLastInvoicePrice(
    product,
    0,          // C_BPartner_ID (0 = any vendor)
    trxName);

// Get last PO price
BigDecimal lastPOPrice = MCost.getLastPOPrice(
    product,
    orgId,
    trxName);

// Get the MCost record for modification
MCost cost = MCost.get(product, 0, // ASI
    acctSchema, orgId, costElementId, trxName);

if (cost != null) {
    // Add cost and quantity (updates weighted average internally)
    cost.add(amount, quantity);
    cost.saveEx();

    // Or set weighted average directly
    cost.setWeightedAverage(totalAmount, totalQuantity);
    cost.saveEx();

    System.out.println("Updated cost: " + cost.getCurrentCostPrice());
}

// Query cost details for a specific product
String sql = "SELECT cd.Amt, cd.Qty, cd.Created, "
    + "cd.M_InOutLine_ID, cd.C_OrderLine_ID, cd.M_ProductionLine_ID "
    + "FROM M_CostDetail cd "
    + "WHERE cd.M_Product_ID = ? AND cd.C_AcctSchema_ID = ? "
    + "ORDER BY cd.Created DESC";

PreparedStatement pstmt = DB.prepareStatement(sql, trxName);
pstmt.setInt(1, productId);
pstmt.setInt(2, acctSchemaId);
ResultSet rs = pstmt.executeQuery();

while (rs.next()) {
    BigDecimal amt = rs.getBigDecimal("Amt");
    BigDecimal qty = rs.getBigDecimal("Qty");
    Timestamp created = rs.getTimestamp("Created");

    String source = "Unknown";
    if (rs.getInt("M_ProductionLine_ID") > 0)
        source = "Production";
    else if (rs.getInt("M_InOutLine_ID") > 0)
        source = "Receipt/Shipment";
    else if (rs.getInt("C_OrderLine_ID") > 0)
        source = "Purchase Order";

    System.out.println(created + " | " + source
        + " | Amt=" + amt + " | Qty=" + qty);
}
DB.close(rs, pstmt);

public class BOMCostCalculator {

    public static class CostBreakdown {
        public String productName;
        public int level;
        public BigDecimal qtyRequired;
        public BigDecimal unitCost;
        public BigDecimal extendedCost;

        public CostBreakdown(String name, int lvl, BigDecimal qty,
                BigDecimal cost, BigDecimal extended) {
            this.productName = name;
            this.level = lvl;
            this.qtyRequired = qty;
            this.unitCost = cost;
            this.extendedCost = extended;
        }
    }

    /**
     * Recursively calculate BOM cost.
     */
    public List<CostBreakdown> calculateCost(Properties ctx,
            int productId, BigDecimal qty, String trxName) {

        List<CostBreakdown> breakdown = new ArrayList<>();
        MProduct product = MProduct.get(ctx, productId);
        MPPProductBOM bom = MPPProductBOM.getDefault(product, trxName);

        if (bom != null) {
            expandCost(ctx, bom, qty, 0, breakdown, trxName);
        }
        return breakdown;
    }

    private void expandCost(Properties ctx, MPPProductBOM bom,
            BigDecimal parentQty, int level,
            List<CostBreakdown> breakdown, String trxName) {

        MPPProductBOMLine[] lines = bom.getLines();

        for (MPPProductBOMLine line : lines) {
            MProduct component = MProduct.get(ctx, line.getM_Product_ID());
            BigDecimal compQty = line.getQtyBOM().multiply(parentQty);

            // Check if this is a phantom that should be expanded
            if (line.isPhantom() && component.isBOM()) {
                // Expand phantom — don't add cost for phantom itself
                MPPProductBOM subBOM = MPPProductBOM.getDefault(
                    component, trxName);
                if (subBOM != null) {
                    expandCost(ctx, subBOM, compQty, level + 1,
                        breakdown, trxName);
                }
            } else {
                // Leaf component — get its cost
                BigDecimal unitCost = MCost.getCurrentCost(
                    component, 0, trxName);
                BigDecimal extCost = compQty.multiply(unitCost);

                breakdown.add(new CostBreakdown(
                    component.getName(), level,
                    compQty, unitCost, extCost));
            }
        }
    }

    /**
     * Sum all component costs.
     */
    public BigDecimal getTotalCost(List<CostBreakdown> breakdown) {
        return breakdown.stream()
            .map(b -> b.extendedCost)
            .reduce(BigDecimal.ZERO, BigDecimal::add);
    }
}

// Usage:
BOMCostCalculator calc = new BOMCostCalculator();
List<CostBreakdown> breakdown = calc.calculateCost(
    ctx, finishedProductId, new BigDecimal("100"), trxName);

System.out.println("=== BOM Cost Analysis ===");
for (CostBreakdown cb : breakdown) {
    String indent = "  ".repeat(cb.level);
    System.out.printf("%s%s: qty=%.2f × $%.4f = $%.2f%n",
        indent, cb.productName,
        cb.qtyRequired, cb.unitCost, cb.extendedCost);
}
System.out.printf("TOTAL: $%.2f%n", calc.getTotalCost(breakdown));