Hello Tammy,
Hope you’re well.
Apologies for the large delay here.
I wanted to go ahead and do a writeup for this post, since I think it is valuable to anyone stumbling across it.
Here’s the solution:
In Application Studio, you will need to call the function:
Trigger:
And pass the parameters to the function:
You can remove the kinetic-messager-handler for a production deployment, I only had it there for debugging purposes.
Now you’ve hit the function, so let’s look at that:
References-Tables:
References-Services:
Security: Add the company this will be operating within to the “Authorized Companies” list.
For the function itself, be sure to add the parameters to the “Request” list as we discussed earlier. This is what is being passed from Application Studio to our function.
The function itself is simple, just a code block. I will explain why I used only code instead of declarative solution later:
This is the code you will put into that Execute Custom Code block:
//Andrew I, 2/11/26
this.CallService<Erp.Contracts.NonConfSvcContract>(
nc =>
{
var NonConfTS = nc.GetByID(tranID);
var NonConf = NonConfTS.NonConf.FirstOrDefault();
var newNonConf = (Erp.Tablesets.NonConfRow) NonConfTS.NonConf.NewRow();
BufferCopy.Copy(NonConf, newNonConf);
NonConfTS.NonConf.Add(newNonConf);
NonConf.RowMod = "U";
NonConf["InspecTime_c"] = InspectTime;
nc.Update(ref NonConfTS);
});
If you do a full trace of the process, you will see a “PreUpdate” is called prior to the update. Upon reading the description of the method: PreUpdate - “This method does: 1 - Returns a record in the LegalNumGenOpts datatable if a legal number is required for this transaction. The RequiresUserInput flag will indicate if this legal number requires input from the user. If it does, the LegalNumberPrompt business objects needs to be called to gather that information. This method should be called when the user saves the record but before the Update method is called.”
If this is relevant to you, just add
nc.PreUpdate(ref NonConfTS);
before the update.
Once you’re done, just go to the “Actions” and “Promote Library to Production” so Application Studio can hit your function.
That’s it, you’re done. Congrats on your first function!
Some extra information and breakdown for those interested:
I was unable to get the solution working without code as mentioned earlier, and opted for a full code solution on the Function end.
Upon testing via the REST API Help page, I noticed when I was attempted to hit the NonConf update directly it wasn’t working when I was passing my dataset. When looking through the data that is passed to the update method in the google dev tools (F12 to open), I saw this:
Epicor passes two rows, and it does this in several places in the system. One row contains the dirty changes (ie changes uncomitted to the DB), and the other is the original row. This is generally done so the program can compare the changes, and only push the diff of the changes. When I copied this payload DS, and passed it to the NonConf.Update function in the REST API Help interface, I saw method didn’t error.
Therefore, in order hit this NonConf.Update, we need to do pass the dirty and original row. That is why in the code we have this section:
var NonConf = NonConfTS.NonConf.FirstOrDefault();
var newNonConf = (Erp.Tablesets.NonConfRow) NonConfTS.NonConf.NewRow();
BufferCopy.Copy(NonConf, newNonConf);
NonConfTS.NonConf.Add(newNonConf);
I mention the REST API Help interface several times. To access that, follow this format: https://[your epicor server]/EpicorERP/api/help/v2/
You can find this server link/path inside of your Epicor client on the top right:
Lastly, for those who are interested in writing more code, another important detail is the way to “call” a BO differs in Function vs BPMs. As you can see in this function, the BO is called like so:
this.CallService<Erp.Contracts.NonConfSvcContract>(
nc =>
{
This differs from the syntax in a BPM which would look more like this:
var NCsvc = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.NonConfSvcContract>(Db);
Source - Functions data context - #8 by SAD
Sergey Davydkin is a former Epicor employee who helped build Epicor Functions. He talks more about this concept here for those who are interested.
Feel free to let me know if you have any other questions. Have a great day!
EDIT -
Another note here, in the code you will notice this:
NonConf.RowMod = "U";
NonConf["InspecTime_c"] = InspectTime;
As @klincecum mentioned above, for UD fields, you need to access them slightly differently to update the data. So for non-UD fields, you can access them like a normal ORM. For UD fields, you need to access them like you would access the value of a dictionary.
In addition to that, when making updates, you will always need to add
“NonConf.RowMod = “U”;”. There are 3 options. A - add, U - update, D - delete. The RowMod in the dataset tells the update there are changes to be committed to the DB. So if you are ever calling “Update” and nothing is happening, ensure the RowMod value is being set.
with my first stab at functions.
If I do a contrl & Space after putting in row.ins it doesn’t even find my field.
