XDataLookup

XDataLookup - Indices of Sage 50 data for a given lookup

Description

Sage 50 Canadian Edition  This function is only available for Sage 50 Canadian edition

This function returns the indices corresponding to the requested criteria.

Parameters

Table

Database table from which the data will come.

Column

Column to search.

Value

Value to lookup.

Dataset [Optional]

Custom dataset to use.

Connections [Optional]

Sage 50 Connection to query. If left empty, the default connection will be used.

Examples

It is strongly recommended to use an Excel cell address (ex. A1:B19) containing the information of the parameters requested in all Logicim XLGL functions, such as names or codes. This practice adds flexibility to your worksheet and will ensure the coherence of your results. Moreover, the use of quotation marks (") is essential when the parameters are manually written in the arguments function window.

Returns the indices from table tCustomr for column sName and value "Ashburton Reinforcing"

=XDataLookup("tCustomr", "sName", "Ashburton Reinforcing")

Edited: Tuesday, November 05, 2024

Was this article helpful?

Thank you! Your feedback matters.

We'd love to hear your thoughts! Please provide a comment before submitting.

Thank you for your feedback!

Would you like to receive a direct response to your comment?

If so, please enter your email address below.

You will also receive a copy of your comment.

We protect your personal information.

Thank you for your feedback!

Verify your inbox or spam folder to find the copy of your comment.
Contact clientcare@logicimtech.com if you didn't receive it.

Related articles
Accounts parameter
Departments parameter
XUSFinancial
XGLBudgets
XCompany
XConnect
XCustomerOrder
XCustomerOwing
XCustomerQuote
XData
XDataArray
XDataCondition
XEmployeeHours
XGL
XGLDesc
XGLDescDept
XGLP
XINV
XINVP
XINVVAL
XINVVALP
XVendorOrder
XVendorOwing
XVendorQuote
Can't find what you're looking for?

You can Contact us so we can address your question.