In case anyone is still interested in this topic: Total Price does not appear to be a field that can be inserted into formulas, but you can create a Custom Field within the Quote Line Items object that calculates Total Price as follows: ((Quantity * PricebookEntry.UnitPrice * (1 – Discount))
Table of Contents
How do I insert the totalprice for a quote line item?
To insert the TotalPrice for a quote line item via the API (given only a unit price and the quantity), calculate this field as the unit price multiplied by the quantity. This field is read-only if the quote line item has a revenue schedule.
Why is the quote line item read-only?
This field is read-only if the quote line item has a revenue schedule. If it doesn’t have a revenue schedule or only has a quantity schedule, this field can be updated. You need to sign in to do that. Need an account?
How do you calculate total price in Excel?
The Total Price of each line item (Product) is calculated as follows (UnitPrice * Quantity)* Discount. Then, the un-rounded Total Price is then summed. Because the un-rounded number is summed, there may be a potential discrepancy when comparing the value to a manually calculated result.
Can I set totalprice and unitprice to null in an update?
If you don’t specify a UnitPrice, this field is required. This field is nillable, but you can’t set both TotalPrice and UnitPrice to null in the same update. To insert the TotalPrice for a quote line item via the API (given only a unit price and the quantity), calculate this field as the unit price multiplied by the quantity.