Skip to main content
Solved

extend suppliers expiry date

  • August 25, 2022
  • 2 replies
  • 186 views

Forum|alt.badge.img+8

Hi,

 

I have to extend the expiry date of around 500 suppliers, is there any way to extend it at once or do I need to do it one by one? 

 

Any idea? 

 

Thank you

 

 

Best answer by Kanishka Dilana

Hi @Hashmit,

If you have IFSAPP Access (Or Similar Privileges) to your system, you can try out IFS Data migration as follows,

  1. You need to have your Supplier data (SUPPLIER_ENT view) in a .CSV File,
  1.  Enter new expiry dates as appropriate and Save the file,

 

  1. Setup new Migration job to Insert or Update Data in SUPPLIER_ENT view,

 

  1. Start the Job. This will open up Execute job screen.
  2.  Load above Modified file,

 

  1. Start the Job from there,

 

  1. Now your Suppliers will have newly set Expiration Date,

 

2 replies

Kanishka Dilana
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Answer
  • August 28, 2022

Hi @Hashmit,

If you have IFSAPP Access (Or Similar Privileges) to your system, you can try out IFS Data migration as follows,

  1. You need to have your Supplier data (SUPPLIER_ENT view) in a .CSV File,
  1.  Enter new expiry dates as appropriate and Save the file,

 

  1. Setup new Migration job to Insert or Update Data in SUPPLIER_ENT view,

 

  1. Start the Job. This will open up Execute job screen.
  2.  Load above Modified file,

 

  1. Start the Job from there,

 

  1. Now your Suppliers will have newly set Expiration Date,

 


Forum|alt.badge.img+8
  • Author
  • Sidekick (Partner)
  • September 6, 2022

Hi thank you for your help, helped me a lot .