UD column Summary of lines into Header

Kinetic ERP
,
1

Hi,

I have a Custom form where the summary of line records is updated in Header.
I am updating UD109.Number02 from UD109A.Number02 whenever new line is added in child table, my BPM code is as follows.

var ttUD109ARow  = (from g in ds.UD109A where g.Company == Session.CompanyID && g.ShortChar10 == "Approved"  select g ).FirstOrDefault();
  if (ttUD109ARow != null)
  {
    var UD109Row  = (from i in Db.UD109 where i.Company == Session.CompanyID &&  i.Key1 == ttUD109ARow.Key1   select i ).FirstOrDefault();
    if (UD109Row != null)
    {
    var TotalWrk = (from t in Db.UD109A  where t.Company == Session.CompanyID && t.Key1 == ttUD109ARow.Key1 && t.ShortChar10 == "Approved" select t.Number02).Sum();
    //this.PublishInfoMessage(TotalWrk.ToString() , Ice.Common.BusinessObjectMessageType.Information, Ice.Bpm.InfoMessageDisplayMode.Individual, "","");
    
    UD109Row.Number02 = Convert.ToDecimal(TotalWrk);
  
    }
}

Is there a method to accomplish this in Kinetic? I attempted to search the page for examples but was unable to locate any.

Thanks,
Arun

2

Your BPM will run as normal in Kinetic why need to change it? Do you have classic screen customisatons that need uplifting?

3

It is working fine, I am excited to know if there is a way to achieve this through kinetic customization, since there is a Calculation Event available and many more options as well.