Hi All,

I have the following requirement. When cutom button is clicked on Opportunity detail page, i need to update the schedule date for all products associated with that opportunity to match Opportunity close date.

Below is my code, i'm getting Script error on button click, what am i missing?

Button Click Javascript:

{!REQUIRESCRIPT("/soap/ajax/29.0/connection.js")}
{!REQUIRESCRIPT("/soap/ajax/29.0/apex.js")}

// Call Apex Web service

var result = sforce.apex.execute(
"ProductScheduleDateUpdate", // class
"updateProductDate", // method
{iDate:"{!Opportunity.CloseDate}", // method arguments
iOppId:"{!Opportunity.Id}"});

}


Apex Class code

global class ProductScheduleDateUpdate
{

    WebService static String updateProductDate(Date iDate, String iOppId){
        List<OpportunityLineItem> oliList = [SELECT Id, OpportunityId FROM OpportunityLineItem
                                        WHERE OpportunityId= : iOppId];

        if(oliList.size() == 0){
            return 'No Opportunity Products to Update';
        }

        List<OpportunityLineItemSchedule> olisList = new List<OpportunityLineItemSchedule>();
        Map<Id, String> oppLineItemIdIdOppIdMap = new Map<Id, String>(); // it is for setting opportunity access level

       
        for(OpportunityLineItemSchedule olis : [SELECT Id, ScheduleDate, OpportunityLineItemId
                                                FROM OpportunityLineItemSchedule
                                                WHERE OpportunityLineItemId IN : oppLineItemIdIdOppIdMap.keySet()]) {
            olis.ScheduleDate = iDate;
            olisList.add(olis);
        }
       
        if(olisList.size() > 0){
            update olisList;
        }
   
        return 'All Product Schedule Date updated to match Opportunity Close Date';
    }
}