[SalesForce] REQUIRED_FIELD_MISSING & FIELD_INTEGRITY_EXCEPTION on PricebookEntry Insert

I want to use standard price for the Pricebook entry.

  PricebookEntry pbe = new PricebookEntry(Pricebook2Id='01sN00000002OTsIAM',
        IsActive=true, 
        Product2Id='01tN0000004JGeuIAG', 
        UseStandardPrice=true
        );
    insert pbe;

I get this error.

REQUIRED_FIELD_MISSING, Required fields are missing: [UnitPrice]:
[UnitPrice]

So, I changed to mention the List Price (which is the unitPrice). I still get the error!

PricebookEntry pbe = new PricebookEntry(
    Pricebook2Id='01sN00000002OTsIAM',
    IsActive=true, 
    Product2Id='01tN0000004JGeuIAG', 
    UseStandardPrice=true,
    UnitPrice = 0.70
    );

insert pbe;

I get the following error

Insert failed. First exception on row 0; first error:
FIELD_INTEGRITY_EXCEPTION, field integrity exception

UPDATE

I read that UseStandardPrice==true cannot be set. It has to be false. help.salesforce.com/articleView?id=000193277&type=1

Setting it to False actually inserts the record. But I want it to be set to true.

Best Answer

I have figured out that we cannot set UseStandardPrice=true on insert. On insert it has to be set to False first, along with mentioning UnitPrice. Then later do an additional update to set the UseStandardPrice=true.

PricebookEntry pbe = new PricebookEntry(
    Pricebook2Id='01sN00000002OTsIAM',
    IsActive=true, 
    Product2Id='01tN0000004JGeuIAG', 
    UseStandardPrice=false,
    UnitPrice = 0.70
    );

insert pbe;

pbe.UseStandardPrice = true;
update pbe;

Related Solutions

[SalesForce] Error in Test Class as :FIELD_INTEGRITY_EXCEPTION

Try the Below code to create OpportunityLineItem and everything related to it in Test class.

Product2 prod = new Product2(Name = 'Laptop X200', Family = 'Hardware');
insert prod;

Id pricebookId = Test.getStandardPricebookId();

PricebookEntry standardPrice = new PricebookEntry(Pricebook2Id = pricebookId, Product2Id = prod.Id, UnitPrice = 10000, IsActive = true);
insert standardPrice;

Pricebook2 customPB = new Pricebook2(Name='Custom Pricebook', isActive=true);
insert customPB;

PricebookEntry customPrice = new PricebookEntry(Pricebook2Id = customPB.Id, Product2Id = prod.Id, UnitPrice = 12000, IsActive = true);
insert customPrice;

Account acc = new Account(Name='TestAccount');
insert acc;

Opportunity opp = new Opportunity(Name='TestOpportunity', AccountId=acc.Id, CloseDate=Date.Today(), StageName='Suspect', Pricebook2Id=customPB.Id);
insert opp;

OpportunityLineItem oli = new OpportunityLineItem(OpportunityId = opp.Id, Quantity = 5, PricebookEntryId = customPrice.Id, TotalPrice = 500);
insert oli;

Hope this will solve the Issue as this is the Best way to create a OpportunityLineItem.

[SalesForce] Error:-PricebookEntryId (pricebook entry is in a different pricebook than the one assigned to the opportunity): [PricebookEntryId]

Like I said in comment your Opportunity.Pricebook2Id should be equal to your OLI.pricebookEntry.Pricebook2Id

So for solution what you can do..

Query only those PricebookEntry where pricebookEntry.Pricebook2Id = Opportunity.Pricebook2Id

change your query in constructor and search method..

Note: Please be insure your opportunity pricebook2Id not null

public with sharing class pageclass {

public GEN_ProductSelectionController(){

    wrapProductList = new List<wrapProduct>();
    Id objPricebook2Id = [SELECT Pricebook2Id FROM Opportunity 
                           WHERE Id =: objCurrentOppId]; 
    for(PricebookEntry a: [select Id, Name,ProductCode,UnitPrice,product2.Type__c 
                            from PricebookEntry WHERE PriceBook2Id =: objPricebook2Id]) {
      wrapProductList.add(new wrapProduct(a));
    }
    System.debug('Default product list :' +wrapProductList);
}

Also in your search method change PricebookEntry query and add filter PriceBook2Id =: objPricebook2Id

Best Answer

Related Solutions

[SalesForce] Error in Test Class as :FIELD_INTEGRITY_EXCEPTION

[SalesForce] Error:-PricebookEntryId (pricebook entry is in a different pricebook than the one assigned to the opportunity): [PricebookEntryId]

Related Topic