{"id":17469,"date":"2026-01-29T13:18:27","date_gmt":"2026-01-29T13:18:27","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=17469"},"modified":"2026-08-20T06:22:50","modified_gmt":"2026-08-20T06:22:50","slug":"how-product-dimension-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-product-dimension-works-in-idempiere\/","title":{"rendered":"How Product Dimension Works in iDempiere"},"content":{"rendered":"\n

The Product Dimension<\/strong> links accounting entries to what is bought, sold, consumed, or produced. It enables tracking costs and revenue by product<\/strong> without creating separate GL accounts. Once configured, it works automatically by capturing the selected product during document posting.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Creating Product Dimension Values<\/strong><\/h2>\n\n\n\n

Product dimension values are derived from products defined in the system<\/strong>. Each product becomes a leaf node in the Product Dimension tree and is available for accounting once it is active.<\/p>\n\n\n\n

While creating or reviewing a product for dimension usage:<\/p>\n\n\n\n

    \n
  • The product must be active<\/strong><\/li>\n\n\n\n
  • It must not be a summary product<\/strong><\/li>\n\n\n\n
  • It should belong to the correct product hierarchy<\/li>\n<\/ul>\n\n\n\n

    Product categories help organize products, but posting always occurs at the product level<\/strong>, not at category level.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Product Hierarchy and Structure<\/strong><\/h2>\n\n\n\n

    The Product Dimension follows a parent\u2013child hierarchy<\/strong>.<\/p>\n\n\n\n

      \n
    • Parent nodes represent product groups or categories<\/strong><\/li>\n\n\n\n
    • Child nodes represent individual products<\/strong><\/li>\n\n\n\n
    • Only leaf products<\/strong> are used in accounting postings<\/li>\n<\/ul>\n\n\n\n

      This structure allows reports to show both detailed product-level values<\/strong> and group-level summaries<\/strong> without additional configuration.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Product Dimension During Transactions<\/strong><\/h2>\n\n\n\n

      Users do not manually select the Product Dimension.<\/p>\n\n\n\n

      Instead:<\/p>\n\n\n\n

        \n
      • The product entered on the document line determines the dimension<\/li>\n\n\n\n
      • The system automatically assigns the product during posting<\/li>\n\n\n\n
      • No extra user action is required<\/li>\n<\/ul>\n\n\n\n

        This applies to:<\/p>\n\n\n\n

          \n
        • Sales Invoices<\/li>\n\n\n\n
        • Purchase Invoices<\/li>\n\n\n\n
        • Material Receipts and Issues<\/li>\n\n\n\n
        • Inventory and Costing transactions<\/li>\n<\/ul>\n\n\n\n

          Once posted, the product value is locked in accounting and remains unchanged.<\/p>\n\n\n\n

          Product Dimension in Accounting Records<\/strong><\/h2>\n\n\n\n

          After posting, the Product Dimension appears in Accounting Fact Details<\/strong>. Each accounting line carries the product reference, allowing precise tracking of costs and revenue.<\/p>\n\n\n\n

          This makes it possible to:<\/p>\n\n\n\n

            \n
          • Analyze profitability by product<\/li>\n\n\n\n
          • Track expenses by material or item<\/li>\n\n\n\n
          • Compare performance across product groups<\/li>\n<\/ul>\n\n\n\n

            Even if product details change later, the original accounting entries retain the correct product reference.<\/p>\n\n\n\n

            \"\"<\/figure>\n\n\n\n

            Product Dimension in Reporting<\/strong><\/h2>\n\n\n\n

            Reports use the Product Dimension to group and filter financial data.<\/p>\n\n\n\n

            Common reporting views include:<\/p>\n\n\n\n

              \n
            • Revenue by product<\/li>\n\n\n\n
            • Cost by material<\/li>\n\n\n\n
            • Margin analysis by product group<\/li>\n\n\n\n
            • Inventory valuation by product<\/li>\n<\/ul>\n\n\n\n

              Because the hierarchy is maintained in the dimension tree, reports automatically roll up values from products to categories.<\/p>\n\n\n\n

              Outcome<\/strong><\/h2>\n\n\n\n

              With Product Dimension correctly used, iDempiere provides clear product-level financial visibility<\/strong> without complicating the chart of accounts. Users work with products as usual, while accounting and reporting gain accurate, structured product insights across the system.<\/p>\n","protected":false},"excerpt":{"rendered":"

              The Product Dimension links accounting entries to what is bought, sold, consumed, or produced. It enables tracking costs and revenue […]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-17469","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-accounting"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17469","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\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=17469"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17469\/revisions"}],"predecessor-version":[{"id":21211,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17469\/revisions\/21211"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=17469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=17469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=17469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}