GILOOKUP function

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 5:50 PM by Gabriel Michaud

Applies to:

  • Velixo NX
  • Velixo Classic
  • Acumatica, Cegid, MYOB
  • GI Module


The GILOOKUP function returns the value of a single field from a Generic Inquiry by specifying the keys of the single row to locate.

 

Syntax

This is the syntax for this function:

 

  =GILOOKUP(Connection, Name, Column, Keys)

 

 

Parameters

This function has the following Parameters:

Parameter

Required/Optional

Description

Connection

Required

The name of the connection, as specified in the Connection Manager

Name

Required

The name of the Generic Inquiry

Column

Required

The specific field to be returned from the inquiry data

Keys

Required

One or more Key(s) to be used to filter the data



Additional Notes

⚠ For each Generic Inquiry that you use with the GILOOKUP function, you will need to explicitly specify the inquiry's key columns in the Generic Inquiries Options section of the Velixo Options window.

 

Example

=GILOOKUP("Demo", "AR-Invoices and Memos", "Status", "002263", "Overdue Charge")

Description

Assuming that Generic Inquiry Key Fields options for the AR-Invoices and Memos are configured as:

 

gi_keyfields.png


This function call returns the Status field for the record in the database where the ReferenceNbr field is 002263 and the Type field is Overdue Charge.

 

Result:

Closed

 

gilookup_example.png


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article