{"id":18667,"date":"2026-05-29T11:10:55","date_gmt":"2026-05-29T11:10:55","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=18667"},"modified":"2026-05-29T11:10:57","modified_gmt":"2026-05-29T11:10:57","slug":"how-to-configure-attribute-set-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-attribute-set-in-idempiere\/","title":{"rendered":"How to Configure Attribute Set in iDempiere"},"content":{"rendered":"\n

Learn how Attribute Sets in iDempiere help distribution businesses manage product characteristics such as size, color, lot numbers, serial numbers, and expiry dates for accurate inventory tracking and traceability.<\/p>\n\n\n\n

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

In distribution businesses, products often require different levels of inventory tracking based on their characteristics, regulatory requirements, and lifecycle management needs. The Attribute Set window in iDempiere allows organizations to define standardized groups of product attributes, such as size, color, lot number, serial number, and guarantee or expiry date, that can be assigned to products. By using Attribute Sets, distributors can maintain accurate inventory records, improve traceability, support warranty and compliance requirements, and efficiently manage product variations. Whether tracking apparel by size and color, agricultural products by lot and expiry date, or durable goods by serial number, Attribute Sets provide the flexibility needed for effective inventory control.<\/p>\n\n\n\n

Prerequisites<\/strong><\/h2>\n\n\n\n

Before starting, ensure the following:<\/p>\n\n\n\n

    \n
  • Initial Tenant Setup completed successfully<\/li>\n\n\n\n
  • Product Category master data is available<\/li>\n\n\n\n
  • Lot Control and Serial Number Control records are configured (if required)<\/li>\n\n\n\n
  • Attribute master records are defined under the Attribute window<\/li>\n\n\n\n
  • Logged in with a role that has sufficient access rights to Product configuration<\/li>\n<\/ul>\n\n\n\n

    Navigation<\/strong><\/h2>\n\n\n\n

    Access the Attribute Set window using the following menu path:<\/p>\n\n\n\n

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

    Menu \u2192 Material Management \u2192 Product Setup \u2192 Attribute Set<\/p>\n\n\n\n

    Step-by-Step Configuration<\/strong><\/h2>\n\n\n\n

    Step 1: Open Attribute Set Window<\/strong><\/h3>\n\n\n\n

    The window displays all existing Attribute Set records. Existing seed data includes T-Shirt, Fertilizer Lot, and Patio Chair configurations.<\/p>\n\n\n\n

    Step 2: Create New Record<\/strong><\/h3>\n\n\n\n

    Click: New Record (+)<\/p>\n\n\n\n

    Enter the required details in the Attribute Set header form.<\/p>\n\n\n\n

    Attribute Set Header Fields<\/strong><\/h3>\n\n\n\n
      \n
    • Name <\/strong>\u2014 Descriptive name for the attribute set (displayed on products and transactions)<\/li>\n\n\n\n
    • Description <\/strong>\u2014 Optional business context for the attribute set<\/li>\n\n\n\n
    • Tenant <\/strong>\u2014 Automatically populated from the logged-in session<\/li>\n\n\n\n
    • Organization <\/strong>\u2014 Defines availability scope; use * for all organizations<\/li>\n\n\n\n
    • Entity Type <\/strong>\u2014 Identifies ownership: D (Dictionary), C (Customer)<\/li>\n\n\n\n
    • Active <\/strong>\u2014 Enables the record for use in product assignments<\/li>\n\n\n\n
    • Is Lot <\/strong>\u2014 Enables lot-level tracking for inventory movements<\/li>\n\n\n\n
    • Is Lot Mandatory <\/strong>\u2014 Enforces lot entry on all transactions<\/li>\n\n\n\n
    • Lot Control <\/strong>\u2014 Links a Lot Control record defining lot number format<\/li>\n\n\n\n
    • Lot Char Start \/ End Overwrite <\/strong>\u2014 Overrides lot control delimiters<\/li>\n\n\n\n
    • Is Serial No <\/strong>\u2014 Enables serial number tracking<\/li>\n\n\n\n
    • Is Serial No Mandatory <\/strong>\u2014 Enforces serial number entry on all transactions<\/li>\n\n\n\n
    • Serial No Control <\/strong>\u2014 Links a Serial No Control record<\/li>\n\n\n\n
    • Ser No Char Start \/ End Overwrite <\/strong>\u2014 Overrides serial number delimiters<\/li>\n\n\n\n
    • Is Instance Attribute <\/strong>\u2014 Marks attribute as specific to each inventory instance<\/li>\n\n\n\n
    • Guarantee Days <\/strong>\u2014 Default shelf life in days for expiry tracking<\/li>\n\n\n\n
    • Guarantee Date Mandatory <\/strong>\u2014 Enforces guarantee date entry<\/li>\n\n\n\n
    • Use Guarantee Date for Material Policy <\/strong>\u2014 Uses expiry date for FEFO policy<\/li>\n\n\n\n
    • Mandatory Type <\/strong>\u2014 Controls attribute entry enforcement (Not Mandatory \/ When Shipping \/ Always)<\/li>\n\n\n\n
    • Is Auto Generate Lot <\/strong>\u2014 Automatically generates lot numbers on receipt<\/li>\n<\/ul>\n\n\n\n

      Step 3: Configure T-Shirt Attribute Set (Product Attributes, No Instance)<\/strong><\/h3>\n\n\n\n

      This configuration supports apparel products requiring size and color classification without lot or serial number tracking.<\/p>\n\n\n\n

      Field<\/strong><\/td>Value<\/strong><\/td><\/tr><\/thead>
      Name<\/td>T-Shirt<\/td><\/tr>
      Description<\/td>Product: Size, Color – No Instance<\/td><\/tr>
      Tenant<\/td>System Tenant (11)<\/td><\/tr>
      Organization<\/td>System Organization (11)<\/td><\/tr>
      Entity Type<\/td>D (Dictionary)<\/td><\/tr>
      Active<\/td>Yes<\/td><\/tr>
      Is Lot<\/td>No<\/td><\/tr>
      Is Lot Mandatory<\/td>No<\/td><\/tr>
      Is Serial No<\/td>No<\/td><\/tr>
      Is Serial No Mandatory<\/td>No<\/td><\/tr>
      Is Instance Attribute<\/td>No<\/td><\/tr>
      Guarantee Days<\/td>0<\/td><\/tr>
      Guarantee Date Mandatory<\/td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Purpose<\/strong><\/h3>\n\n\n\n

      The T-Shirt attribute set is used for fashion and apparel retail lines where inventory is distinguished by static product-level attributes (size, color) rather than tracked by lot or serial. No instance-level information is required at point of sale or dispatch.<\/p>\n\n\n\n

      Step 4: Configure Fertilizer Lot Attribute Set (Lot Tracking with Guarantee Date)<\/strong><\/h3>\n\n\n\n

      This configuration supports agrochemical and consumable products that require lot traceability and expiry date compliance.<\/p>\n\n\n\n

      Field<\/strong><\/td>Value<\/strong><\/td><\/tr><\/thead>
      Name<\/td>Fertilizer Lot<\/td><\/tr>
      Description<\/td>Lot Number and Guarantee Date<\/td><\/tr>
      Tenant<\/td>System Tenant (11)<\/td><\/tr>
      Organization<\/td>System Organization (11)<\/td><\/tr>
      Entity Type<\/td>D (Dictionary)<\/td><\/tr>
      Active<\/td>Yes<\/td><\/tr>
      Is Lot<\/td>Yes<\/td><\/tr>
      Is Lot Mandatory<\/td>Yes<\/td><\/tr>
      Lot Control<\/td>Lot Control ID: 100<\/td><\/tr>
      Is Serial No<\/td>No<\/td><\/tr>
      Is Serial No Mandatory<\/td>No<\/td><\/tr>
      Is Instance Attribute<\/td>No<\/td><\/tr>
      Guarantee Days<\/td>180<\/td><\/tr>
      Guarantee Date Mandatory<\/td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Purpose<\/strong><\/h3>\n\n\n\n

      The Fertilizer Lot attribute set ensures all fertilizer inventory movements carry a lot number and 180-day guarantee tracking. This is critical for agricultural retail compliance, stock rotation, and recall management.<\/p>\n\n\n\n

      Step 5: Configure Patio Chair Attribute Set (Instance Attributes with Serial No and Guarantee)<\/strong><\/h3>\n\n\n\n

      This configuration supports durable goods requiring individual unit tracking, warranty serial numbers, and guarantee date management.<\/p>\n\n\n\n

      Field<\/strong><\/td>Value<\/strong><\/td><\/tr><\/thead>
      Name<\/td>Patio Chair<\/td><\/tr>
      Description<\/td>Product: Size – Instance: Use Factor\/Description, SerialNo, Guarantee Date<\/td><\/tr>
      Tenant<\/td>System Tenant (11)<\/td><\/tr>
      Organization<\/td>System Organization (11)<\/td><\/tr>
      Entity Type<\/td>D (Dictionary)<\/td><\/tr>
      Active<\/td>Yes<\/td><\/tr>
      Is Lot<\/td>Yes<\/td><\/tr>
      Is Lot Mandatory<\/td>Yes<\/td><\/tr>
      Is Serial No<\/td>No<\/td><\/tr>
      Is Serial No Mandatory<\/td>No<\/td><\/tr>
      Is Instance Attribute<\/td>Yes<\/td><\/tr>
      Guarantee Days<\/td>60<\/td><\/tr>
      Guarantee Date Mandatory<\/td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Purpose<\/strong><\/h3>\n\n\n\n

      The Patio Chair attribute set tracks individual furniture units with instance-level attributes including use factor, description, and guarantee date. This supports warranty registration, returns processing, and customer-specific unit identification in retail showrooms and delivery operations.<\/p>\n\n\n\n

      Step 6: Save the Attribute Set Record<\/strong><\/h3>\n\n\n\n

      Click: Save (Alt+S or Save toolbar button)<\/p>\n\n\n\n

      The Attribute Set record is created and is now available for assignment to Product records and Attribute Use tab configuration.<\/p>\n\n\n\n

      Important: <\/strong>The record is saved successfully. The Attribute Set ID is auto-generated and the record becomes available in product master data.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Additional Configuration: Attribute Use Tab<\/strong><\/h2>\n\n\n\n

      The Attribute Use tab defines which individual Attribute records are linked to each Attribute Set and the display sequence in which they appear on inventory forms and receipts.<\/p>\n\n\n\n

      Step 1: Open Attribute Use Tab<\/strong><\/h3>\n\n\n\n

      With the Attribute Set record open, navigate to the child tab:<\/p>\n\n\n\n

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

      Step 2: Create Attribute Use Records<\/strong><\/h3>\n\n\n\n

      Click New Record for each attribute to associate. Enter the following fields:<\/p>\n\n\n\n

      Attribute Use Fields<\/strong><\/h3>\n\n\n\n
        \n
      • Tenant <\/strong>\u2014 Auto-populated from session context<\/li>\n\n\n\n
      • Organization <\/strong>\u2014 Availability scope for this attribute link<\/li>\n\n\n\n
      • Attribute Set <\/strong>\u2014 Read-only reference to the parent Attribute Set<\/li>\n\n\n\n
      • Attribute <\/strong>\u2014 The specific Attribute record to link (e.g., Size, Color)<\/li>\n\n\n\n
      • Active <\/strong>\u2014 Enables this attribute link for use<\/li>\n\n\n\n
      • Sequence <\/strong>\u2014 Display order on inventory entry forms (lower numbers appear first)<\/li>\n\n\n\n
      • Default Logic <\/strong>\u2014 Optional logic expression for default value generation<\/li>\n<\/ul>\n\n\n\n

        Step 3: Configure Attribute Use for T-Shirt<\/strong><\/h3>\n\n\n\n
        Attribute Set<\/strong><\/td>Attribute<\/strong><\/td>Sequence<\/strong><\/td>Active<\/strong><\/td><\/tr><\/thead>
        T-Shirt (ID: 100)<\/td>Color (Attribute ID: 101)<\/td>10<\/td>Yes<\/td><\/tr>
        T-Shirt (ID: 100)<\/td>Size (Attribute ID: 100)<\/td>20<\/td>Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Both Color and Size are product-level attributes for T-Shirt. Color appears first (sequence 10) followed by Size (sequence 20) on inventory entry dialogs.<\/p>\n\n\n\n

        Step 4: Configure Attribute Use for Fertilizer Lot<\/strong><\/h3>\n\n\n\n
        Attribute Set<\/strong><\/td>Attribute<\/strong><\/td>Sequence<\/strong><\/td>Active<\/strong><\/td><\/tr><\/thead>
        Fertilizer Lot (ID: 101)<\/td>Guarantee Date Attribute (ID: 101)<\/td>10<\/td>Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Step 5: Configure Attribute Use for Patio Chair<\/strong><\/h3>\n\n\n\n
        Attribute Set<\/strong><\/td>Attribute<\/strong><\/td>Sequence<\/strong><\/td>Active<\/strong><\/td><\/tr><\/thead>
        Patio Chair (ID: 102)<\/td>Size (Attribute ID: 100)<\/td>10<\/td>Yes<\/td><\/tr>
        Patio Chair (ID: 102)<\/td>Use Factor\/Description (ID: 102)<\/td>20<\/td>Yes<\/td><\/tr>
        Patio Chair (ID: 102)<\/td>Instance Detail Attribute (ID: 103)<\/td>30<\/td>Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        The Patio Chair has three attribute use records covering size (product level) and two instance-level attributes displayed in sequence on each inventory movement form.<\/p>\n\n\n\n

        Step 6: Save Attribute Use Records<\/strong><\/h3>\n\n\n\n
        Save (after each Attribute Use record)<\/td><\/tr>
        Important: <\/strong>Attribute Use records are saved. The attribute set is now fully configured and attributes will appear on inventory entry dialogs in the defined sequence.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Configuration Examples<\/strong><\/h2>\n\n\n\n
        Attribute Set Name<\/strong><\/td>Description Summary<\/strong><\/td>Lot<\/strong><\/td>Serial No<\/strong><\/td>Instance<\/strong><\/td>Guarantee Days<\/strong><\/td><\/tr><\/thead>
        T-Shirt<\/td>Size and Color classification; no tracking<\/td>No<\/td>No<\/td>No<\/td>0<\/td><\/tr>
        Fertilizer Lot<\/td>Lot number with 180-day guarantee compliance<\/td>Yes<\/td>No<\/td>No<\/td>180<\/td><\/tr>
        Patio Chair<\/td>Size + instance attributes, lot, 60-day guarantee<\/td>Yes<\/td>No<\/td>Yes<\/td>60<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Business Flow Overview<\/strong><\/h2>\n\n\n\n

        Attribute Sets are foundational to inventory traceability across the entire retail supply chain. They are assigned at the product level and enforce attribute capture at each inventory movement.<\/p>\n\n\n\n

        For lot-controlled products such as Fertilizer, the lot number is captured on Goods Receipt and propagated through all warehouse movements, shipments, and invoices. For instance-attributed products such as Patio Chair, individual unit details are recorded at each touch point.<\/p>\n\n\n\n

        Validation<\/strong><\/h2>\n\n\n\n

        After saving the Attribute Set and Attribute Use records, perform the following validation checks:<\/p>\n\n\n\n

          \n
        • Attribute Set record is Active and visible in product master Attribute Set lookup<\/li>\n\n\n\n
        • Attribute Use tab shows all linked attributes with correct sequence numbers<\/li>\n\n\n\n
        • When assigning the Attribute Set to a product and processing a receipt, the attribute entry dialog appears correctly<\/li>\n\n\n\n
        • Lot Number field is mandatory on Goods Receipt for Fertilizer Lot attribute set<\/li>\n\n\n\n
        • Guarantee Date is populated automatically based on Guarantee Days configuration<\/li>\n\n\n\n
        • Instance attributes (Use Factor, Description) appear on the Patio Chair inventory instance dialog<\/li>\n<\/ul>\n\n\n\n

          Common Issues<\/strong><\/h2>\n\n\n\n
          Issue<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
          Attribute Set not visible in Product master lookup<\/td>Verify the Attribute Set record is Active and Organization is set to * or the correct org<\/td><\/tr>
          Lot number field not appearing on Goods Receipt<\/td>Confirm Is Lot is set to Yes on the Attribute Set and the product has the attribute set assigned<\/td><\/tr>
          Attributes not showing in correct order<\/td>Review Sequence numbers in Attribute Use tab; lower sequence numbers appear first<\/td><\/tr>
          Guarantee Date not auto-calculated<\/td>Verify Guarantee Days is greater than 0 and the product has the correct Attribute Set<\/td><\/tr>
          Instance attributes missing from inventory dialog<\/td>Confirm Is Instance Attribute is enabled on the Attribute Set<\/td><\/tr>
          Changes to attribute set not reflected in open orders<\/td>Run Cache Reset (System Admin) and re-login; existing transaction lines may require manual update<\/td><\/tr>
          Attribute Use record saves but attribute not active<\/td>Set Active = Yes on both the Attribute record and the Attribute Use record<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

          Best Practices<\/strong><\/h2>\n\n\n\n
            \n
          • Design Attribute Sets per product family, not per individual product, to reduce proliferation<\/li>\n\n\n\n
          • Use descriptive names that communicate both the product type and tracking level (e.g., Fertilizer Lot, Apparel No Track)<\/li>\n\n\n\n
          • Set Organization = * for all shared Attribute Sets to ensure availability across multi-org retail structures<\/li>\n\n\n\n
          • Configure Mandatory Type = Always only for regulatory compliance scenarios to avoid unnecessary data entry friction<\/li>\n\n\n\n
          • Use Guarantee Days consistently across similar product families to simplify expiry management<\/li>\n\n\n\n
          • Document Attribute Use sequence numbers in a separate configuration register for traceability during system audits<\/li>\n\n\n\n
          • Test each Attribute Set configuration with a real inventory transaction before assigning to production products<\/li>\n<\/ul>\n\n\n\n
            Important: <\/strong>Do not modify the Attribute Set of a product that already has posted inventory transactions. This can cause attribute mismatch errors on downstream documents. Create a new Attribute Set and re-assign to new product records if a configuration change is needed.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

            Next Steps<\/strong><\/h2>\n\n\n\n

            After completing Attribute Set configuration, continue with<\/p>\n\n\n\n

              \n
            • Product \u2014 Assign the configured Attribute Set to each product master record<\/li>\n\n\n\n
            • Lot Control \u2014 Configure lot number generation formats referenced by Attribute Sets<\/li>\n\n\n\n
            • Serial No Control \u2014 Configure serial number formats for serialized inventory<\/li>\n\n\n\n
            • Product Category \u2014 Verify product categories align with planned Attribute Set assignment<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

              Learn how Attribute Sets in iDempiere help distribution businesses manage product characteristics such as size, color, lot numbers, serial numbers, […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[67,68],"tags":[],"class_list":["post-18667","post","type-post","status-publish","format-standard","hentry","category-retail","category-masters"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18667","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=18667"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18667\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}