--- title: "Manufacturing Material Consumption Analysis" date: 2026-01-08 description: "Advanced SQL Quick Report for IFS Cloud, providing detailed analysis of manufacturing material consumption by Shop Order." author: "Dariusz Mysliwiec" intro_image: "https://www.ifs-erp.com/images/Manufacturing%20Material%20Consumption%20Analysis/Manufacturing%20Material%20Consumption%20Analysis%20Small.png" fulltext_image: "https://www.ifs-erp.com/images/Manufacturing%20Material%20Consumption%20Analysis/Manufacturing%20Material%20Consumption%20Analysis%20Small.png" categories: - name: "Reports" url: "https://www.ifs-erp.com/reports.md" tags: - name: "IFS Cloud" url: "https://www.ifs-erp.com/tags/ifs-cloud-pl.md" - name: "Quick Reports" url: "https://www.ifs-erp.com/tags/quick-reports.md" - name: "Shop Order" url: "https://www.ifs-erp.com/tags/shop-order.md" --- # Manufacturing Material Consumption Analysis ![Manufacturing Material Consumption Analysis](https://www.ifs-erp.com/images/Manufacturing%20Material%20Consumption%20Analysis/Manufacturing%20Material%20Consumption%20Analysis%20Small.png) PRODUCT ID: [REP-MAN-001](https://www.ifs-erp.com/marketplace/reports) | SQL Quick Report ## Manufacturing Material Consumption Analysis Gain complete visibility into your production costs. A detailed breakdown of material consumption by Shop Order, linking raw material usage directly to the manufactured parent part. Status: Released Optimized: Yes (CTE) Module: Manufacturing ### 1. Report Overview Tracking the actual cost of materials issued to production can be challenging when dealing with thousands of transaction lines. This report aggregates **Shop Order Issues (SOISS)**, **Backflushes (BACFLUSH)**, and **Un-issues (UNISS)** to calculate the net consumption for a specific period. Unlike standard transaction history views, this report utilizes **SQL Common Table Expressions (CTEs)**. This "Filter-First" architecture significantly improves performance on large databases by filtering the Inventory Part table before joining it to the massive Transaction History table. ![Manufacturing Material Consumption Analysis Report - Result View](https://www.ifs-erp.com/images/Manufacturing%20Material%20Consumption%20Analysis/Manufacturing%20Material%20Consumption%20Analysis%20Report%20-%20Result%20View.png) ![Manufacturing Material Consumption Analysis Report - Excel View](https://www.ifs-erp.com/images/Manufacturing%20Material%20Consumption%20Analysis/Manufacturing%20Material%20Consumption%20Analysis%20Report%20-%20Excel%20View.png) **New Feature:** This version includes a dynamic **Grand Total** row at the bottom using SQL `ROLLUP` functionality, allowing you to see the total value of consumption immediately without exporting to Excel. ### 2. Key Features - **Parent-Child Linkage:** Shows exactly which raw materials (Component Part) were used to build a specific finished good (Manufactured Part). - **Net Cost Calculation:** Automatically subtracts returns (Un-issues) from Issues to show the true net cost. - **Commodity Filtering:** Allows deep-dive analysis by Prime Commodity, Asset Class, or ABC Class. - **Weighted Average Cost:** Calculates the actual average unit cost for the selected period. - **Performance Optimized:** Designed for high-speed execution even with large date ranges. #### Report Output Columns | Column Name | Description | | --- | --- | | Site | The contract site (displays "GRAND TOTAL" in the summary row). | | Planner | The planner responsible for the raw material. | | Component Part No | The ID of the raw material consumed. | | Manufactured Part No | The parent part being produced on the Shop Order. | | Quantity | Net quantity consumed (Issues - Unissues). | | Total Value | Net financial cost of consumption. | | Average Unit Cost | Calculated weighted average cost. | ### 3. Input Parameters When running this report in IFS Cloud, the user will be prompted for the following criteria: | Parameter | Description | Optional? | | --- | --- | --- | | &Contract | The Site identifier (e.g., 10). Supports wildcards (%). | No | | &DateFrom | Start date of the analysis (YYYY-MM-DD). | No | | &DateTo | End date of the analysis. | No | | &PartNo | Filter by specific Component Part No. | Yes | | &PrimeCommodity | Filter by Prime Commodity code. | Yes | | &AssetClass | Filter by Asset Class. | Yes | ### Frequently Asked Questions ## The logic automatically detects `UNISS` transaction codes and subtracts them from the total. For example, if you issue 10 units and return 2, the report will display a Net Quantity of 8. ## In standard IFS Transaction History, issues are recorded as negative numbers. We have inverted the sign in this report logic so that "Consumption" appears as a positive value, making it easier for financial managers to read and sum. ## Yes. The report is based on transaction dates, not order status. It captures all consumption within the selected date range, regardless of whether the Shop Order is currently `Started`, `Closed`, or `Parked`. ## This column populates only when the material transaction is directly linked to a specific Shop Order (via Source Refs). If a manual issue (`SOISS`) was performed without a proper reference, or if the data is from legacy migration, this field may remain empty. ## The final row aggregates the value of all transactions listed above it. It uses the SQL `ROLLUP` function to ensure the math is performed on the server side, providing an accurate financial total for the selected period immediately. ##### Price 300 EUR One-time payment Delivered immediately via download. ###### Report Details | | | | --- | --- | | Type: | SQL Quick Report | | Module: | Manufacturing / Inv | | Optimized: | Yes (CTE) | | Group By: | Contract, Part No |