Dear IFS Community,
I've made a migration job to Purchase Order Lines that automatically updates the status to "Confirmed" on PURCHASE_ORDER_LINE_PART when a new line is added or modified. This is working perfectly and the status is changed to Confirmed when I execute all lines or a single line.
However, I have encountered an issue when including columns from the PO header. These need to be maintained through the same migration job as well. Despite including them in the migration job, I am unable to automatically update the status on all lines after adding the header. The status can only be updated by executing each line individually. I would appreciate any guidance you could provide on resolving this issue.
Please refer to the attached images for a visual representation of my current setup.
Migration job without adding PO header (and works perfectly)
It’s possible to execute all in the migration job and the status is changed on all.
Migration job with PO header (only works on one line)
FETCHCONDITION:
PURCHASE_ORDER_LINE_PART.OBJKEY = PURCHASE_ORDER_LINE_PART_CFV.OBJKEY and PURCHASE_ORDER.ORDER_NO = PURCHASE_ORDER_LINE_PART.ORDER_NO
Let me know if anything need to be elaborated.
Br