You need to sign in to do that
Don't have an account?
Carolina Santamaría
How can I use the field "standard price" in a pricebookentry for a formula field in the same object?
Hi,
I need to be able to update several price lists just by changing one price for a list of products. For example, I have a list for payments with credit card and I want to calculate the credit card price by adding a percentage to the standard price.
I tried creating a formula field in "PriceBookEntry" that would look like this:
Credit_Card _price = (CC_percentage + 1)*StandardPrice
But I could not find the standardprice field available in the edit formula page.
Is there another way of achieving this?
Thank you,
Carolina
I need to be able to update several price lists just by changing one price for a list of products. For example, I have a list for payments with credit card and I want to calculate the credit card price by adding a percentage to the standard price.
I tried creating a formula field in "PriceBookEntry" that would look like this:
Credit_Card _price = (CC_percentage + 1)*StandardPrice
But I could not find the standardprice field available in the edit formula page.
Is there another way of achieving this?
Thank you,
Carolina
Use field "List Price" (API Name: UnitPrice).
So Your formula will be:
Credit_Card _price = (CC_percentage + 1)*UnitPrice
Thanks,
Pratik
P.S. If this answers you question, please mark it as "Best Answer" so it will help other community members too.