Configure search parameters in Acumatica exports

Use the Search parameters button to configure your export search. For example, if you export a list of all your vendors, you can use the search parameters to include or exclude specific fields.

Custom

Use the Custom search parameter to specify undefined fields, values not included in entity definitions, and values added to Acumatica ERP from a customized project.
Example:
BAccount.UsrAddress_Code,BAccount.UsrVendor_Code

Expand

Use the Expand parameter to specify the linked and detailed entities that should be expanded. By default, no linked or detail entities are expanded; only the top-level entity's fields are returned. Example:
Maincontact/Address

Filter

Use the Filter parameter to determine which records should be selected from Acumatica. Let’s say that you want to get a specific list of vendors. In the Filter field, you can specify that you want to get all the exported vendors modified after a specific date and time. You can use handlebars to refine your filters.
Example:
LastModifiedDateTime ge datetimeoffset'{{encodeURI lastExportDateTime}}'

Select

Use the Select parameter to specify the entity's fields to be returned from Acumatica ERP. By default, all fields of the entity are returned. The Select field is optional for operations that “list all” (List all vendors, List all warehouses, and so on). The default value of the Select field is blank, meaning all fields from the entity are returned.

Top

Use the Top parameter to specify the number of records to be returned from Acumatica ERP.