BPM condition only working on first save

Epicor ERP 10
6

the problem as previously stated is that there are TWO rows returned when you modify something vs only ONE row when it is being added. You only want the row with RowMod <> “” (the A or U valued row).
BUT
there is another problem with your BPM. You did a query that links the TT row with a real database row, and that can be bad and very inefficient (taking lots of time). It would be better to:

  1. create a variable for Order Number
  2. Populate the Order number from the TT row with a setter widget
  3. THEN in your condition, instead of connecting the tt row to the Order Header row, you simply filter the order header row by the order number. This will return the value much faster.
    There are multiple discussions on this forum about this. example: E10 BPM Slow due to Join?
1 Like