Solved

extend suppliers expiry date

  • 25 August 2022
  • 2 replies
  • 136 views

Userlevel 4
Badge +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

 

 

icon

Best answer by Kanishka Dilana 28 August 2022, 19:32

View original

2 replies

Userlevel 6
Badge +15

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,

 

Userlevel 4
Badge +8

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

Reply