LC Follow Up Sheet | How To Make LC Follow Up Sheet

LC Follow Up Sheet | How To Make LC Follow Up Sheet

LC Follow UP Sheet:


LC Follow Up Sheet | How To Make LC Follow Up Sheet
LC Followup Sheet

Make Table In Excel File and Maintain Properly:



 Item Name 
 Name of the Vendor
 Previous Purchase Price (USD) 
 New Offered Price (USD)
 Dyes
 Huntsman
 $ 12
 $ 13
 Chemicals
 Huntsman
 $ 10
 $ 10

↓

 Price Reduction/Increase     
 Requirment of October 2018 (KG)           
 Amount (USD) 
 PI Collaction         
 + $1
 1000 kg
 13000
 Done
 0
 500 kg
 5000
 Done
↓↓↓↓↓↓↓↓↓↓ excel file to create all steps in one Row..and update information. then you open this file show all update in one file.
→→→→→→→→→→→→→→→

You Maintain This steps properly you get best result and you easily track to where is your goods .
  • Item Name        
  • Name of the Vendor     
  • Previous Purchase Price (USD)  
  • New Offered Price (USD)            
  • Price Reduction/Increase            
  • Requirment of October 2018 (KG)           
  • Amount (USD) 
  • PI Collction         
  • PI Collction Date              
  • PI Number         
  • PI Submit to Audit          
  • PI Submit to Audit Date
  • Draft LC Date    
  • Transmit Date   
  • LC Number        
  • ETD       
  • ETA       
  • Copy Documents Receiving Date             
  • Inhouse status
  • Remarks