Overview

By default, the filter expressions you specify in GI / GILOOKUPF Velixo functions are handled by Acumatica, so as to reduce the amount of data that needs to be transferred between Acumatica and your report.

Performing filtering through OData is very fast; however, it does have some limitations.

For example:

If your filtering efforts encounter one or more of these limitations, you may want to force Velixo to do the filtering, instead.

As a rule of thumb, only use this option as a last resort.

The reason is that if your inquiry could return a very large dataset without a filter (as is the case with invoices or GL transaction details), enabling client-side filtering can have severe performance implications with massive amounts of data transferred between your ERP and Velixo.

Client-side filtering may also help if you need to pull data from the same generic inquiry using multiple different OData filter expressions, all in the same spreadsheet.

Keep in mind though: lookups by e.g. document reference number, or a customer name may be much more performant using GILOOKUPF, because it allows you to keep at least some of the filtering on the server.

From the Acumatica ribbon in Excel, select Options, then the three-dot kabob menu on the specific GI, and then Edit:

Edit_gi_options1.png

Then check the box for Always load the entire Generic Inquiry and filter the data locally:

Edit_gi_options2.png

This will do exactly that: the entire data set from the inquiry will be downloaded and then Velixo will do the filtering.

You can now refresh your report and the filtering of your GI() function(s) will be handled within Excel by Velixo Reports.

Did this answer your question?