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.
0 Votes
R
Retha van Alphenposted
8 months ago
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
0 Votes
Miron Shikhovposted
9 months ago
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.
0 Votes
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?
Attachments (1)
VelixoGIQues....docx
32.6 KB
0 Votes
3 Comments
JohnH3 posted 3 days ago
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.
0 Votes
Retha van Alphen posted 8 months ago
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
0 Votes
Miron Shikhov posted 9 months ago
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.
0 Votes
Login or Sign up to post a comment