Acumatica delivers a comprehensive reporting toolkit that gives stakeholders visibility into real-time business performance. The system emphasizes a “single version of the truth” via multi-dimensional, role-based reporting and dashboards. Examples of these include:
• Prebuilt Reports: Every Acumatica application (Financials, Distribution, Manufacturing, etc.) comes with essential reports out of the box (e.g., General Ledger, AP/AR reports, inventory analysis). These deliver real-time data without users having to write code.
• Custom Reports and Dashboards: Users can quickly modify existing reports or design new ones to fit their needs via the Report Designer (more on this below). Dashboards support a variety of widgets (charts, KPIs, grids, and pivot tables) that display filtered views of GI results, ensuring everyone has access to the same accurate underlying data. This access to reports and dashboards is controlled by user roles, so each person sees only the data they are authorized to view.
• Flexible Display: Reports and dashboards can be viewed on-screen, printed, or exported to Excel/PDF, and dashboards adapt to different devices for mobile/desktop views.
Taken together, these features let companies monitor key metrics and spot trends quickly.
Acumatica Report Designer
For highly formatted reports, Acumatica provides the Report Designer, it opens Acumatica’s database in a design interface. Users can add data fields, define parameters, and lay out pages exactly as needed. For example, the Report Designer lets you define input parameters or filters to limit data (e.g., select a specific customer or date range), specify grouping and sort order, and incorporate formulas or sub-reports.
In short, when Acumatica’s built-in reports don’t fully meet your needs, the Report Designer enables you to create printable reports with complete control over formatting. Reports can include charts, barcodes, and calculated fields and can be saved to the ERP solution or exported externally.
Reports are great for static snapshots and official outputs, but what if you need interactive “slice-and-dice” analysis?
That’s where Generic Inquiries come in.
Data Refining with Generic Inquiries
Generic Inquiries (GIs) in Acumatica are user-friendly query builders that extract and present live data from the ERP database. A GI is essentially an easy-to-use SQL-based query where you define which tables and fields to join and how to filter and sort the results.
You can think of a GI as asking Acumatica a question (e.g., “Show me all inventory items below safety stock”) and getting back a data grid as the answer. Because GIs use the underlying SQL tables but have a no-code interface, even non-developers can build powerful queries. Out of the box, Acumatica provides standard GI templates (e.g., find all customers, find all sales orders), and you can extend these or create new inquiries to pull exactly the information you need every time.
Key benefits of Generic Inquiries include:
• Custom Dashboards and Reports: GIs can feed dashboard widgets and pivot tables. For example, you can build a GI that computes key performance indicators (KPIs) and then display those KPIs on a real-time dashboard.
• Drill-Down Analysis: Query results can be grouped, sorted, and filtered on the fly, and you can drill into any record. For instance, a GI can list sales orders, and clicking on an order number can open the order details.
• Quick Ad-Hoc Queries: Need a one-off report? GIs let you pull data on the fly. For example, generate a list of open invoices over a certain threshold or a list of customers in a certain region without writing SQL.
• Data Health and Alerts: Generic inquiries can help identify data discrepancies (e.g., missing addresses, negative inventory) or feed into Anomaly Detection. They can also be used to trigger Business Events, like sending alerts when a GI finds an overdue obligation.
By giving business users direct access to query their data, GIs turn raw tables into refined, actionable information. The built-in Acumatica GI interface (screen SM208000) lets you select tables and specify joins, choose which fields appear on the Results Grid, and set conditions and parameters for filtering. Any GI can be saved, shared, and reused.
Anomaly Detection: Strategies for Data Refinement
When designing Gis for anomaly detection, it’s helpful to consider how they will be used operationally. Two common approaches to using GIs in business management are Manage by Exception and Manage by Routine:
• Manage by Exception: Focus on outliers or anomalies that need immediate attention. For example, set up GIs to highlight production variances automatically (like labor hours exceeding estimates or machine downtime beyond thresholds), supply chain issues (like vendors delivering late or with high cost variances), or data quality exceptions (like missing critical data or quality control issues). By filtering for these exception conditions, managers can quickly spot and correct problems.
• Manage by Routine: Guarantee that routine processes stay on track by monitoring baseline metrics. Examples include a GI that tracks average lead times on purchase orders or production cycles, daily labor hour totals by employee, or routine inventory levels. Ensuring these numbers remain within normal ranges provides confidence in the data and processes.
Using GIs in both modes means you can both proactively catch issues (exceptions) and ensure healthy data flows (routines).
Using Generic Inquiries in Dashboards
Generic Inquiries serve as the data engine for dashboards in Acumatica. By leveraging GI filters and drill-down capabilities, dashboards become highly interactive and tightly coupled with live ERP data. Once created, GIs can power dashboard widgets.
In Acumatica, a dashboard widget will usually source its data from any GI (by selecting the GI widget type). When you add such a widget, you choose the GI screen (SM208000) and specify which inquiry and fields to display. The GI’s filters can be used to limit the dashboard data. For example, you can mark a GI filter as Shared so that setting a filter value (say a date range or a specific vendor) affects all related widgets on the dashboard.
Users can also add widgets that display the number of anomalies found by a GI and clicking such a widget drills into the GI list of exception records. In practice, you might put a labor performance metrics GI into a dashboard and filter by work center or week, or you could put a vendor performance GI in a chart widget that filters vendors by region. Under the hood, the dashboard widget simply runs the GI with the given filters.
Putting It All Together
In summary, Acumatica offers a spectrum of data and reporting tools. Standard reports and the Report Designer provide formatted outputs on demand. Generic Inquiries give users the power to refine and slice ERP data for deeper insight. And new AI-powered functionalities, like Anomaly Detection, leverage those GIs to flag outliers automatically.
By combining these features, organizations gain actionable visibility into data entities such as lead times, labor usage, vendor metrics and more, enabling both exception-driven management and routine performance tracking.