Salesforce Field Integrity Exception on TotalPrice and UnitPrice

642 views Jul 26, 2023

Exception: FIELD_INTEGRITY_EXCEPTION, field integrity exception: TotalPrice (total price must be specified): [TotalPrice] Exception: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, field integrity exception: UnitPrice (only one of unit price or total price may be specified): [UnitPrice] To avoid this issue, kindly make sure the below for OpportunityLineItem(Opportunity Product) records: 1. We cannot set both TotalPrice and UnitPrice to null in the same Insert, update and Upsert call. 2. UnitPrice field or TotalPrice is required. You cannot specify both. 3. If you specify Discount and Quantity, UnitPrice field or TotalPrice is required. 4. TotalPrice field cannot be null if UnitPrice field is null. Blog Post: https://www.infallibletechie.com/2014/10/fieldintegrityexception-field-integrity.html

#Internet Software