Hi I would like to Execute A BAQ within a Function to create multiple records in a UD Table. I have read some posts and have not had much luck doing this. I would also like to send this BAQ some parameters . From what I understand widgets are what I should be using but am open to any suggestions as…

You can do it with widgets in a function. You need to add the service to the function so you can get to the BO. Then you’ll get paramaters by ID, set the results to a queryexecutiondataset variable that you create. Then you set a field by query, where you set each of your parameters in the dataaset,…

Say more Execution a baq within a function while not imposible seems like jumping over a dollar to pick up a cent. In a function you are already server side and have access to the entire Db context. Can you tell us more about the business problem

First, I completely agree with Jose about knowing what business problem you’re trying to solve. I will push back a little bit on using a BAQ. If you need company, site, territory security or have complicated joins, then a BAQ can be a better choice IMHO.

I developed a complicated program in vb.net for the classic interface and do not have alot of skills in C# at the moment. My thoughts are that I should try and minimize writing code so I developed a reasonably complex BAQ that does perform all the calculations needed. At this point all I really woul…

Yes. This is a description of your technical problem trying to implement a particular solution. What is the business problem you are solving? What is going into a UD Table? Who is accessing this table? Knowing this can sometimes lead to other opportunities.

The business problem is i had to develop a custom Work In Process report.We have worked with consultants to try and use the existing one in Epicor and it will not meet our needs.The reason a UD Table is being used is to store the values for all periods upon which it is executed so that a comparisio…

The users accessing this are the Finance department.

Gotcha. It’s a BI solution. I assume we run this at month end then?

I think all the code you need exists around here: Execute a baq from a function Reference data in the results Insert records into a UD table There are threads on all these topics just have to piece it together. [image] BAQ in Function Epicor ERP 10 Good afternoon and t…

But there is actually an easier way to do this if you are able to run it on a schedule and don’t need ad hoc parameters - just set up an executive query. This stores the results of your BAQ into a cube. You can schedule your executive query in the system agent and it will do either delete/replace …

Execute A BAQ within a Function to create multiple records in a UD Table

Kinetic ERP

aosemwengie1 (Alisa Osemwengie) July 13, 2025, 3:43pm 10

I think all the code you need exists around here:

Execute a baq from a function
Reference data in the results
Insert records into a UD table

There are threads on all these topics just have to piece it together.

there are a couple to get you started . . .