I have created a pre-processing directive on PO.Update that includes an Update Table by Query component, but I can’t get the Update Table by Query to work. I have inserted a pop-up message that indicates that the conditions are being met, but the update is not happening.
(The PODtl criteria is POLine = 1)
It kicks out three pieces of data:
The mapping says to match the query results on PONum and Company and then to bind the POHeader.CommentText to OrderHead_OrderComment from the query:
When I make a change to the PO, Message 0 (positive) is displayed, but the PO Comments are not updated. I have verified that there are comments in the SO header.