epicor version 9.05.701
i’m writing a bpm so when a new vendor is created an error occurs if the GL controls are left blank.
The tables in question are Vendor and EntityGLC
The joins are vendor.company=entityglc.company AND vendor.vendornum = entityglc.key1
I am using the condition “the number of rows in the template query is not less than 1”
Could anybody help me with the syntax?
This isn’t doing the trick:
for each Vendor no-lock , each EntityGLC no-lock outer-join where (String(Vendor.VendorNum) = EntityGLC.Key1 and EntityGLC.GLControlCode = “” )