S4PP price lists have effectivity dates (date from/date to)
I presume you are getting an ‘interval already exists or overlaps and existing interval’ error message?
So, you need to have two migration jobs.
- Close any Price Lists for any Supplier/partcode combinations you are about to update by setting the ‘To date’ to today -1
- Add the new Price list entries with a ‘From Date’ set to today
You can chain DataMig jobs together by calling the first from the 2nd using a CONNJOB parameter which allows for some degree of error checking before processing.
Hi @robert_g,
The CONNJOB isn’t an available rule for Excel Migration jobs.
This can be achieved by adding a row to the start of the Source Mapping which calls a custom function that performs the following steps:
- Check if date of new entry will overlap with existing entries.
- If overlap then call autonomous procedure to amend VALID_UNTIL date on existing entries.
- the DM job will then execute with no errors.
Cheers,
Pete