function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Salesforce GuySalesforce Guy 

Discounts at Line Item Product Level

There's a deficiency somewhere, either in the way SFDC handles Product Line Items or in my knowledge of the app.  I hope it's the latter.
 
Here's the problem.  We want the ability to apply percentage discounts for each Opportunity Product selected within an Opportunity and have the Total Price per line item reflect that discount, then autopopulate the Opportunity Amount field with the sum of the line items.
 
Currently, line item Total Price calculates only the Quantity x Sales Price (with no ability to modify the formula), so I can't include the discount.  I have created custom formula fields at the Opty Product level to provide our "true" price, including the discount, but our sales team will have to manually add, then enter, the sum in a custom "True Amount" field in the Opportunity.  In the meantime, the standard Amount field will continue to reflect an incorrect Amount (which means that I'll also have to reconfigure every report that we use for pipeline data to pull in the new "True Amount" totals (that'll be fun.)
 
Short of Apex or S-Control programming, does anyone know of a workaround?  I find it difficult to believe that SFDC hasn't had this issue crop up before now.
 
Any help appreciated!!!!  Thanks!
 
susiebsusieb
Did you ever get an help with this? I am encountering a similar sitation where I need to roll up a new total field on the line item to the opportunity level to a "discounted amount" total.
NoorNoor

I am surprised that no one is using the discount at the line item level in SFDC. Almost every industry has some sort of price discounts that is given at the line item.Therefore, I am assuming that SFDC must have some client who have implemented this.

If you find out please let me know, and I will do the same.

Hanif

NoorNoor

I guess no one wants to help because this customization must be highly in demand. I am surprised that SFDC doesn;t have any client who is using a Product Line Item discount.

If you find anything please let me know and I will do the same.

 

Thanks,

hanif