method to prevent sending sales order acknowledgement for sales orders on credit hold?

I haven’t found a way to do a BPM like this with widgets only; when I have to take the temp table and use the info to look up entries in another table, I always do it with custom code.  Here’s an example of custom code for E10, that triggers on ttLaborDtl then uses the values and some other logic to look up entries in the related table JobOper, and under certain conditions throw an exception.  Throwing the exception both informs the user of the issue and prevents the transaction from completing in Epicor.

HTH

Monty.

// Force inspection for appropriate oprs

//

Erp.Tables.JobOper JobOper = null;

var ttLaborDtl_xRow = (from ttLaborDtl_Row in ttLaborDtl

    where ttLaborDtl_Row.RowMod == "A" || ttLaborDtl_Row.RowMod == "U"

    select ttLaborDtl_Row).FirstOrDefault();

    

if (ttLaborDtl_xRow != null)     // added or updated labor detail record exists?

{

   

    JobOper = (from JobOper_Row in Db.JobOper

        where JobOper_Row.Company == Session.CompanyID 

        && JobOper_Row.JobNum == ttLaborDtl_xRow.JobNum

        && JobOper_Row.OprSeq == ttLaborDtl_xRow.OprSeq

        && JobOper_Row.AssemblySeq == ttLaborDtl_xRow.AssemblySeq

        && JobOper_Row.SNRequiredOpr == true)



        select JobOper_Row).FirstOrDefault();

        

    if (JobOper != null)   // found matching job operation record?

    {

        throw new Ice.BLException(

            "Current (complete) qty must be zero for assemblies requiring inspection - use Non-Conform Qty instead"

            + Environment.NewLine + "(BPM exception: If Serial Force PDI");

    } // end if found job oper record

} // end if added or updated LaborDtl record exists