Total discount given using a price list


I’m trying to build a feature to add a maximum amount against a pricing rule that you can only use this pricing rule for cumulative this amount for example if I’ve created 3 invoices using this pricing rule with the cumulative amount of 40K and given a maximum amount in pricing rule is 50K then the pricing rule only works for 10K or within 10K amount of sales invoice.
So is there any way to find how many invoices are created or how much discount is given by a price list?

I really appreciate any help you can provide.

Have you tried using filters in Invoice list?

I’m not sure exactly what you’re looking for, but you can filter by name of pricing rule and discount amount, like below.

Screenshot 2024-06-15 at 12.17.33 PM

You can also save this filter or create a report based on this info and add any criteria.

1 Like

Thanks! @volkswagner I got this and also completed my implementation