+7Hi all,
I have an excel migration for Supplier for Purchase Part. This allows price lists to be created by users and inserted to the price list tab. However, if a price list is active - this prevents the tool from working. Is there a way to close an active price list automatically before the new price list is inserted?
Best answer by pwlm
Hi
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:
Cheers,
Pete
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.
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.
+11Hi
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:
Cheers,
Pete
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
