BPM Query When MiscCode = FRTS Not Getting Triggered

Kinetic ERP
1

Once an order has been invoiced, we want to prevent folks from changing the shipping misc header charge.

I created a BPM query with a condition that MiscCode = “FRTS”, but it’s not triggering when I make a change to that row in an order. Using ‘FRTS’ gets a compile error on saving the BPM. I tried removing the InvcHead table from the BPM Query to help narrow down the condition to MiscCode=FRTS rows only, but still not getting triggered.

image

I put the OHOrderHed.MiscCode field in the pop-up warning, but it’s not getting returned (guessing that’s my issue). But that field is in the trace dataset…

image
image864×397 23.2 KB

The rows are visible in my test BAQ (same results testing using either OHOrderMsc or OrderMsc).

image

image
image726×405 19.6 KB

Not quite sure how to keep moving forward now…

2

Did you try FRTS with no quotes?

3

That also gives a compilation error.
image

4

Anyone have ideas why the Pre-BPM condition isn’t finding the FRTS misc header charge line? I’m not sure what else to try, considering that field is in the trace.