Skip to main content
Solved

extend suppliers expiry date


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,

 

View original

Kanishka Dilana
Superhero (Employee)
Forum|alt.badge.img+16

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
  • Sidekick (Partner)
  • September 6, 2022

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings