I am trying to update the Unit Cost for a product in Work Order Line Items from the Unit Cost in Opportunity Line Items (Products). I am relating them by the Product Code. I was hoping this would work on the Unit Cost field on the Work Order Line Item, but it doesn't:

If([OpportunityLineItem].ProductCode = Product_Code__c,[OpportunityLineItem].UnitPrice,"")

I even tried Workflow Field Updates and Process Builder with no success. I was wondering if anyone had a suggestion for me on how to do this. 
Thank you so much.

 

I am trying to update the Unit Cost for a product in Work Order Line Items from the Unit Cost in Opportunity Line Items (Products). I am relating them by the Product Code. I was hoping this would work on the Unit Cost field on the Work Order Line Item, but it doesn't:

If([OpportunityLineItem].ProductCode = Product_Code__c,[OpportunityLineItem].UnitPrice,"")

I even tried Workflow Field Updates and Process Builder with no success. I was wondering if anyone had a suggestion for me on how to do this. 
Thank you so much.

 

Is there any way to track the field history in Opportunity line item through a custom code? since there is no standard feature enabled for this object to track field history.

Thanks