Skip to main content
Question

Excel Migration Job - Modification Issue


Forum|alt.badge.img+12

I’ve created an Excel migration job to modify values on a Sales Price List, but it seems that each time that I execute the job, a new record is created instead of updating the record that already exists. 

For this particular migration job, there will never be a requirement to insert new values, only update existing.  

 

Any ideas what I am doing incorrectly?

 

Environment: 23R1 SU 1

 

Source Mapping:

Method List Attributes:

 

2 replies

Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 119 replies
  • July 13, 2023

Hi @astfarazt 

 

Probably it has something to do with the field MIN_DURATION which should have the value -1

 

Please have a look into another community post where a similar issue occured:

https://community.ifs.com/data-migration-333/sales-price-list-part-data-migration-error-30819

 

/Jens


Forum|alt.badge.img+12
  • Author
  • Hero (Partner)
  • 173 replies
  • July 14, 2023

Thanks for the feedback, @Jens.

I tried that method, but, unfortunately, it was the same issue.  

I scrapped trying the Excel Migration and just used a standard Insert or Update via a File and that resolved the issue.  

In general, I noticed some strange behavior with the Excel Add In.  


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