Multiple Price List Rates
YouTube: How to Configure Multiple Price List Item Rates in Sale Order?
How to Configure Multiple Price List Item Rates in Sale Order?
This tutorial explains how to configure and use Multiple Price List Rates in the Sales Order module in Logic ERP. This feature helps automate pricing based on formulas, party, item group, and markdown rules—making billing faster, more accurate, and flexible.
Objective of This Feature
Automate pricing using predefined formulas
Apply different rates based on Party and Item Group
Enable multiple pricing strategies in one system
Reduce manual calculation errors
Improve efficiency in Sales Order processing
Access to Sales Order Configuration
Navigate to Sales Order Module
Click on Configuration
Select the relevant Sales Order Configuration
Locate the option labeled as:
Multi Price List Rates
In this section, you will find four options. Let’s understand each of them one by one.
None
Multi Price List Rates
Party + Item Groups Defaults
Party + Item Markdowns
To enable Multiple lists in Sale Order, define Multi Price list Rate as None.
Note
Before using it in transactions, backend configuration is required
Define Multiple Price List Rates
Navigate to Setup and expand Set Other Item Details
Open Define Multiple Price Lists Module
Enter the Expense Name and Save
Open Defined Formula Tab
Create a Configuration Name
Select Base Rate (e.g., MRP)
Enter Default Value
Choose Calculation Method (e.g., Percentage)
Verify in Sales Order
Open Sales Order Window
Select the configured Price List
Select the relevant item from the list.
System Behavior
Example:
MRP = ₹4,000
Formula = MRP – 20%
Final Sale Rate = ₹3,200
Define Party + Item Group Defaults
Define Sale Order Configuration
Go back to the Sales Order Configuration and open the Price List Rates section.
Then, Set the option to "Party + Item Groups Defaults".
Define Item-wise Price List Module
Navigate to Setup and expand Set Other Item Details
Open "Define Item Wise Price Lists".
Define:
Price List
Expense Name
Under Price List Configuration:
Select Price List
Choose Base Rate
Select Expense
Define Party + Item Group Defaults
Navigate to Define Party + Item Group Defaults (PL Elements)
Select:
Item Group (e.g., Jeans)
Account / Account Group
Click Refresh and Define Expense Value
Implement in Sales Order
Open Sales Order Window
Select the configured Price List
Select Item belongs to Shirt Category
Result
Rate calculated as: MRP – 30% (as per configuration)
Tip: Press F4 on rate field to view price list details
Party + Item Markdown Setup
Define Sale Order Configuration
Go back to the Sales Order Configuration and open the Price List Rates section.
Then, Set the option to "Party + Item Markdowns".
Define Party + Company + Group/Item Wise Tax/Markdowns
Navigate to Setup and expand Set Other Item Details
Open Define Party + Company + Group/Item Wise Tax/Markdowns
Select Party
Select Entry Type (Company + Group wise / Item wise)
Select Relevant Items/Groups
Enter Markdown %
Save
Verify Markdown in Sales Order
Select MRP as Price List
System Behavior
Example:
Markdown = 5% on MRP
Final Rate = MRP – 5%
Important
Markdowns are always applied on MRP values only
Key Benefits
Automated and flexible pricing system
Customer-specific and item-specific rates
Reduced manual work and errors
Faster Sales Order processing
Best Practice Tips
Always verify base rate before applying formulas
Use proper naming for price lists and expenses
Regularly update configurations as per business needs
Use F4 key to audit applied pricing logic
Final Outcome
Pricing is automatically calculated based on rules
Sales Orders become faster and more accurate
Users get better control over pricing strategies
Overall efficiency and productivity are improved
Last updated