<img src="https://secure.perk0mean.com/176329.png" alt="" style="display:none;">

Subscribe to get new posts and updates delivered.

How to Call a BAQ from Script Editor in Epicor ERP

By Amanda Hagedorn

ERP tech help

Call a BAQ from Script Editor

For this Epicor tutorial, I wanted to share a tip I have learned while working with a Business Activity Query (BAQ) in Epicor: how to call a BAQ from Script Editor.

After a BAQ has been created, you can then call the BAQ from code within the script editor inside of a customization, which allows you to access the data the BAQ returns.

Step 1

Assuming you are familiar with creating a customization, click on the “Script Editor” tab in your customization.

The first thing you must do is add in the necessary assemblies for calling a BAQ. In the menu bar of the customization screen, select “Tools” and then “Assembly Reference Manager” to open a new window. In the lower, right-hand corner of the window, click on the “Add Custom Reference” button.

Step 2

Select the following DLL files and click on the “Open” button.





Step 3

You will now see your newly added assemblies under the “Custom Assemblies” folder.

After you have closed the window, be sure to add the following using statement to the top of your code:

using Epicor.Mfg.Lib;

Step 4

Next, you will need to create a “session” variable inside the Script class:

// Add Custom Module Level Variables Here **

Epicor.Mfg.Core.Session session;

Inside the “InitializeCustomCode” method, initialize the session variable using the current form you are customizing:

public void InitializeCustomCode()


// End Wizard Added Custom Method Calls

session = (Epicor.Mfg.Core.Session)CustShipForm.Session;


Step 5

Last, in the method where you want to call the BAQ, initialize the “QueryDesignDataSet” and “DynamicQuery” objects, followed by the actual call.

You can pass query parameters in as well.

private void ShipHead_AfterFieldChange(object sender, DataColumnChangeEventArgs args)


// Initialize objects

QueryDesignDataSet dataset = new QueryDesignDataSet();

DynamicQuery query = new DynamicQuery(session.ConnectionPool);

// Point the dataset to the BAQ

dataset = query.GetByID(string.Format("{0}-BAQName", session.CompanyID))

// Pass in a parameter

dataset.QueryWhereItem[0].RValue = 123;

// Execute the BAQ

DataTable table = query.Execute(dataset).Tables["Results"];


Step 6

The data is returned in a DataTable to make it easy for you to access.

Wrap Up

Have more questions about your ERP instance? Datix is an Epicor Platinum Partner, meaning we're experts in all things ERP. Contact us today to learn more about our innovative solutions!


Tags: Epicor® and ERP, Power Tips: Epicor® ERP, Technology Tips & Tricks


From start to finish, the expert consultants at Datix understand your business needs and execute software solutions that work.