I’m confused by my results. All I’m trying to do is raise an exception when a user closes a shipment with more than one order. However, the “number of rows > 1” in my query in my condition is true even when I only have a single order on the shipment. Am I missing something in the query itself? My p…

Here’s the Query you need in your condition: [image] Table Relationship between 1 & 2 [image] Table Relationship between 2 & 3 [image] Table criteria for table 3 [image] That should find rows where SHipDtl’s have the same PackNum (same as the ShipHead), but different OrderNums

DataDirective - "If more than 1"

Epicor ERP 10

Aaron_Moreng (Aaron Moreng) November 7, 2019, 8:38pm 14

grumble grumble grumble be careful about joining tt tables in a BPM query

1 Like

Topic		Replies	Views
BPM best approach Epicor ERP 10 customization	6	1023	October 12, 2021
Shipping Notice Data Directive to send an email Epicor ERP 10	5	1466	June 19, 2017
Data directives and DMT Epicor ERP 10 dmt , data-directive	3	945	August 28, 2019
ShipTo information hard to get on Standard Data Directive on OrderHed Epicor ERP 10 bpm	13	549	January 11, 2023
Method Directive not honoring new value Epicor ERP 10 customization	4	594	September 10, 2019

DataDirective - "If more than 1"

Related Topics