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. Learn more in Acumatica Generic Inquiries for Reporting and Analytics.
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 it to Excel, or format it for OData. The OData option exposes the data in the Open Data Format, which is supported by business intelligence tools such as Velixo.
Velixo provides several GI functions. In this article, we explain how to begin using these functions.
To use the GI function, the installed version of Microsoft Excel must support dynamic arrays (as of this writing, only recent versions of Excel linked to a Microsoft 365 subscription support dynamics arrays). Otherwise, Excel will display #NAME? in any cell containing an unsupported Velixo function.
You can check if your version of Excel supports dynamic arrays by accessing the SORT() or SORTBY() function in Excel:
Access to these functions means that you have a version of Excel that supports dynamic arrays.
Microsoft offers 3 different update channels for Microsoft 365: Current, Monthly and Semi-Annual. As of June 2020, dynamic arrays are only available for users in the Monthly and Current channels. You can check which channel you're on by clicking on File ->Account from within Excel:
Your IT administrator can change the update channel from the Microsoft 365 admin center or the Office Deployment tool.
|MYOB Advanced users wanting to use the Generic Inquiry functionality will need to contact their business partner
about obtaining an add-on license.
Prepare to use a generic inquiry
Follow these steps to prepare for accessing a generic inquiry from a Velixo function:
- Go to the Generic Inquiry page in Acumatica
- Access the inquiry from the Inquiry Title lookup.
- For the inquiry, check the Expose via OData box. This will make the inquiry available for use with Velixo.
- Note the Inquiry Title. This will be used for the Name argument of a GI function.
In this basic usage of the GI function, the inquiry title "VelixoReportsPro-Accounts" is given for the Name argument:
Various configuration settings can be used to optimize performance (by restricting the amount of data that is drawn from the generic inquiry). After adding one of the GI functions to a workbook, we click Options in the Acumatica ribbon to display Options window and define the Generic Inquiries Options.
Basic example using GI function
Consider this basic example of using the GI function:
This will produce results similar to what is shown in the figure below, a lists all of the rows for the VelixoReportsPro-Accounts generic inquiry in the Demo connection to Acumatica.
In GI function, learn how to use the GI function and see a number of examples.