Acumatica Generic Inquiries for reporting and analytics

Easily extract the data you need and make it available to multiple reporting and analytics applications with Acumatica ERP Generic Inquiries.

Play Video

How Generic Inquiries Can Work For You:

Generic Inquiries in Acumatica allows you to take raw data and present it for reporting in a way that it can be analyzed. 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 and Acumatica will walk you through the process. Generic Inquiries can be reused and modified for a variety of purposes.

KEY BENEFIT

Have Access to Any Data

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

No Coding Required

Use Generic Inquiries without knowledge of coding. Select all the information you need from the database tables using the Generic Inquiry Writer.

Data Security

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

KEY FEATURES

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.

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

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

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.

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

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

Ready to see a demo?​