Creating a Pricing Rule
Pricing Rule
A Pricing Rule defines the discount/pricing rules that apply based on set conditions.
A Pricing Rule has many options using which you can control the pricing of an Item. Filters like quantity, date, groups, and other conditions can be set.
A Pricing Rule is somewhat similar to a Tax Rule.
Following are the few cases which can be addressed using Pricing Rule:
As per a promotional sale policy, if the Customer purchases more than 10 units of an item, he enjoys 20% discount.
For Customer "XYZ", the selling price for the specific Item should be updated as ###.
Items categorized under specific Item Group have same selling or buying price.
Customers belonging to specific Customer Group should get ### selling price, or % of Discount on Items.
Supplier categorized under specific Supplier Group should have ### buying rate applied.
To have Discount and Price List Rate for an Item auto-applied, create Pricing Rules for it.
To access the Pricing Rule list, go to:
Home > Accounting > Pricing Rule
1. Prerequisites
Before creating and using a Pricing Rule, it is advisable to create the following first:
Item
Item Group
Customer
Supplier
2. How to create a Pricing Rule
Go to the Pricing Rule list and click on New.
Set a title for the rule.
Select what to Apply On from Item Code, Item Group, Brand, or Transaction.
Select whether you want to apply Price discount or Product discount. If you want to give free products then select the product discount.
For a single item, select Item Code and select the items.
If you want Pricing Rule to be applied on all the items, select 'Item Group' and select All Item Group (parent Item Group).
Set the discount/price to be applied.
Save
Additional options when creating a Pricing Rule
Warehouse
Setting a Warehouse here will cause the Pricing Rule to be applied only if the Item is selected from the Warehouse specified here.
Apply Rule On
Based on the attribute selected in the 'Apply On' field, you can set the Pricing Rule based on one of these:
Item
Item Group
Brand
Transaction (on the total amount of the transaction)
In this table, you can select the specific Item/Item Group/Brand. For example, if you select Apply On 'Item Group' and select 'Raw Materials' in the table, this Pricing Rule will be applied only on Items that belong to the Group 'Raw Materials'.
UoM: The Pricing Rule will apply only if the UoM set here matches with the transaction.
Condition
In this field you can add a condition in python to check against field values in the transaction doctype, like shown below for Sales Invoice:
customer=='Customer Name' and status!='Overdue'
Please note that only single line python conditions will work, using fieldnames of the target doctype.
Mixed Conditions
If you select two or more Items and set the Min and Max Quantity. The Pricing Rule will be applied only if the total sum of Items matches the set quantities. For example, you create a Pricing Rule on Item 1 and Item 2 and set the Min and Max Quantity as 30, the Pricing Rule will apply only if the total quantity is 30.
Is Cumulative
Enabling this options allows the Pricing Rule to be applied cumulatively. You need to set the 'Min Amt' and 'Max Amt' for this.
Consider a scenario where the Min Amt is 1,500 and Max Amt is 2,000. Now, if one transaction is created for 1,400 then Pricing Rule will not be applied. However, on creating a second invoice of amount 600, Pricing Rule will be applied. This happened since the total (cumulative) amount of the invoices added up to 2,000. Note that the discount will be applied only to the latest transaction that crosses the cumulative limit.
This can be useful to give discounts if a Customer buys an Item multiple times and you want to reward him with discounts/special prices.
3. Features
Apply Rule On Other
This feature checks condition on first Item but applies rule on another Item.
For example, set Item1 and Item2 in the 'Apply Rule On' table and set 'Apply Rule On Other' on Item3. Now, if the transaction has Item1, Item2, and Item3, the Pricing Rule will apply on Item3 since the first two Items were present in the transaction.
Party Information
Set whether the Pricing Rule is for Selling of Buying the Item.
Based on your selection you can set applicability to one of the following masters.
Customer
Customer Group
Territory
Sales Partner
Campaign
Supplier
Supplier Group
Quantity and Amount
Specify minimum qty, maximum qty, minimum amount, or maximum amount of an Item when this Pricing Rule should be applied.
Note that if the quantity or amount falls short or exceeds the limits set here, the Pricing Rule will not be applied at all. However, it will be applied if you have enabled the options Mixed Conditions or Cumulative.
Validity
You can also set a date interval for when the Pricing Rule will be valid. This is useful for a sales promotion. On leaving the dates blank the Pricing Rule will not have any time frame limit.
Margin
Margin Type: When selling an Item, you may sell it for a certain margin. If you don't want to add selling prices to Items every time and would like to automatically set a margin, it can be done with this feature.
Margin Rate or Amount: The margin set can be based on Percentage or Amount, eg: 5% margin or $50 fixed margin.
Price Discount Scheme
The actual rule to be applied is set in this section.
Rate: This will be the new rate for an Item. For example, if you sell an Item for 100 and want to sell it for 112 for a specific party, then select Rate and set the Rate as 112.
Discount Percentage: A specific discount percentage can be set. The discount percentage can be set to a specific Price List. Leaving the 'For Price List' blank will apply the Pricing Rule to all Price Lists.
Discount Amount: A fixed discount amount will be applied. For example if you sell an Item for 100 and want to sell it with a discount of 7, then this condition can be set using the Discount Amount option.
Advanced Settings
Threshold for Suggestion: This is the threshold based on which the system will notify you to adjust Item Quantity for discount. For example, if the Min Quantity is 10 and the Threshold is 9, the system will notify to add 1 more Item for the discount to be applicable. This also applies to the amount set.
Priority: Consider an Item Group, you want to set specific rules on one Item from the group. This can be done by creating a new Pricing Rule and setting a higher priority. This can also apply to Customer Group and Supplier Group.
Apply Multiple Pricing Rules: To understand this, consider an Item of Rate 500. There are two Pricing Rules on it P1 and P2. P1 applies 10% discount and P2 applies 5%. Enabling this option will apply a total of 15% on the Item Rate which gives 425.
Apply Discount on Rate: The discount will be compounded. Consider the same scenario as above. On enabling this option, 10% will be applied on 500 which will give 450, then 5% will be applied on 450 which will give 427.5.
Validate Applied Rule: Shows the entered validation message if the discount/rate set manually by you in a transaction does not match the Pricing Rule.
This is useful when the top distributor in the hierarchy decides the discount/rate to be applied and you are only validating if the Pricing Rule is applied correctly.
4. Pricing Rule discount types
Price Discount
Under the Margin Type, you can set whether the margin is calculated as a percentage or an amount. Eg: 10% margin on supplier price list at the time of sales.
Rate mentioned in Pricing Rule will be given priority over Item's Price List (Item Price) rate.
Discount Percentage can be applied for a specific Price List (Selling or Buying). To apply it for both, leave the 'For Price List' field blank.
Discount can also be set in terms of amount.
Product Discount
"Buy 2 quantities get 1 free quantity of the same item." To configure such type of rules, set the Price or Product Discount as 'Product discount', tick the Same Item checkbox, and set the quantity.
"Buy 2 quantities get 1 free quantity of the another item." To configure such type of rules. Set the Price or Product Discount as Product discount, untick the 'Same Item' checkbox and set the 'Free Item' and quantity.
Updated on: 27/03/2023
Thank you!