[SalesForce] Error: Entity is not api accessible at line 1 column 1

trigger Stage on Opportunity (After insert, After update) {

    for (opportunity opp : trigger.new) {
        if (opp.StageName = 'Closed won') {
            for ( product pro: trigger.new) {
                pro.Available_for_lease__c = FALSE;
            }


        }
    }


}

I'm new to apex and i need to update the value of a checkbox in the object "room" if the stage is set to closed won which is in the opportunity object.

Best Answer

You are trying to access the Product object which isn't available - Product2 is the type you need.

There is a problem with trying to access the Product(2) items by using the trigger.new collection - it will be a collection of Opportunities not Products...

Related Solutions

[SalesForce] Exeception on After Insert, Record is read only

The record is locked because you are catching the record after the insert DML statement has happened. So if you'd like to modify this record (or records), you will need to query anew, modify, then execute another DML statement.

Here is an example of how you could modify your trigger to work:

trigger SetProductCategory on OpportunityLineItem (after insert) {

    List<OpportunityLineItem> olis = [SELECT Id, PricebookEntry.Product2.Product_Category_new__c FROM OpportunityLineItem WHERE Id IN: Trigger.newMap.keySet()];

    for (OpportunityLineItem opplineitem: olis){
        opplineitem.Product_Category__c= opplineitem.PricebookEntry.Product2.Product_Category_new__c;
    }

    update olis;

}

And of course, since it's a trigger, we want to be sure to work in batches -- that's why I'm updating a list of olis rather than an individual opp line item.

[SalesForce] Deduct Qty On Hand from Product Object when an Opportunity is Closed Won

I don't think it's wise to rely on the state of a field prior to the start of a transaction as an accurate count. Instead, you should just use a trigger on Opportunity and an aggregate query on the OpportunityLineItem object, which looks up to both Product2 and Opp.

First collect all of your Product2 Ids from the trigger set:

Set<id> productIdsToQuery = new Set<id>();
List<OpportunityLineItem> lineItems = [SELECT Product2Id FROM OpportunityLineItem WHERE OpportunityId IN : Trigger.New];
for (OpportunityLineItem oli : lineItems) {
    productIdsToQuery.add(oli.Product2Id);
}

Next, do an aggregate query on the Closed Won opps related to that Product:

List<Account>AggregateResult[] groupedResults = [SELECT SUM(Quantity) totalQuantity, Product2Id FROM OpportunityLineItem WHERE Product2Id IN :productIdsToQuery AND StageName = 'Closed Won' GROUP BY Product2Id];

List<Product2> productsToUpdate = new List<Product2>();    

for (AggregateResult ar : groupedResults)  {
    Product2 updatedProduct = new Product2(
        id = ar.get('Product2Id');
        QuantityConsumed__c = ar.get('totalQuantity');
    );
    productsToUpdate.add(updatedProduct);       
}

update productsToUpdate;

EDIT: You edited your post in the middle of my answer to change what Quantity On Hand means. You need a field for how many you have and then how many have been used (the calculation I listed) and a formula to do the subtraction for 'On Hand'

Best Answer

Related Solutions

[SalesForce] Exeception on After Insert, Record is read only

[SalesForce] Deduct Qty On Hand from Product Object when an Opportunity is Closed Won

Related Topic