I would like to create a BPM that looks at the part being entered on an order AND at the Ship-To State so that if the part is in a list AND the State is equal to ‘CA’, for example, a message is displayed.
I have been able to create a Method Directive on the SalesOrder.ChangePartNumMaster that displays a message if the part number being entered is equal to an expression (one part number).
I don’t see how to look at the header at the same time.
Any help is greatly appreciated.
Edit to add: How do I look at a list of parts on the BPM I have written? I can only see how to enter one part.
You might not have access to OrderHed from this BPM (Not totally sure) so you will have to query the database to see the value in the associated OrderHed record.
JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
A NORDSON COMPANY
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
I’m putting my list of Parts in the Table Criteria as you’ve shown. If I put them in with quotes around them, “0021” and “22015” for example, I always get the False informational message. If I don’t enter the quotes I’m getting an error when I try to save the Method Directive.
Server Side Exception
do a table query in your information message to see what rows are being returned. If you have it set to equals 1 like the picture, many times there is more than one row passing through. You might have to add criteria to look for the RowMod. It won’t show you the results of the query but you can see what’s in the TT tables and be able to see if your logic makes sense. Put one in the false, and the true message box you make after your criteria so you can see why it passed or failed.
