{"id":18621,"date":"2026-05-28T11:15:09","date_gmt":"2026-05-28T11:15:09","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=18621"},"modified":"2026-07-17T05:40:26","modified_gmt":"2026-07-17T05:40:26","slug":"how-to-configure-price-list-in-idempiere-for-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-price-list-in-idempiere-for-retail\/","title":{"rendered":"How to Configure Price List in iDempiere for Retail"},"content":{"rendered":"\n

The Price List window is used to define pricing structures used during purchase and sales transactions. Price Lists determine how products are priced and provide separate pricing models for procurement, retail sales, wholesale customers, and promotional activities.<\/p>\n\n\n\n

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

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

Step 1: Open Price List Window<\/strong><\/h3>\n\n\n\n

Navigate to the menu path above. The window displays all existing Price List records, including any system-provided defaults.<\/p>\n\n\n\n

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

Click New Record (+) to open a blank form. Enter the required values.<\/p>\n\n\n\n

Field Reference<\/strong><\/h3>\n\n\n\n
    \n
  • Name \u2014 <\/strong>Full display name of the Price List<\/li>\n\n\n\n
  • Description \u2014 <\/strong>Business purpose or usage context<\/li>\n\n\n\n
  • Currency \u2014 <\/strong>Transaction currency for this Price List<\/li>\n\n\n\n
  • Price Precision \u2014 <\/strong>Number of decimal places for prices<\/li>\n\n\n\n
  • Active \u2014 <\/strong>Enables the Price List for use in transactions<\/li>\n\n\n\n
  • Sales Price List \u2014 <\/strong>Makes the Price List available in customer sales transactions<\/li>\n\n\n\n
  • Default \u2014 <\/strong>Automatically selects this Price List during transaction creation<\/li>\n\n\n\n
  • Price Includes Tax \u2014 <\/strong>Determines whether entered prices already include tax<\/li>\n\n\n\n
  • Enforce Price Limit \u2014 <\/strong>Restricts transactions from going below configured price limits<\/li>\n\n\n\n
  • Base Price List \u2014 <\/strong>Optionally inherit pricing from another Price List<\/li>\n<\/ul>\n\n\n\n

    Step 3: Configure Purchase Price List<\/strong><\/h3>\n\n\n\n

    Enter the following values for the Purchase Price List:<\/p>\n\n\n\n

    Field<\/strong><\/td>Value<\/strong><\/td><\/tr><\/thead>
    Name<\/td>Purchase Price List<\/td><\/tr>
    Description<\/td>Purchase prices used for supplier transactions<\/td><\/tr>
    Currency<\/td>INR<\/td><\/tr>
    Price Precision<\/td>2<\/td><\/tr>
    Active<\/td>Yes<\/td><\/tr>
    Sales Price List<\/td>No<\/td><\/tr>
    Price Includes Tax<\/td>No<\/td><\/tr>
    Default<\/td>No<\/td><\/tr>
    Enforce Price Limit<\/td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Used for procurement transactions where product purchase prices are maintained for suppliers and vendor purchases.<\/p>\n\n\n\n

    Step 4: Configure Standard Sales Price List<\/strong><\/h3>\n\n\n\n

    Enter the following values for the Standard Sales Price List:<\/p>\n\n\n\n

    Field<\/strong><\/td>Value<\/strong><\/td><\/tr><\/thead>
    Name<\/td>Standard Sales Price List<\/td><\/tr>
    Description<\/td>Standard selling prices for customer transactions<\/td><\/tr>
    Currency<\/td>INR<\/td><\/tr>
    Price Precision<\/td>2<\/td><\/tr>
    Active<\/td>Yes<\/td><\/tr>
    Sales Price List<\/td>Yes<\/td><\/tr>
    Price Includes Tax<\/td>Yes<\/td><\/tr>
    Default<\/td>Yes<\/td><\/tr>
    Enforce Price Limit<\/td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Used as the primary customer selling Price List for POS, Sales Orders, and customer billing transactions.<\/p>\n\n\n\n

    Step 5: Configure Wholesale Sales Price List<\/strong><\/h3>\n\n\n\n

    Enter the following values for the Wholesale Sales Price List:<\/p>\n\n\n\n

    Field<\/strong><\/td>Value<\/strong><\/td><\/tr><\/thead>
    Name<\/td>Wholesale Sales Price List<\/td><\/tr>
    Description<\/td>Bulk and dealer selling prices<\/td><\/tr>
    Currency<\/td>INR<\/td><\/tr>
    Price Precision<\/td>2<\/td><\/tr>
    Active<\/td>Yes<\/td><\/tr>
    Sales Price List<\/td>Yes<\/td><\/tr>
    Price Includes Tax<\/td>Yes<\/td><\/tr>
    Default<\/td>No<\/td><\/tr>
    Enforce Price Limit<\/td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Used for dealer and bulk customer pricing where products may be sold at special negotiated prices.<\/p>\n\n\n\n

    Step 6: Configure Promotional Sales Price List<\/strong><\/h3>\n\n\n\n

    Enter the following values for the Promotional Sales Price List:<\/p>\n\n\n\n

    Field<\/strong><\/td>Value<\/strong><\/td><\/tr><\/thead>
    Name<\/td>Promotional Sales Price List<\/td><\/tr>
    Description<\/td>Promotional and seasonal selling prices<\/td><\/tr>
    Currency<\/td>INR<\/td><\/tr>
    Price Precision<\/td>2<\/td><\/tr>
    Active<\/td>Yes<\/td><\/tr>
    Sales Price List<\/td>Yes<\/td><\/tr>
    Price Includes Tax<\/td>Yes<\/td><\/tr>
    Default<\/td>No<\/td><\/tr>
    Enforce Price Limit<\/td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Used during seasonal campaigns, festival offers, promotional activities, and temporary pricing events.<\/p>\n\n\n\n

    Step 7: Save Record<\/strong><\/h3>\n\n\n\n

    Click Save after entering all values. The Price List record is immediately available for Price List Version and Product Price configuration.<\/p>\n\n\n\n

    Save.<\/p>\n\n\n\n

    Common Field Reference<\/strong><\/h2>\n\n\n\n

    The following fields are used consistently across all Price List records:<\/p>\n\n\n\n

      \n
    • Active \u2014 Enables the Price List and makes it available in transactions.<\/li>\n\n\n\n
    • Sales Price List \u2014 Makes the Price List available in customer sales transactions.<\/li>\n\n\n\n
    • Default \u2014 Automatically selects the Price List during transaction creation.<\/li>\n\n\n\n
    • Currency \u2014 Defines the transaction currency.<\/li>\n\n\n\n
    • Price Precision \u2014 Controls decimal precision for prices.<\/li>\n\n\n\n
    • Price Includes Tax \u2014 Determines whether the entered price already contains tax.<\/li>\n\n\n\n
    • Enforce Price Limit \u2014 Restricts transactions below configured pricing limits.<\/li>\n<\/ul>\n\n\n\n
      Price Includes Tax \u2014 Example<\/strong> Entered Price = \u20b91050 | GST = 5% | Base Price = \u20b91000 | Tax = \u20b950 | Customer Price = \u20b91050<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Base Price List: Used to inherit pricing from another Price List. Not required for the current implementation and can be configured later if pricing inheritance is needed.<\/p>\n\n\n\n

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

      System Price List Guidance<\/strong><\/h2>\n\n\n\n

      A system-generated Standard Price List may already exist in iDempiere after initial setup.<\/p>\n\n\n\n

      Important<\/strong> Keep the system record unchanged. Do not delete system-created records. Use business-specific Price Lists for operational usage.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        \n
      • Keep the system record unchanged<\/li>\n\n\n\n
      • Do not delete system-created records<\/li>\n\n\n\n
      • Use business-specific Price Lists for operational usage<\/li>\n<\/ul>\n\n\n\n

        Common Issues<\/strong><\/h2>\n\n\n\n
        Issue<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
        Price List not available during transaction<\/td>Verify Active checkbox is enabled<\/td><\/tr>
        Price List unavailable in sales transaction<\/td>Verify Sales Price List checkbox is enabled<\/td><\/tr>
        Product price not populated automatically<\/td>Verify Price List Version and Product Price setup<\/td><\/tr>
        Wrong Price List selected automatically<\/td>Verify the Default checkbox configuration<\/td><\/tr>
        Unexpected tax calculation in transactions<\/td>Verify Price Includes Tax setting for the Price List<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

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

        After completing Price List configuration, continue with:<\/p>\n\n\n\n

          \n
        • Price List Version \u2014 Define effective date ranges and activate the Price List for transactions<\/li>\n\n\n\n
        • Product Price \u2014 Enter individual product prices within each Price List Version<\/li>\n\n\n\n
        • Product Setup \u2014 Assign Price Lists to product categories and individual products<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

          The Price List window is used to define pricing structures used during purchase and sales transactions. Price Lists determine how […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67,68],"tags":[],"class_list":["post-18621","post","type-post","status-publish","format-standard","hentry","category-retail","category-masters"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18621","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=18621"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18621\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}