function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Serghei SleptovSerghei Sleptov 

Get UnitPrice of a Price Book Entry

Hello Community,

I have a trigger for a custom object . I need  to update a field of that custom object based on Product Entry UnitPrice.

Unfortunatelly, I can't find a way how to get a UnitPrice of a product of selected Price Book

Can anybody point me to a right derection?

here is my trigger:
 

trigger CPBXdeployment102 on Hosted_PBX_Deployment__c (before insert, before update) {

Set<Id> oppIds = new Set<Id>(); 

for(Hosted_PBX_Deployment__c newHPBX : Trigger.new)
{if(newHPBX.Opportunity__c !=null){oppIds.add(newHPBX.Opportunity__c);}}
List<Opportunity> hpbxOpportunity = [SELECT Id,OwnerId, Pricebook2Id FROM Opportunity WHERE id in :oppIds];

Map<Id, Opportunity>OppToHPBXMap = new Map<Id,Opportunity>();
for (Opportunity o :hpbxOpportunity) {OppToHPBXMap.put(o.Id,o);}




for(Hosted_PBX_Deployment__c newHPBX : Trigger.new){Opportunity OName = OppToHPBXMap.get(newHPBX.Opportunity__c); if(OName!=null){newHPBX.Opportunity_Name__c =  OName.Id;newHPBX.Opportunity_Owner__c =  OName.OwnerId;newHPBX.Price_Book__c = OName.Pricebook2Id;}}


}
Best Answer chosen by Serghei Sleptov
Waqar Hussain SFWaqar Hussain SF
try below code 
  
trigger CPBXdeployment102 on Hosted_PBX_Deployment__c(before insert, before update) {

    Set < Id > oppIds = new Set < Id > ();

    list < PricebookEntry > PBEs = [Select Id, Name, Pricebook2Id, Product2Id, UnitPrice from PricebookEntry];

    Map < Id, PricebookEntry > PBEMap = new Map < Id, PricebookEntry > ();
    for (PricebookEntry pb: PBEs) {
        PBEMap.put(pb.Pricebook2Id, pb);
    }

    for (Hosted_PBX_Deployment__c newHPBX: Trigger.new) {
        if (newHPBX.Opportunity__c != null) {
            oppIds.add(newHPBX.Opportunity__c);
        }
    }
    List < Opportunity > hpbxOpportunity = [SELECT Id, OwnerId, Pricebook2Id FROM Opportunity WHERE id in: oppIds];

    Map < Id, Opportunity > OppToHPBXMap = new Map < Id, Opportunity > ();
    for (Opportunity o: hpbxOpportunity) {
        OppToHPBXMap.put(o.Id, o);
    }




    for (Hosted_PBX_Deployment__c newHPBX: Trigger.new) {
        Opportunity OName = OppToHPBXMap.get(newHPBX.Opportunity__c);
        if (OName != null) {
            newHPBX.Opportunity_Name__c = OName.Id;
            newHPBX.Opportunity_Owner__c = OName.OwnerId;
            newHPBX.Price_Book__c = OName.Pricebook2Id;
	    PriceBookEntry PBE = PBEMap.get(OName.PriceBook2Id);
	    if(PBE != null){
	    	system.debug(PBE);
		system.debug(PBE.UnitPrice);
	    }
        }
    }


}

 

All Answers

Waqar Hussain SFWaqar Hussain SF
try below code 
  
trigger CPBXdeployment102 on Hosted_PBX_Deployment__c(before insert, before update) {

    Set < Id > oppIds = new Set < Id > ();

    list < PricebookEntry > PBEs = [Select Id, Name, Pricebook2Id, Product2Id, UnitPrice from PricebookEntry];

    Map < Id, PricebookEntry > PBEMap = new Map < Id, PricebookEntry > ();
    for (PricebookEntry pb: PBEs) {
        PBEMap.put(pb.Pricebook2Id, pb);
    }

    for (Hosted_PBX_Deployment__c newHPBX: Trigger.new) {
        if (newHPBX.Opportunity__c != null) {
            oppIds.add(newHPBX.Opportunity__c);
        }
    }
    List < Opportunity > hpbxOpportunity = [SELECT Id, OwnerId, Pricebook2Id FROM Opportunity WHERE id in: oppIds];

    Map < Id, Opportunity > OppToHPBXMap = new Map < Id, Opportunity > ();
    for (Opportunity o: hpbxOpportunity) {
        OppToHPBXMap.put(o.Id, o);
    }




    for (Hosted_PBX_Deployment__c newHPBX: Trigger.new) {
        Opportunity OName = OppToHPBXMap.get(newHPBX.Opportunity__c);
        if (OName != null) {
            newHPBX.Opportunity_Name__c = OName.Id;
            newHPBX.Opportunity_Owner__c = OName.OwnerId;
            newHPBX.Price_Book__c = OName.Pricebook2Id;
	    PriceBookEntry PBE = PBEMap.get(OName.PriceBook2Id);
	    if(PBE != null){
	    	system.debug(PBE);
		system.debug(PBE.UnitPrice);
	    }
        }
    }


}

 
This was selected as the best answer
Serghei SleptovSerghei Sleptov

Thanks much Waqar, that worked!