BPM To Restrict OrderRel fields based on OrderHed field

I was asked to write a BPM that said If Orderhed.Checkbox15 = True, then do not allow OrderRel.Custom1, OrderRel.Custom2, OrderRel.Custom3 be changed. Throw an error message and terminate and don’t save to the table. Here is what I did:

Data Directive on OrderRel,In-Trans:

Then in the below setup, I used the email to tell me if it was going through. Everything works until the Condition. Once I used the Condition 1 (highlighted), it no longer works. Also, I notice that it still writes to the Table even when I set it to terminate after the Trans to Standard.

Assuming the RV1 is what you used for GetByID there - there is no updated RV1 row after GetByID. Try using the ‘unchanged row’ instead of ‘updated row’.

1 Like

My boss changed the field to everything on OrderHed, so this was easy to do in the BPM itself under the Pre-Processing. Works perfectly!

2 Likes