Update field in another company using BPM

[ckrusen (Calvin Krusen)]

Here’s a post showing how to directly update a UD field in a DB. You’d want to tweak it so that the Company being referenced is the target company, and not the ClientContext.CurrentCompany

POHeader - Save UD Field When PO Approved

The following code in a BPM’s Exec Custom Code widget will work. Db.POHeader.Where( r =>r.Company == callContextClient.CurrentCompany && r.PONum == 48919).FirstOrDefault().PurchasedFor_c="BPM Update"; Db.Validate(); Just put your variable in for the PO Num and change the name of the UD field. CAUTION!! This writes directly to the DB bypassing any BO logic. It’s practically like using SQL to modify the DB. A misconfigured expression might cause multiple records to update. You should only d…

Yours would be something like:

Int32 oNum = Convert.ToInt32(ttOrderHedRow.PONum.Remove (ttOrderHedRow.PONum .Length -4,4));
// probably want to check that oNum has a non-zero value before doing the following

Db.OrderHed.Where( r =>r.Company == 'GNC' && r.OrderNum==oNum).FirstOrDefault().Checkbox01=1; // maybe "= true;"
Db.Validate();