+ Start a Discussion
syricsyric 

Apex Trigger - Trouble with saving an updated list

Hello, I am new to apex.  I'm trying to make a trigger that updates the unit price on an opportunity's products marked with a specific discount when it is set to a certain stage.  For testing purposes I have made a trigger that tries to update the marked prices anytime the opportunity is updated. 

 

The problem I am running into is that I can't get the updated prices to save.  I put debug statements in so I could see what was happening and everything looks ok to me.  I have posted my trigger code and the debug log results below.  Any help would be appreciated.

 

CODE:

 

trigger DEVProrateTrigger on Opportunity (before insert, before update) {

//GET TODAYS DATE AND SUBTRACT IT FROM 30 TO GET THE INTEGER TO DIVIDE THE PRICE BY, "PRICEDIV"
Date now = date.today();
integer day = now.day();
integer month = 30;
integer pricediv = month - day;

//GET A LIST OF THE PRODUCTS FOR THE OPPORTUNITY BEING UPDATED "PRODLIST"
List<OpportunityLineItem> prodList = [select ID, OpportunityId, Price_Adjustment_Reason_Code__c, UnitPrice from OpportunityLineItem where OpportunityId in: Trigger.new];

//DEBUG STATMENT #1 TO SHOW ME THE PULLED LIST OF PRODUCTS, "PRODLIST"
System.Debug(prodList);

//LOOP THROUGH PULLED "PRODLIST" TO FIND ANY WITH A PRICE ADJUSTMENT OF PRORATE AND DIVDE THEIR UNIT PRICE BY THE INTEGER "PRICEDEV"
for(OpportunityLineItem a : prodList){
    if(a.Price_Adjustment_Reason_Code__c == 'PI = Prorated Item'){
        a.UnitPrice = (a.UnitPrice / pricediv);
    }
}

//DEBUG STATEMENT #2 TO SHOW ME "PRODLIST" WITH THE UPDATED VALUES
System.Debug(prodList);

//UPDATE/SAVE THE UPDATED "PRODLIST" TO THE DATABASE
Database.Saveresult[] results =Database.update(prodList);

//DEBUG STATEMENT #3 TO SHOW ME THAT "PRODLIST" WAS UPDATED/SAVED CORRECTLY
System.Debug(results);
}

 

 

DEBUG LOG STATEMENTS

 

#1 - 13:45:16.176 (176394000)|USER_DEBUG|[10]|DEBUG|(OpportunityLineItem:{Price_Adjustment_Reason_Code__c=PI = Prorated Item, OpportunityId=006W0000002VguoIAC, Id=00kW0000002zs2iIAA, UnitPrice=50.00})  -This statement shows the correct data was pulled.

 

#2 - 13:45:16.177 (177312000)|USER_DEBUG|[17]|DEBUG|(OpportunityLineItem:{Price_Adjustment_Reason_Code__c=PI = Prorated Item, OpportunityId=006W0000002VguoIAC, Id=00kW0000002zs2iIAA, UnitPrice=2.38095238095238095238095238095238})  -This statement shows that the unitprice in the list was updated from the loop.

 

#3 - 13:45:16.347 (347895000)|USER_DEBUG|[20]|DEBUG|(Database.SaveResult[getErrors=();getId=00kW0000002zs2iIAA;isSuccess=true;]) -This shows that the updated list with the updated price was saved to the database correctly.

Best Answer chosen by Admin (Salesforce Developers) 
syricsyric

I found out what the problem was.  It looks like when you have schedules turned on for products it overides or does not allow you edit the unitprice field.  I am sure this is noted somewhere, but I had no idea.  Thanks for the help.

All Answers

AmitSahuAmitSahu

Have you checked any workflow firing just after this execution?

syricsyric

Thanks for the suggestion.  I have checked and disabled all workflow rules to see if one them was the culprit.  The issue still remains.

 

I had the idea to try to update the field "UnitPrice" on the opportunitylineitem object via dataloader.  It lets me update it and shows that it was successful via the success log, yet like the my apex trigger the update is not saved and the original value remains.

 

I have no idea what could be preventing it from being updated or how to find it.

AmitSahuAmitSahu

Do you have the raw log for this entire operation ?

syricsyric

Sure. Thanks.

23.0 APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO
11:00:45.201 (201529000)|EXECUTION_STARTED
11:00:45.201 (201571000)|CODE_UNIT_STARTED|[EXTERNAL]|TRIGGERS
11:00:45.201 (201596000)|CODE_UNIT_STARTED|[EXTERNAL]|01qW000000003n6|DEVProrateTrigger on Opportunity trigger event BeforeUpdate for [006W0000002PGVa]
11:00:45.203 (203092000)|SYSTEM_METHOD_ENTRY|[4]|Date.today()
11:00:45.203 (203153000)|SYSTEM_METHOD_EXIT|[4]|Date.today()
11:00:45.203 (203202000)|SYSTEM_METHOD_ENTRY|[5]|Date.day()
11:00:45.203 (203245000)|SYSTEM_METHOD_EXIT|[5]|Date.day()
11:00:45.210 (210023000)|SOQL_EXECUTE_BEGIN|[10]|Aggregations:0|select ID, OpportunityId, Price_Adjustment_Reason_Code__c, UnitPrice from OpportunityLineItem where OpportunityId IN :tmpVar1
11:00:45.218 (218450000)|SOQL_EXECUTE_END|[10]|Rows:1
11:00:45.218 (218580000)|SYSTEM_METHOD_ENTRY|[13]|System.debug(ANY)
11:00:45.218 (218697000)|USER_DEBUG|[13]|DEBUG|(OpportunityLineItem:{Price_Adjustment_Reason_Code__c=PI = Prorated Item, OpportunityId=006W0000002PGVaIAO, Id=00kW0000002fLDNIA2, UnitPrice=50.00})
11:00:45.218 (218712000)|SYSTEM_METHOD_EXIT|[13]|System.debug(ANY)
11:00:45.218 (218802000)|SYSTEM_METHOD_ENTRY|[16]|LIST<OpportunityLineItem>.iterator()
11:00:45.219 (219212000)|SYSTEM_METHOD_EXIT|[16]|LIST<OpportunityLineItem>.iterator()
11:00:45.219 (219250000)|SYSTEM_METHOD_ENTRY|[16]|system.ListIterator.hasNext()
11:00:45.219 (219288000)|SYSTEM_METHOD_EXIT|[16]|system.ListIterator.hasNext()
11:00:45.219 (219638000)|SYSTEM_METHOD_ENTRY|[16]|system.ListIterator.hasNext()
11:00:45.219 (219656000)|SYSTEM_METHOD_EXIT|[16]|system.ListIterator.hasNext()
11:00:45.219 (219688000)|SYSTEM_METHOD_ENTRY|[23]|System.debug(ANY)
11:00:45.219 (219781000)|USER_DEBUG|[23]|DEBUG|(OpportunityLineItem:{Price_Adjustment_Reason_Code__c=PI = Prorated Item, OpportunityId=006W0000002PGVaIAO, Id=00kW0000002fLDNIA2, UnitPrice=3.125})
11:00:45.219 (219795000)|SYSTEM_METHOD_EXIT|[23]|System.debug(ANY)
11:00:45.219 (219827000)|SYSTEM_METHOD_ENTRY|[26]|Database.update(LIST<SObject>)
11:00:45.219 (219876000)|DML_BEGIN|[26]|Op:Update|Type:OpportunityLineItem|Rows:1
11:00:45.309 (309256000)|CODE_UNIT_STARTED|[EXTERNAL]|Validation:OpportunityLineItem:00kW0000002fLDN
11:00:45.309 (309283000)|VALIDATION_RULE|03d600000008gLt|AAD_Sales_Cut_off_Validation
11:00:45.318 (318483000)|VALIDATION_FORMULA|OR(
AND (LEFT (Product2.ProductCode, 3) = "AAD", TODAY()>DATE(2011, 11, 22),  Issue_Number__c ="1201",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (LEFT (Product2.ProductCode, 3) = "AAD", TODAY()>DATE(2012, 01, 23),  Issue_Number__c ="1203", $User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"),
AND (LEFT (Product2.ProductCode, 3) = "AAD", TODAY()>DATE(2012, 03, 26),  Issue_Number__c ="1205", $User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"),
AND (LEFT (Product2.ProductCode, 3) = "AAD", TODAY()>DATE(2012, 05, 29),  Issue_Number__c ="1207", $User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"),
AND (LEFT (Product2.ProductCode, 3) = "AAD", TODAY()>DATE(2012, 07, 23),  Issue_Number__c ="1209", $User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"),
AND (LEFT (Product2.ProductCode, 3) = "AAD", TODAY()>DATE(2012, 09, 24),  Issue_Number__c ="1211", $User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"),
AND (LEFT (Product2.ProductCode, 3) = "AAD", TODAY()>DATE(2012, 11, 26),  Issue_Number__c ="1301", $User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK")
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.318 (318512000)|VALIDATION_PASS
11:00:45.318 (318517000)|VALIDATION_RULE|03d600000008gLu|CAD_Sales_Cut_off_Validation
11:00:45.319 (319562000)|VALIDATION_FORMULA|OR(
AND(
LEFT( Product2.ProductCode, 3) = "CAD", TODAY()>DATE(2011, 11, 15),  Issue_Number__c ="1201",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "CAD", TODAY()>DATE(2012, 01, 19),  Issue_Number__c ="1203",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "CAD", TODAY()>DATE(2012, 03, 23),  Issue_Number__c ="1205",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "CAD", TODAY()>DATE(2012, 05, 25),  Issue_Number__c ="1207",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "CAD", TODAY()>DATE(2012, 07, 20),  Issue_Number__c ="1209",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "CAD", TODAY()>DATE(2012, 09, 21),  Issue_Number__c ="1211",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "CAD", TODAY()>DATE(2012, 11, 20),  Issue_Number__c ="1301"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.319 (319583000)|VALIDATION_PASS
11:00:45.319 (319588000)|VALIDATION_RULE|03d600000008gLv|FCS_Sales_Cut_off_Validation
11:00:45.320 (320371000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "FCS", TODAY()>DATE(2012, 01, 17),  Issue_Number__c ="1203",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "FCS", TODAY()>DATE(2012, 03, 21),  Issue_Number__c ="1205",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "FCS", TODAY()>DATE(2012, 05, 22),  Issue_Number__c ="1207"), AND(
LEFT ( Product2.ProductCode, 3) = "FCS", TODAY()>DATE(2012, 07, 18),  Issue_Number__c ="1209",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "FCS", TODAY()>DATE(2012, 09, 19),  Issue_Number__c ="1211",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "FCS", TODAY()>DATE(2012, 11, 19),  Issue_Number__c ="1301",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.320 (320391000)|VALIDATION_PASS
11:00:45.320 (320395000)|VALIDATION_RULE|03d600000008gLw|FLB_Sales_Cut_off_Validation
11:00:45.321 (321166000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "FLB", TODAY()>DATE(2012, 01, 23),  Issue_Number__c ="1203",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "FLB", TODAY()>DATE(2012, 03, 26),  Issue_Number__c ="1205",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "FLB", TODAY()>DATE(2012, 05, 29),  Issue_Number__c ="1207",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "FLB", TODAY()>DATE(2012, 07, 23),  Issue_Number__c ="1209",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "FLB", TODAY()>DATE(2012, 09, 24),  Issue_Number__c ="1211",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "FLB", TODAY()>DATE(2012, 11, 26),  Issue_Number__c ="1301"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.321 (321187000)|VALIDATION_PASS
11:00:45.321 (321191000)|VALIDATION_RULE|03d600000008gLx|GAR_Sales_Cut_off_Validation
11:00:45.322 (322077000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "GAR", TODAY()>DATE(2011, 12, 16),  Issue_Number__c ="1202",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "GAR", TODAY()>DATE(2012, 02, 17),  Issue_Number__c ="1204",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "GAR", TODAY()>DATE(2012, 04, 20),  Issue_Number__c ="1206",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "GAR", TODAY()>DATE(2012, 06, 15),  Issue_Number__c ="1208",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "GAR", TODAY()>DATE(2012, 08, 16),  Issue_Number__c ="1210",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "GAR", TODAY()>DATE(2012, 10, 19),  Issue_Number__c ="1212",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "GAR", TODAY()>DATE(2012, 12, 18),  Issue_Number__c ="1302"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.322 (322099000)|VALIDATION_PASS
11:00:45.322 (322103000)|VALIDATION_RULE|03d600000008gLy|Internet_Sales_Cut_off_Validation
11:00:45.324 (324416000)|VALIDATION_FORMULA|OR(
AND (TODAY()>DATE(2011, 12, 28), Issue_Number__c ="1201", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"),  
AND (TODAY()>DATE(2012, 01, 27), Issue_Number__c ="1202", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 02, 27), Issue_Number__c ="1203", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 03, 27), Issue_Number__c ="1204", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 05, 15), Issue_Number__c ="1205", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 06, 15), Issue_Number__c ="1206", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 07, 15), Issue_Number__c ="1207", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 08, 15), Issue_Number__c ="1208", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 09, 15), Issue_Number__c ="1209", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 10, 15), Issue_Number__c ="1210", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 11, 15), Issue_Number__c ="1211", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2012, 12, 15), Issue_Number__c ="1212", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2013, 01, 15), Issue_Number__c ="1301", (Product_Type_1__c)="Internet",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), 
AND (TODAY()>DATE(2013, 02, 15), Issue_Number__c ="1302"
)
)|$User.ProfileId=00e600000013aVv , Product_Type_1__c=Internet , Issue_Number__c=1206
11:00:45.324 (324447000)|VALIDATION_PASS
11:00:45.324 (324452000)|VALIDATION_RULE|03d600000008g94|Invalid_Issue_Number
11:00:45.324 (324659000)|VALIDATION_FORMULA|Issue_Number_Value__c < 1204|Issue_Number_Value__c=1206
11:00:45.324 (324668000)|VALIDATION_PASS
11:00:45.324 (324672000)|VALIDATION_RULE|03d600000008gM1|MAM_Sales_Cut_off_Validation
11:00:45.325 (325574000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "MAM", TODAY()>DATE(2011, 12, 05),  Issue_Number__c ="1202",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "MAM", TODAY()>DATE(2012, 02, 21),  Issue_Number__c ="1204",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "MAM", TODAY()>DATE(2012, 04, 26),  Issue_Number__c ="1206",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "MAM", TODAY()>DATE(2012, 06, 19),  Issue_Number__c ="1208",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "MAM", TODAY()>DATE(2012, 08, 20),  Issue_Number__c ="1210",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "MAM", TODAY()>DATE(2012, 10, 23),  Issue_Number__c ="1212",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "MAM", TODAY()>DATE(2012, 12, 20),  Issue_Number__c ="1302"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.325 (325596000)|VALIDATION_PASS
11:00:45.325 (325600000)|VALIDATION_RULE|03d600000008gM2|NCC_Sales_Cut_off_Validation
11:00:45.326 (326480000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "NCC", TODAY()>DATE(2011, 12, 22),  Issue_Number__c ="1202",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NCC", TODAY()>DATE(2012, 01, 20),  Issue_Number__c ="1203",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NCC", TODAY()>DATE(2012, 03, 28),  Issue_Number__c ="1205",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NCC", TODAY()>DATE(2012, 05, 30),  Issue_Number__c ="1207",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NCC", TODAY()>DATE(2012, 07, 24),  Issue_Number__c ="1209",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NCC", TODAY()>DATE(2012, 09, 25),  Issue_Number__c ="1211",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NCC", TODAY()>DATE(2012, 11, 28),  Issue_Number__c ="1301"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.326 (326502000)|VALIDATION_PASS
11:00:45.326 (326506000)|VALIDATION_RULE|03d600000008gM3|NWB_Sales_Cut_off_Validation
11:00:45.327 (327506000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "NWB", TODAY()>DATE(2011, 12, 02),  Issue_Number__c ="1201",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NWB", TODAY()>DATE(2011, 12, 23),  Issue_Number__c ="1202",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NWB", TODAY()>DATE(2012, 02, 29),  Issue_Number__c ="1204",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NWB", TODAY()>DATE(2012, 05, 02),  Issue_Number__c ="1206",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NWB", TODAY()>DATE(2012, 06, 27),  Issue_Number__c ="1208",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NWB", TODAY()>DATE(2012, 08, 27),  Issue_Number__c ="1210",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NWB", TODAY()>DATE(2012, 10, 31),  Issue_Number__c ="1212",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "NWB", TODAY()>DATE(2013, 1, 02),  Issue_Number__c ="1302"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT

 

syricsyric
11:00:45.327 (327529000)|VALIDATION_PASS
11:00:45.327 (327533000)|VALIDATION_RULE|03d600000008gM4|PNB_Sales_Cut_off_Validation
11:00:45.328 (328527000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "PNB", TODAY()>DATE(2011, 11, 23),  Issue_Number__c ="1201",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "PNB", TODAY()>DATE(2011, 12, 27),  Issue_Number__c ="1202",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "PNB", TODAY()>DATE(2012, 02, 27),  Issue_Number__c ="1204",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "PNB", TODAY()>DATE(2012, 04, 30),  Issue_Number__c ="1206",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "PNB", TODAY()>DATE(2012, 06, 25),  Issue_Number__c ="1208",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "PNB", TODAY()>DATE(2012, 08, 24),  Issue_Number__c ="1210",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "PNB", TODAY()>DATE(2012, 10, 29),  Issue_Number__c ="1212",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "PNB", TODAY()>DATE(2012, 12, 28),  Issue_Number__c ="1302"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.328 (328556000)|VALIDATION_PASS
11:00:45.328 (328560000)|VALIDATION_RULE|03d600000008gM5|TEN_Sales_Cut_off_Validation
11:00:45.329 (329556000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "TEN", TODAY()>DATE(2011, 12, 02),  Issue_Number__c ="1201",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TEN", TODAY()>DATE(2011, 12, 20),  Issue_Number__c ="1202",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TEN", TODAY()>DATE(2012, 02, 22),  Issue_Number__c ="1204",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TEN", TODAY()>DATE(2012, 04, 24),  Issue_Number__c ="1206",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TEN", TODAY()>DATE(2012, 06, 20),  Issue_Number__c ="1208",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TEN", TODAY()>DATE(2012, 08, 21),  Issue_Number__c ="1210",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TEN", TODAY()>DATE(2012, 10, 24),  Issue_Number__c ="1212",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TEN", TODAY()>DATE(2012, 12, 21),  Issue_Number__c ="1302"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.329 (329578000)|VALIDATION_PASS
11:00:45.329 (329582000)|VALIDATION_RULE|03d600000008gM6|TGG_Sales_Cut_off_Validation
11:00:45.330 (330570000)|VALIDATION_FORMULA|OR(
AND(
LEFT( Product2.ProductCode, 3) = "TGG", TODAY()>DATE(2011, 11, 18),  Issue_Number__c ="1201",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGG", TODAY()>DATE(2011, 12, 19),  Issue_Number__c ="1202",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGG", TODAY()>DATE(2012, 02, 20),  Issue_Number__c ="1204",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGG", TODAY()>DATE(2012, 04, 23),  Issue_Number__c ="1206",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGG", TODAY()>DATE(2012, 06, 18),  Issue_Number__c ="1208",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGG", TODAY()>DATE(2012, 08, 17),  Issue_Number__c ="1210",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGG", TODAY()>DATE(2012, 10, 22),  Issue_Number__c ="1212",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGG", TODAY()>DATE(2012, 12, 19),  Issue_Number__c ="1302"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.330 (330592000)|VALIDATION_PASS
11:00:45.330 (330596000)|VALIDATION_RULE|03d600000008gM7|TGS_Sales_Cut_off_Validation
11:00:45.331 (331482000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "TGS", TODAY()>DATE(2011, 11, 22),  Issue_Number__c ="1201",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGS", TODAY()>DATE(2012, 01, 19),  Issue_Number__c ="1203",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGS", TODAY()>DATE(2012, 03, 23),  Issue_Number__c ="1205",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGS", TODAY()>DATE(2012, 05, 25),  Issue_Number__c ="1207",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGS", TODAY()>DATE(2012, 07, 20),  Issue_Number__c ="1209",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGS", TODAY()>DATE(2012, 09, 21),  Issue_Number__c ="1211",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TGS", TODAY()>DATE(2012, 11, 20),  Issue_Number__c ="1301"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.331 (331504000)|VALIDATION_PASS
11:00:45.331 (331508000)|VALIDATION_RULE|03d600000008gM8|TXB_Sales_Cut_off_Validation
11:00:45.332 (332495000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "TXB", TODAY()>DATE(2011, 12, 02),  Issue_Number__c ="1201",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TXB", TODAY()>DATE(2011, 12, 19),  Issue_Number__c ="1202",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TXB", TODAY()>DATE(2012, 02, 20),  Issue_Number__c ="1204",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TXB", TODAY()>DATE(2012, 04, 23),  Issue_Number__c ="1206",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TXB", TODAY()>DATE(2012, 06, 18),  Issue_Number__c ="1208",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TXB", TODAY()>DATE(2012, 08, 17),  Issue_Number__c ="1210",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TXB", TODAY()>DATE(2012, 10, 22),  Issue_Number__c ="1212",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "TXB", TODAY()>DATE(2012, 12, 19),  Issue_Number__c ="1302"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.332 (332517000)|VALIDATION_PASS
11:00:45.332 (332522000)|VALIDATION_RULE|03d600000008gM9|VAC_Sales_Cut_off_Validation
11:00:45.333 (333406000)|VALIDATION_FORMULA|OR(
AND(
LEFT ( Product2.ProductCode, 3) = "VAC", TODAY()>DATE(2011, 12, 01),  Issue_Number__c ="1201",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "VAC", TODAY()>DATE(2012, 01, 18),  Issue_Number__c ="1203",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "VAC", TODAY()>DATE(2012, 03, 21),  Issue_Number__c ="1205",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "VAC", TODAY()>DATE(2012, 05, 22),  Issue_Number__c ="1207",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "VAC", TODAY()>DATE(2012, 07, 18),  Issue_Number__c ="1209",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "VAC", TODAY()>DATE(2012, 09, 20),  Issue_Number__c ="1211",$User.ProfileId <> "00e600000013aVv", $User.ProfileId <> "00e60000000oeEK"), AND(
LEFT ( Product2.ProductCode, 3) = "VAC", TODAY()>DATE(2012, 11, 19),  Issue_Number__c ="1301"
)
)|$User.ProfileId=00e600000013aVv , Issue_Number__c=1206 , Product2.ProductCode=HTCIT
11:00:45.333 (333427000)|VALIDATION_PASS
11:00:45.333 (333434000)|CODE_UNIT_FINISHED|Validation:OpportunityLineItem:00kW0000002fLDN
11:00:45.383 (383021000)|DML_END|[26]
11:00:45.383 (383135000)|SYSTEM_METHOD_EXIT|[26]|Database.update(LIST<SObject>)
11:00:45.383 (383181000)|SYSTEM_METHOD_ENTRY|[29]|System.debug(ANY)
11:00:45.383 (383244000)|USER_DEBUG|[29]|DEBUG|(Database.SaveResult[getErrors=();getId=00kW0000002fLDNIA2;isSuccess=true;])
11:00:45.383 (383255000)|SYSTEM_METHOD_EXIT|[29]|System.debug(ANY)
11:00:45.774 (383278000)|CUMULATIVE_LIMIT_USAGE
11:00:45.774|LIMIT_USAGE_FOR_NS|(default)|
  Number of SOQL queries: 1 out of 100
  Number of query rows: 1 out of 50000
  Number of SOSL queries: 0 out of 20
  Number of DML statements: 1 out of 150
  Number of DML rows: 1 out of 10000
  Number of script statements: 10 out of 200000
  Maximum heap size: 0 out of 6000000
  Number of callouts: 0 out of 10
  Number of Email Invocations: 0 out of 10
  Number of fields describes: 0 out of 100
  Number of record type describes: 0 out of 100
  Number of child relationships describes: 0 out of 100
  Number of picklist describes: 0 out of 100
  Number of future calls: 0 out of 10

11:00:45.774|CUMULATIVE_LIMIT_USAGE_END

11:00:45.383 (383328000)|CODE_UNIT_FINISHED|DEVProrateTrigger on Opportunity trigger event BeforeUpdate for [006W0000002PGVa]
11:00:45.405 (405244000)|CODE_UNIT_STARTED|[EXTERNAL]|Validation:Opportunity:006W0000002PGVa
11:00:45.405 (405271000)|VALIDATION_RULE|03d600000008hRE|Disable_Stage_Change_When_Closed_Won
11:00:45.484 (484969000)|VALIDATION_FORMULA|AND (
 ISPICKVAL( Signature_Status__c, "Signed"),
 OR (ISPICKVAL( StageName, "Signed and Submitted for Approval"), ISPICKVAL( StageName, "Negotiation/Review"), ISPICKVAL( StageName, "Price Quote/Proposal"), ISPICKVAL( StageName, "Presentation"), ISPICKVAL( StageName, "Discovery/Needs Analysis"), ISPICKVAL( StageName, "Prospecting/Qualification")),
OR(
  $Profile.Id <>"00e60000000og7p"),  $Profile.Id <> "00e600000013aVv")|StageName=Negotiation/Review , Signature_Status__c=Ready , $Profile.Id=00e600000013aVv
11:00:45.484 (484994000)|VALIDATION_PASS
11:00:45.484 (484999000)|VALIDATION_RULE|03d600000008g7w|Invalid_Close_Date
11:00:45.485 (485431000)|VALIDATION_FORMULA|AND (CloseDate < TODAY (),  $User.ProfileId <> "00e60000000og7p", $User.ProfileId <> "00e60000000oeEK", $User.ProfileId <> "00e600000013aVv")|$User.ProfileId=00e600000013aVv , CloseDate=2012-06-30 00:00:00
11:00:45.485 (485442000)|VALIDATION_PASS
11:00:45.485 (485446000)|VALIDATION_RULE|03d600000008fs8|Property_Interstate_Exit_Validation
11:00:45.485 (485657000)|VALIDATION_FORMULA|Account.Interstate__c = NULL && Account.Exit__c = NULL|Account.Exit__c=5 , Account.Interstate__c=I35
11:00:45.485 (485667000)|VALIDATION_PASS
11:00:45.485 (485670000)|VALIDATION_RULE|03d600000008fpd|Property_Number_Validation
11:00:45.485 (485884000)|VALIDATION_FORMULA|Account.Property_Number_Reference__c = NULL|Account.Property_Number_Reference__c=1234567
11:00:45.485 (485893000)|VALIDATION_PASS
11:00:45.485 (485899000)|CODE_UNIT_FINISHED|Validation:Opportunity:006W0000002PGVa
11:00:45.573 (573893000)|ENTERING_MANAGED_PKG|ePrize_Zemzu
11:00:45.677 (677771000)|SOQL_EXECUTE_BEGIN|[195]|Aggregations:1|SELECT Id, ChatterGroupId__c, ContestName__c, Goal__c, StartDate__c, EndDate__c, RankingStyle__c, ContactPerson__c, ContactPerson__r.Email, ContactPerson__r.FirstName, ContactPerson__r.LastName, SiteURL__c, Teams__c, NotifyOnLaunchChatter__c, LeaderboardUpdatesChatter__c, NotifyOnEndChatter__c, NotifyOnLaunchChatterMessage2__c, LeaderboardUpdatesChatterMessage2__c, NotifyOnEndChatterMessage2__c, NotifyOnLaunch__c, LeaderboardUpdates__c, NotifyOnEnd__c, NotifyOnLaunchMessage__c, LeaderboardUpdatesMessage__c, NotifyOnEndMessage__c, LeaderboardUpdatesFrequency__c, LeaderboardUpdatesDay__c, NotifyOnLaunchTo__c, LeaderboardUpdatesTo__c, NotifyOnEndTo__c, IWStatus__c, EarningEntriesChatter__c, EarningEntriesChatterTo__c, Status__c, WinningPrizes__c, WinningPrizesMessage__c, LeaderboardRankBy__c, WinningPrizesChatter__c, WinningPrizesChatterTo__c,  (select Id, Admin__r.firstname, Admin__r.lastname, Admin__r.email, Admin__r.Id from ContestAdmins__r where Admin__r.IsActive = true)  FROM Contest__c WHERE EndDate__c >= :now AND StartDate__c <= :now
11:00:45.688 (688284000)|SOQL_EXECUTE_END|[195]|Rows:0
11:00:45.692 (692593000)|SOQL_EXECUTE_BEGIN|[254]|Aggregations:0|select Id, Contest__r.Id, User__r.firstname, User__r.lastname, User__r.email, User__r.Id, ePrize_Zemzu__Goal__c from ContestUser__c 
11:00:45.695 (695592000)|SOQL_EXECUTE_END|[254]|Rows:0
11:00:45.700 (700413000)|SOQL_EXECUTE_BEGIN|[51]|Aggregations:0|select ePrize_Zemzu__OpportunityFilter__c, ePrize_Zemzu__Product__c from OpportunityFilterProduct__c where OpportunityFilter__c IN :tmpVar1
11:00:45.702 (702430000)|SOQL_EXECUTE_END|[51]|Rows:0
11:00:45.703 (703297000)|SOQL_EXECUTE_BEGIN|[63]|Aggregations:0|select PricebookEntryId, OpportunityId from OpportunityLineItem where OpportunityId IN :tmpVar1
11:00:45.706 (706567000)|SOQL_EXECUTE_END|[63]|Rows:1
11:00:45.707 (707822000)|SOQL_EXECUTE_BEGIN|[72]|Aggregations:0|select p.UseStandardPrice, p.UnitPrice, p.SystemModstamp, p.ProductCode, p.Product2Id, p.Pricebook2Id, p.Name, p.LastModifiedDate, p.LastModifiedById, p.IsDeleted, p.IsActive, p.Id, p.CreatedDate, p.CreatedById from PricebookEntry p where p.Id IN :tmpVar1
11:00:45.713 (713364000)|SOQL_EXECUTE_END|[72]|Rows:1
11:00:45.823 (823074000)|SOQL_EXECUTE_BEGIN|[122]|Aggregations:0|select AAA_Accepted__c, AC04__c, AC05__c, AN__c, AccountNumber, Address_Number__c, Airport_Nearby__c, Amusement_Park_Nearby__c, AnnualRevenue, BillingCity, BillingCountry, BillingPostalCode, BillingState, BillingStreet, Business_Center__c, Business_Unit_1__c, Business_Unit__c, City_Category_Code__c, Continental_Breakfast__c, Converted_Lead_Source__c, Copied_Lead_Source_from_Contact__c, CreatedDate, Credit_Message__c, Current_Amount__c, Description, Directions__c, District_Category_Code__c, District_Name__c, Dry_Cleaning_Laundry__c, ETP__c, Email_Ad_Copy__c, Email__c, Exit__c, Fax, Fax_Ad_Copy__c, Featured_Amenity_10__c, Featured_Amenity_11__c, Featured_Amenity_12__c, Featured_Amenity_13__c, Featured_Amenity_14__c, Featured_Amenity_15__c, Featured_Amenity_16__c, Featured_Amenity_1__c, Featured_Amenity_2__c, Featured_Amenity_3__c, Featured_Amenity_4__c, Featured_Amenity_5__c, Featured_Amenity_6__c, Featured_Amenity_7__c, Featured_Amenity_8__c, Featured_Amenity_9__c, Fitness_Room__c, Free_Local_Calls__c, Free_Newspaper__c, Going_Green__c, Golf_Nearby__c, Group_Category_Code__c, Handicap_Accessible__c, Hotel_Brand__c, IDLN__c, Id, In_Room_Coffee__c, In_Room_Hair_Dryer__c, In_Room_Iron__c, In_Room_Microwave__c, In_Room_Refrigerator__c, Industry, Internet_High_Speed__c, Internet_Wireless__c, Interstate__c, IsDeleted, Jigsaw, JigsawCompanyId, Kids_Stay_Free__c, Large_Vehicle_Parking_Welcome__c, LastActivityDate, LastModifiedDate, Latitude__c, Longitude__c, Name, Non_Smoking__c, NumberOfEmployees, Number_of_Rooms__c, Numeric_Status__c, Open_Amount__c, Owner_Name__c, Ownership, Parent__c, Payment_Terms__c, Pets_Welcome__c, Phone, Phone_ID__c, Physical_Address_State__c, Physical_Address_Zip_Code__c, Physical_Address__c, Physical_City_Address__c, Physical_Street_Address_1__c, Physical_Street_Address_2__c, Premium_Channels__c, Property_Number_Reference__c, RCK7__c, Rating, Region_Category_Code__c, Restaurants_Nearby__c, ShippingCity, ShippingCountry, ShippingPostalCode, ShippingState, ShippingStreet, Shopping_Nearby__c, Sic, Site, Status__c, Swimming_Pool__c, SystemModstamp, TickerSymbol, Type, Valet_Parking__c, Water_View__c, Web_ID__c, Website, X120__c, X1_30_days__c, X31_60_days__c, X45_Days_Past_Due__c, X61_90_days__c, X91_120_days__c, jde_error__c, jde_error_description__c from Account where Id in :accountIds
11:00:45.907 (907878000)|SOQL_EXECUTE_END|[122]|Rows:1
11:00:45.910 (910116000)|SOQL_EXECUTE_BEGIN|[79]|Aggregations:0|select Id, MasterLabel, SortOrder, IsWon, IsClosed from OpportunityStage order by SortOrder limit 10000
11:00:45.912 (912231000)|SOQL_EXECUTE_END|[79]|Rows:15
11:00:45.919 (919846000)|SOQL_EXECUTE_BEGIN|[147]|Aggregations:0|select ePrize_Zemzu__Opportunity__c, ePrize_Zemzu__Contest__c, ePrize_Zemzu__PipelineBehavior__c, ePrize_Zemzu__Contest__r.ePrize_Zemzu__StartDate__c, ePrize_Zemzu__Contest__r.ePrize_Zemzu__EndDate__c, ePrize_Zemzu__Modified__c from Action__c 
11:00:45.930 (930487000)|SOQL_EXECUTE_END|[147]|Rows:0
11:00:45.933 (933506000)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:Opportunity
11:00:45.934 (934781000)|CODE_UNIT_FINISHED|Workflow:Opportunity
11:00:46.039 (1039315000)|CODE_UNIT_FINISHED|TRIGGERS
11:00:46.039 (1039343000)|EXECUTION_FINISHED

 

syricsyric

I found out what the problem was.  It looks like when you have schedules turned on for products it overides or does not allow you edit the unitprice field.  I am sure this is noted somewhere, but I had no idea.  Thanks for the help.

This was selected as the best answer