Apply Discount on Discounted Rate on Item Line by Line

ERPNext
, ,
1

Hi, I want to give multiple discounts on the item line by line in the ERPNext Sales Invoice.

For example (The scenario I want),
An Item A (Selling Rate): MMK 500,000
Giving 5% discount on it: 500,000 * 5% = 25,000
After that, the selling rate will be 500,000 - 25,000 = MMK 475,000

Moreover, I want to give another 2% discount on the discounted rate.
Giving 2%: 475,000 * 2% = 9,500
Then, the selling rate will be 475,000 - 9,500 = MMK 465,500

To set up the discount rule in ERPNext, I used Pricing Rule by enabling “Apply Multiple Pricing Rules” and “Apply Discount on Discounted Rate” with two pricing rules. But it does not work as I expected.
It calculates as follows.
Instead of calculating as in the above scenario, the system assumes it with 7%. Thus, the output became giving the discount on 500,000 * 7% = 35,000 = 500,000 - 35,000 = MMK 465,000.

Please kindly check my shared Google Docs to see the pricing rules setup I made in ERPNext.

Really appreciate your anticipation.

2

Hi @kowaiyan

Both types of discount are available on Sales Invoice doctype;

  1. Item level
  2. Document level

You can first offer discount on line level working within item table as following;

image
image1393Ă—865 56.1 KB

and then discounted rate can be further applied with discount by working with Document Level discount as in below screen shot;

image
image1210Ă—875 41.9 KB

The pricing rule works on top of item pricing and may help if there are multiple items involved and discount percentage varies.

1 Like
3

Thanks @ahsantareen
I gave the solution you provided to my client, but she did not accept that solution as she does not want to create an invoice for each item, and she wants to create multiple items with different multi-level discounts in one invoice.

I think the direct solution would be in the Pricing Rule with the “Apply Discount on Discounted Rate” option. But it is not working from our sites. If you have any answer on that, please kindly guide me.

I really appreciate your time on this. It helps me a lot.