I have a BPM set up for SalesOrder.Update, and it goes through a few very simple steps:
Check to see if ttOrderRel.UDI_Number_c has a value of “Test” (using “Test” simply as a test until I figure this out)
Show a message with ttOrderHed.OrderNum
Basically, what is happening is that the Message pops up when a SO has UDI_Number_c set to a value of Test. The message has ttOrderHed.OrderNum imported via a Field Query and a Table Query, and each one is blank.
I am having the same issue. The problem seems to be trying to pull fields from tables other than the table that is triggering the BPM. I am trying to send an email that triggers based on when the OrderRel.NeedByDate changes. I want the email text to include the OrderHed.PONum and the OrderDtl.POLine. The BPM triggers correctly but the only info that populates is that new NeedByDate. I have tried several Methods. All trigger, all are missing the info. The email is useless without that PO and PO Line.
Did you know that SalesOrder.Update doesn’t alwasy fire for NEW OrderRel records? This is because the FIRST OrderRel record for each OrderDtl is added in the background… so it is difficult to capture the FIRST orderrel created. You will see the second and beyond if you manually create the new OrderRel.
maybe this is causing some confusion inside the BPM?