Question

IFS 8 - Migration Updating/ Modify IDENTITY_INVOICE_INFO

  • 14 May 2021
  • 2 replies
  • 275 views

Userlevel 1
Badge +2
  • Do Gooder (Customer)
  • 1 reply

Hi together, 

I’ve tried to update the  IDENTITY_INVOICE_INFO in the column AUTOMATIC_PAY_AUTH_FLAG_DB with ‘1’. But it seems that IFS only can only make new entries with a migration.

Same Problem in the IDENTITY_PAY_INFO in the column PAYMENT_ADVICE_DB (Update to ‘2’).

If I have in the Method List the checkbox active on New and Modify, then IFS only wants to create new lines, If I only activate the checkbox on modify, the IFS won’t update anything.

 

Is there a solution?


This topic has been closed for comments

2 replies

Userlevel 2
Badge +2

Hi @Weiss ,

 

IFS Data Migration tool has the support to update data in a data source through the migration job. Can you attach more details of how you have configured the Migration Job? Some screen shots of the migration Job would be good. For updating records, we can use the procedure name “INSERT_OR_UPDATE” in the Migration Job header. Then you need to setup the file mapping and run the job.

 

Best Regards,

Safras

Userlevel 1
Badge +2

I wanna update every row, which has not automatic_pay_auth_flag_db = '1' .

So I create following migration:

 

When I run the migration in this form, I get an error, because the line already exists. When I uncheck the New in the Method List, the lines will not update: