{"id":21294,"date":"2026-07-20T08:11:12","date_gmt":"2026-07-20T08:11:12","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21294"},"modified":"2026-08-13T04:55:38","modified_gmt":"2026-08-13T04:55:38","slug":"how-to-use-indented-bill-of-material-report-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-use-indented-bill-of-material-report-in-idempiere\/","title":{"rendered":"How to use Indented Bill of Material Report in iDempiere"},"content":{"rendered":"\n

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

The Indented Bill of Material report in iDempiere is a costing tool that recursively explodes a product’s Bill of Material into a multi-level, indented view of components and sub-components.<\/p>\n\n\n\n

It is used by costing and manufacturing teams during BOM audits, standard cost reviews, and cost roll-up verification before period-end closing.<\/p>\n\n\n\n

The report directly reflects Current and Future Cost values used in inventory valuation, margin analysis, and manufacturing cost planning.<\/p>\n\n\n\n

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

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Accounting Schema, Product, and Cost Element fields are mandatory to run the report.<\/li>\n\n\n\n
  • Report explodes BOM lines recursively from the top-level product down to leaf components.<\/li>\n\n\n\n
  • Cost values are retrieved from cost records tied to the selected Cost Element.<\/li>\n\n\n\n
  • Current Cost Price reflects the active cost; Future Cost Price reflects pending cost changes.<\/li>\n\n\n\n
  • Components without further BOM lines are treated as leaf-level costs.<\/li>\n\n\n\n
  • Lower Level cost columns aggregate costs rolled up from all child components.<\/li>\n\n\n\n
  • The report can run interactively or as a background job using Run as Job.<\/li>\n\n\n\n
  • Output supports HTML view, printing, export (PDF\/CSV), and emailing.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Product with an active Bill of Material (BOM) structure configured.<\/li>\n\n\n\n
    • Cost records (Standard or Future) maintained for the product and its components.<\/li>\n\n\n\n
    • Accounting Schema configured with the required Costing Method.<\/li>\n\n\n\n
    • Cost Element defined and marked Active.<\/li>\n\n\n\n
    • Organization configured for the related product and cost data.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 Manufacturing \u2192 Indented Bill of Material<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-Manufacturing-IndentedBillOfMaterials-1\"<\/figure>\n\n\n\n
      Opening the window displays the report parameter screen with Accounting Schema, Product, and Cost Element fields, plus a Run as Job checkbox and OK\/Cancel buttons.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Manufacturing-IndentedBillOfMaterials-2\"<\/figure>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Select Accounting Schema<\/strong><\/h3>\n\n\n\n
      Determines which costing books and currency the cost values are pulled from.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Click the Accounting Schema field and select the relevant schema. This field is mandatory before the report can be executed.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Accounting Schema<\/td>POTS UM\/38 Indian Rupee<\/td>Defines the costing currency and accounting book used for calculation.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 2: Select Product<\/strong><\/h3>\n\n\n\n
      Identifies the top-level product whose BOM structure will be exploded.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Search and select the finished good or sub-assembly to analyze using the product picker. This field is mandatory.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Product<\/td>BRI-GDBC-200_Britannia Good Day Butter Cookies \u2013 200g<\/td>Top-level product whose BOM is exploded in the report.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 3: Select Cost Element<\/strong><\/h3>\n\n\n\n
      Specifies which costing method drives the reported cost figures.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Choose the applicable Cost Element from the dropdown. This determines which cost bucket is displayed in the report output.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Cost Element<\/td>Standard Costing<\/td>Costing method used to calculate Current and Future cost values.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 4: Enable Run as Job (Optional)<\/strong><\/h3>\n\n\n\n
      Allows the report to process in the background for products with large or deep BOM structures.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Check Run as Job if the BOM has many levels or the report is expected to take longer to process.<\/p>\n\n\n\n
      Step 5: Execute the Report<\/strong><\/h3>\n\n\n\n
      Generates the indented cost explosion output for review.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Click OK to run the report, or Cancel to close the window without generating output.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Levels<\/td>BRI-GDBC-200<\/td>Sequential level\/value code representing the BOM node.<\/td><\/tr>
      Selected Product<\/td>BRI-GDBC-200_Britannia Good Day Butter Cookies \u2013 200g<\/td>Product name at the current BOM level.<\/td><\/tr>
      Qty<\/td>1<\/td>Quantity of the component per parent BOM level.<\/td><\/tr>
      Current Cost Price<\/td>55.00<\/td>Active cost of the product at this level.<\/td><\/tr>
      Cost<\/td>55.00<\/td>Cost of the level multiplied by accumulated quantity.<\/td><\/tr>
      Future Cost price<\/td>0.00<\/td>Pending\/future cost value for the level, if maintained.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"TenthPlanet-iDempiere-Manufacturing-IndentedBillOfMaterials-3\"<\/figure>\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 no cost values (0.00)<\/td>No cost record exists for the product\/cost element combination<\/td>Run Cost Calculation from the Costing window before generating the report.<\/td><\/tr>
      “Fill Mandatory” error on OK<\/td>Accounting Schema, Product, or Cost Element left blank<\/td>Complete all mandatory fields marked with an asterisk (*).<\/td><\/tr>
      BOM levels not expanding<\/td>Product has no active BOM lines configured<\/td>Verify BOM lines exist and are Active in the Bill of Material window.<\/td><\/tr>
      Future Cost columns show 0.00<\/td>No future cost record maintained for the product<\/td>Enter future cost values on the Costing tab of the product.<\/td><\/tr>
      Report runs slowly or times out<\/td>Deeply nested BOM structure processed interactively<\/td>Enable Run as Job to process the report in the background.<\/td><\/tr>
      Incorrect currency displayed in output<\/td>Wrong Accounting Schema selected<\/td>Select the Accounting Schema matching the required costing currency.<\/td><\/tr>
      Product not found in selector<\/td>Product is inactive or not linked to the organization<\/td>Verify the product is Active and assigned to the correct Organization.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Note:<\/strong> Cost figures shown in this report are AS-IS values pulled from existing cost records; the report does not recalculate or post accounting entries.<\/code><\/pre>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Configure the Bill of Material \/ Formula for the product.<\/li>\n\n\n\n
      • Maintain Product Costing records via the Costing window.<\/li>\n\n\n\n
      • Review and maintain Cost Elements configuration.<\/li>\n\n\n\n
      • Run Cost Calculation periodically before generating this report.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        Introduction The Indented Bill of Material report in iDempiere is a costing tool that recursively explodes a product’s Bill of […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,10],"tags":[],"class_list":["post-21294","post","type-post","status-publish","format-standard","hentry","category-idempiere-inventory","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21294","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=21294"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21294\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}