Epicor Function - Saving to a UD table in Code

Kinetic ERP
1

So I found that I can call a function in Kinetic from another function in the same library. Nice. I recall being told that Kinetic would not allow this.

Even better when creating the code that calls the function it gives you a line skeleton with blank spaces where the parameters are and you can preview what the parameters are in the nav bar to the left. So far so good.

I made a logging function to go along with my dashboard to write scanner logs to a UD table. I have this working in classic so I attribute this to my lack of knowledge on tablesets. Now the parameters are good, I have them going back to a form and can see them on screen. I am not getting errors. It is not giving exception messages. Its either failing silently or for some unknown reason it is not calling it. So I am missing something.

using (var context = Ice.Services.ContextFactory.CreateContext<ErpContext>())
{




 
  using (var svc = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UD10SvcContract>(context)) 
  { 
      
     
     Ice.Tablesets.UD10Tableset tblUD10 = new Ice.Tablesets.UD10Tableset();
     
    svc.GetaNewUD10(ref tblUD10);  // Doesnt seem to make a difference if I comment this out 

    // DataRow ud10Row = tblUD10.UD10.Rows[0];  this is an instant error from the customization that does the same thing

    Ice.IceRow ud10Row = tblUD10.UD10.NewRow();
    
  
     string jobNum = this.JobNum;
     string empNum = "";
     try 
     {
        empNum = this.EmpNum.ToString();
     }
     catch {}
  
    ud10Row["Key1"] = "GTValidation";
    ud10Row["Key2"] = this.GTIN;
    ud10Row["Key3"] = DateTime.Now;
    ud10Row["Key4"] = empNum;
    ud10Row["Key5"] = this.LotNum;
    
    ud10Row["ShortChar01"]= this.GTINIdentifier;
    ud10Row["ShortChar02"]= this.GTIN;
    ud10Row["ShortChar03"]= this.DateIdentifier;
    ud10Row["ShortChar04"] = this.Date;
  
    try
    {
      DateTime dt = DateTime.Parse(this.PackagingDate);
     // DateTime dt = (DateTime)this.PackagingDate;
      ud10Row["Date01"] = dt;
    }
    catch {}
  
      ud10Row["ShortChar05"] = this.LotIdentifier;
      ud10Row["ShortChar06"] = this.LotNum; 
      ud10Row["ShortChar07"] = this.CaseIdentifier;
  
      try
      {
        ud10Row["Number01"] = this.UnitsPerCase;
      }    
      catch {}
      
      ud10Row["ShortChar08"] = jobNum;
      ud10Row["ShortChar09"] = empNum;
      ud10Row["ShortChar10"] = this.FoodDate;
  
      ud10Row["ShortChar11"] = this.SuccessOrFail;
      ud10Row["Character01"] = this.Message;
      ud10Row["ShortChar12"] = this.type; // shpType.EnabledCaption;
      ud10Row["ShortChar13"] = this.PartNum;
      ud10Row["Character02"] = this.PartDesc;
  
       string userID = callContextClient.CurrentUserId;
     ud10Row["ShortChar14"] = userID;
  
     svc.Update(ref tblUD10);
      
  }

 
}
2

You’re not setting the “Company” field in that code. So if you’re not getting any errors it is probably creating the records with Company ID blank, and therefore when you’re trying to retrieve them you’re not finding them.

I would write a BAQ or do a query to check.

2 Likes
3

This should return a dataset with one record with the defaults set, but you then create a new row (that doesn’t get any defaults - hence the blank company) and update that row:

Ice.IceRow ud10Row = tblUD10.UD10.NewRow();

I don’t think that’s necessary with the GetANewRow:

<UD10DataSet xmlns="http://www.epicor.com/Ice/300/BO/UD10/UD10">
  <UD10>
    <Company>EPIC03</Company>
    <Key1 />
    <Key2 />
    <Key3 />
    <Key4 />
    <Key5 />
    <Character01 />
    <Character02 />
    <Character03 />
    <Character04 />
    <Character05 />
    <Character06 />
    <Character07 />
    <Character08 />
    <Character09 />
    <Character10 />
    <Number01>0</Number01>
    <Number02>0</Number02>
    <Number03>0</Number03>
    <Number04>0</Number04>
    <Number05>0</Number05>
    <Number06>0</Number06>
    <Number07>0</Number07>
    <Number08>0</Number08>
    <Number09>0</Number09>
    <Number10>0</Number10>
    <Number11>0</Number11>
    <Number12>0</Number12>
    <Number13>0</Number13>
    <Number14>0</Number14>
    <Number15>0</Number15>
    <Number16>0</Number16>
    <Number17>0</Number17>
    <Number18>0</Number18>
    <Number19>0</Number19>
    <Number20>0</Number20>
    <CheckBox01>false</CheckBox01>
    <CheckBox02>false</CheckBox02>
    <CheckBox03>false</CheckBox03>
    <CheckBox04>false</CheckBox04>
    <CheckBox05>false</CheckBox05>
    <CheckBox06>false</CheckBox06>
    <CheckBox07>false</CheckBox07>
    <CheckBox08>false</CheckBox08>
    <CheckBox09>false</CheckBox09>
    <CheckBox10>false</CheckBox10>
    <CheckBox11>false</CheckBox11>
    <CheckBox12>false</CheckBox12>
    <CheckBox13>false</CheckBox13>
    <CheckBox14>false</CheckBox14>
    <CheckBox15>false</CheckBox15>
    <CheckBox16>false</CheckBox16>
    <CheckBox17>false</CheckBox17>
    <CheckBox18>false</CheckBox18>
    <CheckBox19>false</CheckBox19>
    <CheckBox20>false</CheckBox20>
    <ShortChar01 />
    <ShortChar02 />
    <ShortChar03 />
    <ShortChar04 />
    <ShortChar05 />
    <ShortChar06 />
    <ShortChar07 />
    <ShortChar08 />
    <ShortChar09 />
    <ShortChar10 />
    <ShortChar11 />
    <ShortChar12 />
    <ShortChar13 />
    <ShortChar14 />
    <ShortChar15 />
    <ShortChar16 />
    <ShortChar17 />
    <ShortChar18 />
    <ShortChar19 />
    <ShortChar20 />
    <GlobalUD10>false</GlobalUD10>
    <GlobalLock>false</GlobalLock>
    <SysRevID>0</SysRevID>
    <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
    <BitFlag>0</BitFlag>
    <RowMod>A</RowMod>
  </UD10>
</UD10DataSet>

Try changing this from:

Ice.IceRow ud10Row = tblUD10.UD10.NewRow();

to

var ud10Row = tblUD10.UD10.First();
5 Likes
4

Solved. This was 90% of it

THANK YOU! That moved it forward - considerably.

After that I got a message that said Key3 was null.

I changed one line and voila it works

ud10Row[“Key3”] = DateTime.Now; // This did not work (works in customization)*

ud10Row[“Key3”] = DateTime.Now.ToString(“yyyy-MM-dd hh:mm:ss”); // This works

Not sure why it was not failing before. It just wasn’t writing anything.

I confirmed that GetANewUD10 fills in the company

3 Likes
5

If I remember correctly, on the UD Tables all the keys are of DataType String. In your first example you are assigning data of type Date, but in the second example you chain ToString() which converts the Date to a String, which would be the correct data type for being stored in Key3 of a UD Table.

6

I agree!

However it works in a Classic Customization. (And still does, we are using it every day). I pulled the bulk of the function code out of a customization that I wrote years ago to verify barcode swipes. This function is to help replace it when Classic sunsets.

The original issue with it not blowing up is quite odd as it would have had to process the error line too. It just wasn’t saving anything or erroring out.

Glad its solved. :slight_smile: