Acumatica Generic Inquiries

Power Your Business with Acumatica Generic Inquiries

Acumatica Generic Inquiries offer a way to extract the specific data you need and present it to reporting functions for analysis. But they are not just for reports – they can be used in dashboards, made available to BI tools, and offer drill down capabilities for even more detailed analysis. The Generic Inquiry writer is a reporting tool that can access any data in Acumatica including data stored in customized fields and publish it, export to Excel, or format it for OData. The OData formatting option exposes the data in the Open Data Format supported by business intelligence tools like Microsoft Power BI.

Generic Inquiries require no prior coding knowledge, just select the data you need using wizards that walk you through the process. Generic Inquiries can be reused and modified for a variety of purposes.

Powers These Acumatica Suites

Benefits of Acumatica Generic Inquiries

Accounting Business Solutions Pink Bean

Access Any Data in Acumatica

Generic Inquiries can access any data contained in Acumatica and make it available for reports, dashboards, Excel files, or OData.

Accounting Business Solutions Green Bean

No Coding Required

Users do not have to learn complex programming languages to use Generic Inquiries. Just select the information you need from the database tables using the Generic Inquiry Writer.

Red misshapen circle on a light gray background

Data Security

Generic Inquiries enforce all security rules, so you can manage all ERP data security from a single location inside Acumatica.

Generic Inquiries and Pivot Tables Overview

Powerful Features of Acumatica Generic Inquiries

Yellow misshapen circle on a light gray background

Information You Need

Get the information you need when you need it. Generic Inquiries provide real-time data so you always have the current information at your fingertips.

Orange misshapen circle

Easy to Learn, Easy to Modify

Reuse Generic Inquiries for multiple applications. Make changes as needed.

Red misshapen circle on a light gray background

Complete Flexibility

Edit the inquiry form view and arrange the form elements as you need. After saving your changes, you can immediately check your changes.

Accounting Business Solutions White Bean

Pivot Tables

Create multiple pivot tables for each generic inquiry. You can use pivot tables to reorganize and summarize data in a generic inquiry and view it from different perspectives.

Accounting Business Solutions Blue Bean

Export Excel Parameters

Export a generic inquiry to MS Excel and place parameters on a separate Excel sheet. The result is an Excel file with a Data sheet containing the generic inquiry data and a Parameters sheet containing the parameters used prior to export.

Accounting Business Solutions White Bean

Save a Generic Inquiry Export as a Report

Export a generic inquiry as a report that can be modified in Acumatica Report Designer.

Accounting Business Solutions Blue Bean

Generic Inquiry Navigation Side Panel

Add a side panel to generic inquiries to show the details of specific records in an inquiry all on the same screen. Side panels can be resized, maximized, or minimized.

Accounting Business Solutions Pink Bean

Highlighting Results in Generic Inquiries

Highlight rows or columns of a Generic Inquiry based on specified conditions. For example, when inquiring on “opportunities”, the resulting grid can show those opportunities that have been won in green, those that have no owner can be yellow, and opportunities that are late can be red.

Yellow misshapen circle on a light gray background

Display Totals in Generic Inquiries

Users can request Generic Inquiries to display total values, including average, max, min, and sum.

Want the Power? Get the Bean!