How to Configure Price List in iDempiere for Retail
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.
Process Flow
Step-by-Step Configuration
Step 1: Open Price List Window
Navigate to the menu path above. The window displays all existing Price List records, including any system-provided defaults.
Step 2: Create New Record
Click New Record (+) to open a blank form. Enter the required values.
Field Reference
- Name — Full display name of the Price List
- Description — Business purpose or usage context
- Currency — Transaction currency for this Price List
- Price Precision — Number of decimal places for prices
- Active — Enables the Price List for use in transactions
- Sales Price List — Makes the Price List available in customer sales transactions
- Default — Automatically selects this Price List during transaction creation
- Price Includes Tax — Determines whether entered prices already include tax
- Enforce Price Limit — Restricts transactions from going below configured price limits
- Base Price List — Optionally inherit pricing from another Price List
Step 3: Configure Purchase Price List
Enter the following values for the Purchase Price List:
| Field | Value |
| Name | Purchase Price List |
| Description | Purchase prices used for supplier transactions |
| Currency | INR |
| Price Precision | 2 |
| Active | Yes |
| Sales Price List | No |
| Price Includes Tax | No |
| Default | No |
| Enforce Price Limit | No |
Used for procurement transactions where product purchase prices are maintained for suppliers and vendor purchases.
Step 4: Configure Standard Sales Price List
Enter the following values for the Standard Sales Price List:
| Field | Value |
| Name | Standard Sales Price List |
| Description | Standard selling prices for customer transactions |
| Currency | INR |
| Price Precision | 2 |
| Active | Yes |
| Sales Price List | Yes |
| Price Includes Tax | Yes |
| Default | Yes |
| Enforce Price Limit | No |
Used as the primary customer selling Price List for POS, Sales Orders, and customer billing transactions.
Step 5: Configure Wholesale Sales Price List
Enter the following values for the Wholesale Sales Price List:
| Field | Value |
| Name | Wholesale Sales Price List |
| Description | Bulk and dealer selling prices |
| Currency | INR |
| Price Precision | 2 |
| Active | Yes |
| Sales Price List | Yes |
| Price Includes Tax | Yes |
| Default | No |
| Enforce Price Limit | No |
Used for dealer and bulk customer pricing where products may be sold at special negotiated prices.
Step 6: Configure Promotional Sales Price List
Enter the following values for the Promotional Sales Price List:
| Field | Value |
| Name | Promotional Sales Price List |
| Description | Promotional and seasonal selling prices |
| Currency | INR |
| Price Precision | 2 |
| Active | Yes |
| Sales Price List | Yes |
| Price Includes Tax | Yes |
| Default | No |
| Enforce Price Limit | No |
Used during seasonal campaigns, festival offers, promotional activities, and temporary pricing events.
Step 7: Save Record
Click Save after entering all values. The Price List record is immediately available for Price List Version and Product Price configuration.
Save.
Common Field Reference
The following fields are used consistently across all Price List records:
- Active — Enables the Price List and makes it available in transactions.
- Sales Price List — Makes the Price List available in customer sales transactions.
- Default — Automatically selects the Price List during transaction creation.
- Currency — Defines the transaction currency.
- Price Precision — Controls decimal precision for prices.
- Price Includes Tax — Determines whether the entered price already contains tax.
- Enforce Price Limit — Restricts transactions below configured pricing limits.
| Price Includes Tax — Example Entered Price = ₹1050 | GST = 5% | Base Price = ₹1000 | Tax = ₹50 | Customer Price = ₹1050 |
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.
System Price List Guidance
A system-generated Standard Price List may already exist in iDempiere after initial setup.
| Important Keep the system record unchanged. Do not delete system-created records. Use business-specific Price Lists for operational usage. |
- Keep the system record unchanged
- Do not delete system-created records
- Use business-specific Price Lists for operational usage
Common Issues
| Issue | Resolution |
| Price List not available during transaction | Verify Active checkbox is enabled |
| Price List unavailable in sales transaction | Verify Sales Price List checkbox is enabled |
| Product price not populated automatically | Verify Price List Version and Product Price setup |
| Wrong Price List selected automatically | Verify the Default checkbox configuration |
| Unexpected tax calculation in transactions | Verify Price Includes Tax setting for the Price List |
Next Steps
After completing Price List configuration, continue with:
- Price List Version — Define effective date ranges and activate the Price List for transactions
- Product Price — Enter individual product prices within each Price List Version
- Product Setup — Assign Price Lists to product categories and individual products