Below you'll find the step to update lead time into Salesforce. While waiting an interface.

Who maintains data : Pricing Project Team.

The user that will update the data MUST have the Edit right on all records to be modified. 

For this objectets here are public group to have.


1/ Data coming from Supply chain


Jean Baptiste Cerceuil (from Novecare Supply chain) provide  a sheet that contains new lead time


Ex : LED Time Update - CLT SFDC as of 2023-03.xlsx - Google Sheets


Generate a GSheet based on the file provided



Exemple of data provided

PlantPlnt NameMaterialMaterial NameCLT in calendar days
02146068 Oldbury47861ALBRITECT CP 30 THPD 20KG91
02146068 Oldbury48150DURAPHOS OCTYL ACID PHOS:THLD:200KG:NP28

2/ Extract existing Shipping plant


Run that query in order to retreive Id and functional keys and copy the result to the Sheet


select id , Utility_Plant__r.Name ,Product__r.ProductCode,SLV48_Catalogue_Lead_Time__c from Manufacturing_Plant__c where RecordType.Name ='Shipping Plant'


3/ Functional Key & VLookup.

On the two data sheet add the functunal key : 

  • Sheet with new Lead Time :
    • Functional Key is : Plant & material
  • Sheet with exising record : 
    • Functional Key is : Plant & material

(warning) make sure that the plant format is on 4 figures. You can use the function "Format(A1,4)" to make sure all digit are in the key

On the Sheet with new Lead Time identify the related Manufacutring plant Id based on the Functionnal key.


4/ Update records.

Add an extra sheet that will contain only matching Manufacuring plant record.

in order to have : 

  • Manufacuring plant Id
  • New Lead time



Update SF Manufacuring plant with the above data (only Catalogue Lead Time)


  • No labels