Applying Margin on Quotation and Sales Order Items in ERPNext
ERPNext allows businesses to apply profit margins on Quotation and Sales Order items either automatically using Pricing Rules or manually for individual items. This helps ensure consistent pricing while maintaining desired profit margins.
A margin is the additional amount or percentage added to an item’s Price List Rate to determine its selling price. ERPNext supports both centralized margin management through Pricing Rules and manual margin entry directly within sales transactions.
1. Methods to Apply Margin
There are two ways to apply margins in ERPNext:
- Using Pricing Rules (Automatic)
- Applying Margin Directly on Items (Manual)
2. Method 1: Apply Margin Using Pricing Rules
Pricing Rules allow you to automatically apply margins whenever predefined conditions are met. This method is ideal for organizations that want standardized pricing across customers, products, or transactions.
Navigate to:
Selling → Setup → Pricing Rule
or
Accounts → Setup → Pricing Rule
Configure Margin
Within the Pricing Rule, configure the following:
- Select Margin Type:
- Percentage
- Amount
- Enter the corresponding Margin Percentage or Margin Amount.
- Define the conditions under which the Pricing Rule should apply.
Pricing Rules apply the margin only when the rule conditions are satisfied and the Pricing Rule is active.
3. Item Price Requirement
Margin calculations are always based on the item’s Price List Rate.
Therefore, each item should have an Item Price defined before applying a margin through a Pricing Rule.
Navigate to:
Selling → Setup → Item Price
or
Stock → Setup → Item Price
ERPNext calculates the selling price using the following formula:
Rate = Price List Rate + Margin
Example:
- Price List Rate = ₹1,000
- Margin = ₹200
- Final Selling Rate = ₹1,200
4. Method 2: Apply Margin Directly on an Item
If you don’t want to use Pricing Rules, ERPNext also allows margins to be entered manually for individual items in Quotations and Sales Orders.
Navigate to:
Selling → Quotation
(or create a Sales Order directly)
After adding an item, expand the item row and configure:
- Margin Type (Percentage or Amount)
- Margin Value
ERPNext immediately recalculates the item’s selling rate based on the entered margin.
5. Pricing Rule vs Manual Margin
| Pricing Rule | Manual Margin |
|---|---|
| Automatically applies margins. | Entered individually for each item. |
| Uses predefined business conditions. | No predefined conditions required. |
| Ensures consistent pricing. | Provides flexibility for special quotations. |
| Suitable for recurring pricing policies. | Suitable for one-time negotiations. |
6. Benefits of Margin Management
- Ensures consistent profit margins across products.
- Reduces manual pricing errors.
- Supports automated pricing using business rules.
- Allows flexible pricing during negotiations.
- Maintains accurate selling prices based on Item Price Lists.
SUMMARY
ERPNext provides two approaches for applying margins on Quotation and Sales Order items. Pricing Rules automatically calculate margins based on predefined conditions, while manual margin entry offers flexibility for individual transactions. In both cases, the final selling rate is calculated from the item’s Price List Rate, ensuring consistent and profitable pricing.
