{"id":20166,"date":"2026-07-10T11:17:43","date_gmt":"2026-07-10T11:17:43","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20166"},"modified":"2026-08-20T11:38:13","modified_gmt":"2026-08-20T11:38:13","slug":"how-product-attribute-grid-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-product-attribute-grid-works-in-idempiere\/","title":{"rendered":"How Product Attribute Grid Works in iDempiere"},"content":{"rendered":"\n

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

The Product Attribute Grid is an iDempiere Core window that displays product stock or price data as a matrix built from two product attributes, such as Color and Capacity.<\/p>\n\n\n\n

It is used in retail and distribution operations that sell variant-based products, letting warehouse and sales staff view availability across an entire attribute range in one screen.<\/p>\n\n\n\n

This consolidated view speeds up stock checks, quoting, and order entry, reducing the need to open individual product records for every variant combination.<\/p>\n\n\n\n

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

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Only active Attribute Set Instances (ASI) appear in the grid.<\/li>\n\n\n\n
  • Attribute 1 and Attribute 2 must belong to the product’s Attribute Set to show data.<\/li>\n\n\n\n
  • Grid values are filtered by the selected Warehouse and Price List combination.<\/li>\n\n\n\n
  • Mode on the Attribute Grid tab decides whether cells show quantity on hand or price.<\/li>\n\n\n\n
  • Combinations with no stock or no price show as blank cells.<\/li>\n\n\n\n
  • The grid refreshes based on the Selection tab criteria confirmed before switching tabs.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Attribute Set configured with at least two Attributes (e.g., Color, Capacity).<\/li>\n\n\n\n
    • Attribute Set assigned to the relevant Products.<\/li>\n\n\n\n
    • Attribute Set Instances created through receipts or product setup.<\/li>\n\n\n\n
    • Warehouse configured and active.<\/li>\n\n\n\n
    • Price List configured with an active Price List Version.<\/li>\n\n\n\n
    • Products included in the selected Price List Version.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 Material Management and Pricing \u2192 Product Attribute Grid<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-Form-ProductAttributeGrid-1\"<\/figure>\n\n\n\n
      Opening the window shows the Selection tab with four dropdown fields: Attribute 1<\/strong>, Attribute 2<\/strong>, Price List<\/strong>, and Warehouse<\/strong>. No data displays until these are chosen and confirmed.<\/p>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Open the Product Attribute Grid Window<\/strong><\/h3>\n\n\n\n
      This step loads the Selection tab where the attribute pair and filter criteria are defined before any matrix data is generated.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Navigate to the Product Attribute Grid. The window opens directly on the Selection tab<\/strong>.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Form-ProductAttributeGrid-2\"<\/figure>\n\n\n\n
      Step 2: Choose Attribute 1 and Attribute 2<\/strong><\/h3>\n\n\n\n
      These two attributes define the row and column axis of the matrix, so they must be picked before generating the grid.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Open the Attribute 1<\/strong> dropdown and pick the row attribute<\/strong> (e.g., Color). Open Attribute 2<\/strong> and pick the column attribute<\/strong> (e.g., Capacity).<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Form-ProductAttributeGrid-3\"<\/figure>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Attribute 1<\/td>Color<\/td>Attribute used as the row axis of the grid<\/td><\/tr>
      Attribute 2<\/td>Capacity<\/td>Attribute used as the column axis of the grid<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 3: Select Price List and Warehouse<\/strong><\/h3>\n\n\n\n
      These filters scope the grid to one price list and one warehouse so the displayed figures are business-relevant and accurate.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Select the applicable Price List, then select the Warehouse to check. Confirm the Selection tab using the checkmark button.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Form-ProductAttributeGrid-4\"<\/figure>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Price List<\/td>Standard<\/td>Price list used to filter pricing data shown in the grid<\/td><\/tr>
      Warehouse<\/td>HQ Warehouse<\/td>Warehouse used to filter stock quantities shown in the grid<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Note:<\/strong> Selecting the same attribute for both Attribute 1 and Attribute 2 produces a matrix with no meaningful comparison.<\/code><\/pre>\n\n\n\n
      Step 4: Switch to the Attribute Grid Tab<\/strong><\/h3>\n\n\n\n
      The Attribute Grid tab renders the actual matrix, so the Selection tab criteria must be confirmed first.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Click the Attribute Grid tab. Set Mode to choose between quantity or price view, then review the generated matrix.<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Mode<\/td>View<\/td>Determines whether the grid readonly or editable<\/td><\/tr>
      Row Header<\/td>BLACK, BLUE, BROWN, GREEN, GREY, NAVY BLUE<\/td>Values of Attribute 1 displayed as rows<\/td><\/tr>
      Column Header<\/td>64 GB, 128 GB, 256 GB, 512 GB<\/td>Values of Attribute 2 displayed as columns<\/td><\/tr><\/tbody><\/table><\/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>
      Grid displays empty<\/td>No Attribute Set Instance exists for the combination<\/td>Receive stock or create the ASI for that combination<\/td><\/tr>
      Attribute 1 \/ Attribute 2 list is empty<\/td>Attribute Set not assigned to any product<\/td>Assign the Attribute Set to relevant Products<\/td><\/tr>
      Warehouse dropdown has no options<\/td>Warehouse inactive or Organization access missing<\/td>Activate the Warehouse and check user Organization access<\/td><\/tr>
      Price values missing in grid<\/td>Product not listed in the selected Price List Version<\/td>Add the product to the Price List Version<\/td><\/tr>
      Quantities do not match physical count<\/td>Grid reflects last processed transaction only<\/td>Complete pending Material Receipt or Inventory Move documents<\/td><\/tr>
      Matrix looks meaningless<\/td>Same attribute chosen for Attribute 1 and Attribute 2<\/td>Select two distinct attributes<\/td><\/tr>
      Mode change has no effect<\/td>Selection tab not confirmed before switching tabs<\/td>Confirm the Selection tab, then reopen the Attribute Grid tab<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Product Attribute Set window \u2013 define attributes and values.<\/li>\n\n\n\n
      • Product window \u2013 assign the Attribute Set to products.<\/li>\n\n\n\n
      • Price List and Price List Version \u2013 maintain pricing per variant.<\/li>\n\n\n\n
      • Warehouse and Locators \u2013 configure storage for variant stock.<\/li>\n\n\n\n
      • Material Receipt \/ Inventory Count \u2013 record stock for new combinations.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        Introduction The Product Attribute Grid is an iDempiere Core window that displays product stock or price data as a matrix […]<\/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-20166","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\/20166","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=20166"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20166\/revisions"}],"predecessor-version":[{"id":28105,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20166\/revisions\/28105"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}