You need to sign in to do that
Don't have an account?
Product Discounts and Pricebook - Cannot lookup to pricebook so looking for suggestions
Currently I have built a process to give product discounts by quantity. Basically on the product object I have custom fields. FieldA would be for the 1st level qty discount, FieldB would be for the 2nd level, etc... Then the end user can type in all the prices for each level of discount (based on quantity). Then I have an Apex trigger than runs on the Opportunity Line item and reads the appropriate field to get the price. Works well.
But I have come up with an issue where we now want to give discounts per pricebook. But I cannot add custom fields to the pricebook and I cannot create a lookup to the pricebook. If I could do a lookup I could simply create another object with lookups to product and pricebook objects. And then have the trigger read the pricebook and get the appropriate discounts.
Anyone have any other thoughts on how to handle this?