Free Product Tour

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.

How Generic Inquiries Can Work for You

Generic Inquiries in Acumatica 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.

For more detail on Generic Inquiries, view these videos:

  • Pivot Tables in Acumatica ERP (8 minutes)
  • Information Drill Down using Generic Inquiry (5 minutes)

Generic Inquiries and Pivot Tables

Key Benefits of Generic Inquiries for your Company

  • 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.

  • 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.

  • Data security

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

Important Features of Generic Inquiries

  • 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.

  • Easy to learn, easy to modify

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

  • 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.

  • 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.

  • ERP Cost of Ownership: Get the Facts Now

    What are the true costs and benefits of your next ERP solution? Crunch the numbers and print your results.