Event Trigger FieldUpdate: Copy Invoice Note to Sales Orders

Hi @mrthanhkhoi 

You can try copying the note when you save the invoice:

// Extension of SOInvoiceEntry
// Example copying Description

protected void _(Events.RowPersisting<ARInvoice> e)
{
   var query = new SelectFrom<SOOrder>
      InnerJoin<SOInvoice>.On<SOInvoice.sOorderType.IsEqual<SOOrder.oderType>.
      And<SOInvoice.sOOrderNbr.IsEqual<SOOrder.orderNbr>>>
      Where<Use<SOInvoice.refNbr>.AsString.IsEqual<@P.AsString>>.
      View(Base);

   SOOrder so = query.Select(e.Row.RefNbr).TopFirst;

   so.OrderDesc = e.Row.DocDesc;

   Base.Caches[typeof(SOOrder)].Update(so);
   if(Base.Caches[typeof(SOOrder)].Updated.Cast<SOOrder>().Count() > 0)
   {
      Base.Caches[typeof(SOOrder)].Persist(PXDBOperation.Update);                    
   }   
}