Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
KNKKNK 

Help needed on Trigger

Hi Team,

 

I am using below trigger to update price filed from Product Shipper to DsP Product. It is working fine for new records but if change the price in product shipper then the value is updating but total amount is not getting exactly. this price field is using in workflow to calcuate the total amount.

 

trigger UpdatePrice on DSP_Product__c (before insert, before update) {
        
        set<String> years = new set<String>();
        set<Id> accounts = new set<Id>();
        map<String, Id> prevYearKeyDspMap = new map<String, Id>();
for(DSP_Product__c dspr : trigger.new){
            accounts.add(dspr.Account__c);
            years.add(dspr.Name);
                    }

Map<ID, Product_Shipper__c> psMap =
        new Map<ID, Product_Shipper__c>(
            [SELECT Price__c, Pack_Size__c
            FROM Product_Shipper__c
            WHERE Active__c = true]);
for ( DSP_Product__c dspp : trigger.new ) {
        if (prevYearKeyDspMap.size()>0){
            Product_Shipper__c ps = psMap.get(dspp.Product_Shipper__c);
            if ( ps != null ) {
                dspp.Product_Price__c = ps.Price__c;
                dspp.Product_Size__c = ps.Pack_Size__c;
            }
        }
    }
}

SLockardSLockard

Your "if (prevYearKeyDspMap.size()>0)" will never be true because you never put anything in that map, so I'd figure out what you want to do with that first.
KNKKNK

Hi,

 

Thank you, I Have done it by using work flow thanks