List and Standard Price
When creating an opportunity and adding products to that opportunity in Salesforce it is my understanding that Sales Price and List Price should display different values; it currently does not. I need the List Price to display values from the “Standard Price Book” and the Sales Price to display the value from the price book selected for the opportunity (Either Standard Price Book or one of our Custom Price Book values.) Currently the List Price column is displaying an equal value to the sales price column, regardless of price book assignment within the opportunity. How can I configure the List Price column to always reference the value for the product in the Standard Price Book?
Think of the Standard price book your master price list, your base price which all other price books will be derived from. So let's say you have a standard price for the product "Milk" to be 3.50. When you create your different price books, Retail, Wholesale, or North America, EMEA, APAC you can now off set that price for these different price books. You can uplift a price for EMEA, $4.00 but lower the price for APAC, $2.50
The List price when you choose the EMEA price book will be $4.00. The sales price is what the Sales Rep really sold this product for, ie gave a discount, $3.75. The list price = $4.00, Sales price $3.75. Now if you don't allow your reps to change the sells price it's point less to display both.
To do what you want you may need to add a price to the product which is your 'standard price' then write a cross-object formula field to display that value on the opportunity product line.
Thanks for clarifying Pete!
I've got a follow up question:
To add a price to the product that's my 'standard price' wouldn't I need to know the API field name for the Standard field so that I could then write a cross-object formula?
I want to do something similar to Dieter's request:
In my Quote PDF, I want to display the *master* Standard Unit price and the customer's List Price, then calculate the discount so the customer can see on the Quote what their discount is.
For example, Customer A gets 10% off every item. I have a "Customer A Price Book" that lists all of my products at 10% off the standard price. I want his quote to show the standard price, the "Customer A Price Book" price, a calculation that shows the 10% difference, and the total line price.
I don't want to have the operator enter "10%" on every line item to achieve this.
I would suppose the solution would be to create a field in the "Customer A Price Book" for each product that equals the "Standard Price Book List Price". What is the API field name for that Standard Unit Price field?
Sales Price can then (if the permission is on in the users profile (Edit Opportunity Product Sales Price) be edited by the rep - this is one form of "discounting" you could say. The price could also be raised - point is.. the rep can control the sales price if the permission is on.
The DISCOUNT field allows for a % change to the entered sales price (either locked or editable..) ., and the math flows thru to TOTAL PRICE.
QUANTITY x SALES PRICE = SUBTOTAL + DISCOUNT = TOTAL PRICE