Custom code bpm

[zachg (Zach Griffeth)]

Kyle,

You can easily have a condition variable check your released bit and executing custom code on the true condition.

Custom BPM to add QuoteHed_UD field to Sales Order on Opp to Sales Order processing

You might want to add a few additonal lines of code: a line for the Transaction Scope add a “lockHint.UpdLock” for record locking DB.Validate txScop.Complete I also moved the read for the order down into the inside of the scop as well as inside the checking for the null quote. No need to read the order if you are not going to modify it. var quoteNum = Db.OrderDtl.Where(o => o.Company == Session.CompanyID && o.OrderNum == orderNum).Select(x => x.QuoteNum).FirstOrDefault(); if (quoteNum != nu…

Tim has posted before on how to properly update another table, using a new transaction scope and proper LockHints.

using(var txScope = IceContext.CreateDefaultTransactionScope()) {
        var order = Db.OrderHed.With(LockHint.UpdLock).Where(o => o.Company == Session.CompanyID && o.OrderNum == orderNum).FirstOrDefault();
        order.DecorType_c = quote.DecorType_c;
        order.BldgType_c = quote.BldgType_c;
        Db.Validate();
        txScope.Complete();
    }

Of course, this just needs a few changes like the table and which fields you need to update.