{"id":20267,"date":"2026-07-10T11:12:20","date_gmt":"2026-07-10T11:12:20","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20267"},"modified":"2026-07-10T11:12:22","modified_gmt":"2026-07-10T11:12:22","slug":"how-product-component-where-used-report-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-product-component-where-used-report-works-in-idempiere\/","title":{"rendered":"How Product\/Component Where Used Report Works in iDempiere"},"content":{"rendered":"\n

Introduction<\/strong><\/h2>\n\n\n\n

The Product\/Component Where Used report in iDempiere identifies every Bill of Materials (BOM) that consumes a selected product as a component. It is used in Material Management wherever manufactured or kitted products are maintained, such as FMCG, assembly, and packaging operations.<\/p>\n\n\n\n

Users enter a single component, and the report scans active BOM headers and lines to list each Master BOM using it, along with quantity and line number. The report is non-recursive, showing only one parent level above the selected component.<\/p>\n\n\n\n

This report supports impact analysis for raw material changes, discontinuation decisions, and production planning by showing dependency between components and finished goods before changes are approved.<\/p>\n\n\n\n

Process Flow Diagram<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-Inventory-ProductComponentWhereUsed-ProcessFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Only active products, active BOM headers, and active BOM lines are included in the report.<\/li>\n\n\n\n
  • The Product field is mandatory before the report can be executed.<\/li>\n\n\n\n
  • The report is non-recursive and shows only one parent level above the selected component.<\/li>\n\n\n\n
  • Selecting a component displays every Master BOM in which it appears as an ingredient.<\/li>\n\n\n\n
  • Quantity (QtyBOM) shows how much of the component each Master BOM consumes.<\/li>\n\n\n\n
  • Line No identifies the position of the component within the Master BOM’s line list.<\/li>\n\n\n\n
  • The report can run interactively in HTML or be scheduled in the background using Run as Job.<\/li>\n\n\n\n
  • A component with no active BOM usage returns zero rows in the report.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Product master records created for both the component and the finished (Master BOM) products.<\/li>\n\n\n\n
    • Product BOM and Formula (PP_Product_BOM) defined for each finished product that uses the component.<\/li>\n\n\n\n
    • BOM lines added to the Product BOM, referencing the component with a valid Qty BOM.<\/li>\n\n\n\n
    • Component product, Master BOM header, and BOM lines all set to Active = Y.<\/li>\n\n\n\n
    • Appropriate user role and window access granted for running reports under Material Management.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 Material Management and Pricing \u2192 Material Management Rules \u2192 Product\/Component Where Used<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-Master-ProductComponentWhereUsed-1\"<\/figure>\n\n\n\n

      Opening the window displays a parameter screen with a mandatory Product field, a Run as Job checkbox, and OK\/Cancel buttons. After running, iDempiere opens the report viewer showing the Parameter summary and a results grid with Product, Master BOM, Name, Quantity, and Line No columns.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Master-ProductComponentWhereUsed-2\"<\/figure>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Select the Component Product<\/strong><\/h3>\n\n\n\n
      This step defines which component the system searches for across all active Bills of Materials.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Open the Product\/Component Where Used window. In the Product field, search and select the component, e.g. CIN_Cinthol Soap. The field is mandatory.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Master-ProductComponentWhereUsed-3\"<\/figure>\n\n\n\n
      Field Reference Table<\/strong><\/h3>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Product<\/td>CIN_Cinthol Soap<\/td>Component product to check for BOM usage. Mandatory field.<\/td><\/tr>
      Run as Job<\/td>Unchecked<\/td>When checked, the report runs as a background scheduled process instead of running interactively.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 2: Choose Execution Mode<\/strong><\/h3>\n\n\n\n
      This step determines whether the report runs immediately or is submitted as a background job, useful for large catalogs.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Leave Run as Job unchecked for immediate on-screen results. Check it to submit the report as a scheduled process and review results later from Process Request.<\/p>\n\n\n\n
      Step 3: Execute the Report<\/strong><\/h3>\n\n\n\n
      Running the report applies the Product parameter against the underlying BOM view and returns matching Master BOM records.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Click OK. iDempiere opens the report viewer showing the selected Product parameter and a results grid, or Cancel to close without running.<\/p>\n\n\n\n
      Step 4: Review the Report Output<\/strong><\/h3>\n\n\n\n
      This step confirms which finished products depend on the selected component and in what quantity.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Review the grid. Each row is one Master BOM using the component. Use View Report to switch between HTML and other formats, and Print Format to change layout.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Master-ProductComponentWhereUsed-4\"<\/figure>\n\n\n\n
      Field Reference Table<\/strong><\/h3>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Product<\/td>CIN_Cinthol Soap<\/td>The component that was selected as the search parameter.<\/td><\/tr>
      Master BOM<\/td>FG_Cinthol Combo Pack<\/td>The finished product\/BOM header that consumes the component.<\/td><\/tr>
      Name<\/td>Cinthol Combo Pack 3x100g<\/td>Name of the Master BOM product.<\/td><\/tr>
      Quantity<\/td>3<\/td>Quantity of the component consumed per unit of the Master BOM (QtyBOM).<\/td><\/tr>
      Line No<\/td>10<\/td>Sequence number of the BOM line within the Master BOM.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 5: Export or Print the Results (Optional)<\/strong><\/h3>\n\n\n\n
      This step is used when the where-used data must be shared with planning, purchasing, or costing teams.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Use the download icon to export to PDF\/Excel, or the email icon to send the report directly from the viewer toolbar.<\/p>\n\n\n\n
      Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n
      Issue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
      Report returns zero rows<\/td>Component is not used as a line in any active BOM<\/td>Confirm the component is added to a Product BOM and the BOM line is active.<\/td><\/tr>
      Product field validation error<\/td>Mandatory Product field left empty<\/td>Select a valid product before clicking OK.<\/td><\/tr>
      Expected Master BOM missing from results<\/td>BOM header (PP_Product_BOM) is inactive<\/td>Activate the BOM header in the Product BOM and Formula window.<\/td><\/tr>
      Master BOM or Name column shows blank<\/td>Finished (master) product is inactive<\/td>Reactivate the master product record in the Product window.<\/td><\/tr>
      Same component appears multiple times<\/td>Component is used in more than one BOM line or Master BOM<\/td>Use the Line No column to distinguish each individual BOM usage.<\/td><\/tr>
      Run as Job shows no immediate output<\/td>Report is executing as a background process<\/td>Check Process Request or notifications for completion status and output.<\/td><\/tr>
      Wrong or unexpected product results<\/td>Incorrect product selected via search text<\/td>Confirm the product Value\/search key before running the report.<\/td><\/tr>
      Multi-level dependency not visible<\/td>Report is non-recursive by design<\/td>Re-run the report using each intermediate Master BOM to trace additional levels manually.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Product BOM and Formula \u2013 create or update BOM headers and lines.<\/li>\n\n\n\n
      • Product window \u2013 verify component and finished product master data.<\/li>\n\n\n\n
      • BOM Drop\/Explode process \u2013 for multi-level BOM expansion needs.<\/li>\n\n\n\n
      • Manufacturing Order \u2013 to plan production once dependencies are confirmed.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        Introduction The Product\/Component Where Used report in iDempiere identifies every Bill of Materials (BOM) that consumes a selected product as […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[37],"tags":[],"class_list":["post-20267","post","type-post","status-publish","format-standard","hentry","category-inventory"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20267"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20267\/revisions"}],"predecessor-version":[{"id":20286,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20267\/revisions\/20286"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}