Pricing Rule made for "Price" overwrites Price List Rate

Dear Experts,

I understand that by design the Pricing Rule if made for "Price" will overwrite the Price List Rate. 

Is there a way we can show the original Price List Rate in documents such as Sales Orders and Sales Invoices? Basically the objective is to show the difference in price (discount) given to a particular customer.

Again, thanks very much for all your help.


Javier



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/bdca6e5c-3b7f-4356-9ba6-15af0273a7c6%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Why you do not define pricing rule for discount instead of for price? That way you can show both price list rate and discount in the transactions.

On Sep 16, 2014, at 3:31 PM, Javier <bo...@gmail.com> wrote:

particular



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/E09ECD3D-8610-45D0-A5D7-5A5A26F8CB62%40iwebnotes.com.

For more options, visit https://groups.google.com/d/optout.

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

On Tuesday, September 16, 2014 6:04:11 PM UTC+8, Nabin Hait wrote:
Why you do not define pricing rule for discount instead of for price? That way you can show both price list rate and discount in the transactions.

On Sep 16, 2014, at 3:31 PM, Javier <bo...@gmail.com> wrote:

particular



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/266f8a33-9efe-43f3-aa28-a7b8e0496002%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Hello Javier,

You can enter total Discount Amount on all items in the sales transactions. Discount Amount field is visible below tax table. Discount Amount will be shown in the print format, above Net/Grand Total. Based on Discount Amount, your item prices and taxes will be back calculated, but what change won't reflect in the print format. Try suggested.

On Tue, Sep 16, 2014 at 4:11 PM, Javier <bo...@gmail.com> wrote:
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

On Tuesday, September 16, 2014 6:04:11 PM UTC+8, Nabin Hait wrote:
Why you do not define pricing rule for discount instead of for price? That way you can show both price list rate and discount in the transactions.

On Sep 16, 2014, at 3:31 PM, Javier <bo...@gmail.com> wrote:

particular



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/266f8a33-9efe-43f3-aa28-a7b8e0496002%40googlegroups.com.



For more options, visit https://groups.google.com/d/optout.




--
Thanks and Regards,
Umair Sayyed
www.erpnext.com

Mr. Umair Sayyed,

Currently we are applying the discount only for one item and the tax is also applicable for the one item.

Lets take a scenario, where item 1 is taxable and item 2 is not taxable service.

So, I will give discount in the Item 1 and item 2 is not discountable. So, In my sales order and sales invoice i woulod like to show the price list rate. So, Customer can see the discount we gave for that product.

Is it already available with erp.

awaiting your reply.