Epicor ERP solutions are built to store large volumes of data. However, this data is not useful unless it is easily accessible. Epicor BAQ (Business Activity Queries) are an invaluable tool for accessing and working with data from across the Epicor system, allowing organizations to leverage the information for decision-making purposes.
Browse our comprehensive guide to BAQ in Epicor to understand the key features and purpose of BAQs and how to utilize each tool effectively. For more help, do not hesitate to contact TeccWeb’s Epicor experts.
Business Activity Query in Epicor, commonly called BAQ, allows you to retrieve and update data within your ERP. Database systems use query languages to access and modify data. Within Epicor, BAQs are built within the Business Activity Query Designer, a feature-rich environment where queries can be developed and tested.
BAQs are helpful for understanding data and relationships within the Epicor system, including as a dashboard component or as the base data for custom reports. BAQs can be referenced within customizations, and queries can be set up within BPMs to retrieve or update records.
Drag and drop business activity query design tools for adding and linking tables make building BAQs accessible to non-programmers. More technical users can also leverage advanced tools and features such as calculated fields and various subquery types.
When building BAQs, related database tables link automatically when added to the query, allowing newer users not yet wholly familiar with the Epicor database structure to successfully find data and link it appropriately to return the results desired. Tables that aren’t formally linked in the database structure can also be connected, allowing users the flexibility of returning data for specific reporting purposes.
The Query Designer clearly lists all available fields that can be accessed through each individual table, and subqueries can be developed and defined through specific options.
The Report Designer allows users to design and format reports for printing, sharing and presentations. It has many tools for adding headers, footers, charts and other visual elements to the report.
Epicor’s built-in automation tools, such as Task Schedules, can trigger the execution of BAQs and the generation of recurring reports without manual intervention. It is especially handy to automate end-of-month processes.
Users can set conditions and filters to narrow down the query results. Parameters are added to allow dynamic input at runtime, making the queries more flexible. There are 4 types of parameters:
Subqueries are queries within queries. Using subqueries allows the user to create complex queries, which is particularly useful for retrieving data dependent on another query’s result. There are three types of subqueries, known as
Using subqueries allows for enhanced data filtering based on aggregates, conditional filtering, existence checks and dynamic filtering.
Updatable BAQs can also be created through the same designer. These queries can be set up to change or add data to various records in the database and allow the development of an Updatable Dashboard (a user-friendly view of the data).
The Analyze tab within the Designer makes validating and running a query possible. In the case of an updateable BAQ, it is possible to test the update function before rolling out the results to end users.
Starting in Kinetic release 2023.2, a BAQ is available as a Data Source within other BAQs. This update makes it possible to reuse one query and return specific results within another query, which can save time and effort when building more complex data relationships that have logic in common.
Business Activity Queries are a powerful tool which can pull data from across your system and display it in a format that works to benefit your organization. BAQs give great insight into the data behind your business and can be used to build Dashboards and BAQ reports that will be valued by users across the organization.
If you have any questions about Epicor BAQ, the Epicor experts at TeccWeb will gladly help you.