Dear Nabin,
My main concern is on the final net price that is being calculated.
Unit Net Price = Price List Rate - Pricing Rule Discount %
Total Net Price = Quantity x Unit Net Price
Often, the Unit Net Price is known upfront and the Discount % is calculated based on the Unit Net Price. Based on the current design, I will have to calculate the Discount % and round it up to 3 decimal places to maintain the Pricing Rule in the system. There is a chance that I will not be able to achieve the desired Unit Net Price and Total Net Price based on the Discount % entered in the Pricing Rule due to decimal rounding issues.
For our scenario, it would be better if there was a feature to enter absolute value discounts instead of % so I can just calculate the difference between the Price List Rate and Unit Net Price and enter that value as the Discount Amount, instead of converting it to % - in fact I actually have raised a feature request at
https://github.com/frappe/erpnext/issues/2034 for this.
As a workaround, we were hoping to use the pricing rule made for "price" feature, but the drawback is that it doesn't show the original Price List Rate in the Sales Order and eventually, the Customer will not know the discount % given to them as it can't be shown in the Sales Order printout.
Is there any other way we can achieve this?
Thanks real much.
Javier