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

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

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

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

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