GI Function Select statement

Q&A
1

GI Function have the Select.

=GI(Connection, Name, Filter, Select, IncludeHeader)

This is the Comma-separated list of field names to be included in the resulting dataset.

How can I return the values in the Select statement & include Header with own defined Caption?

VelixoGIQuestion.docx (33 KB)

2

Hi Retha,

You need to keep the Select argument with the required columns, set IncludeHeader = FALSE, and then add a new row before the GI function with the manually added headers.

3

Hallo Yes the explanation is correct the issue is that the Velixo GI does not accept the Acumatica Caption value. Hence I am unable to use the values in the columns

4

Hi Retha,

The select argument does not allow spaces, so in your attachment, for the caption “Shipping Invoice Date”, the formula requires you input this as “ShippingInvoiceDate”.

Hope this helps.