Using arrays or cell references as parameters in GL functions

Created by Harry Lewis, Modified on Wed, 30 Aug, 2023 at 12:24 AM by Damien Zwillinger

Applies to:

  • Velixo Classic
  • Velixo NX
  • Every ERP


Overview

 

The General Ledger functions in Velixo Classic (version 6.1.1 or higher) support the use of Excel array references for any of the parameters.

 

Examples would be:

  • A1:A100

  • A1#

  • {"10200", "10300", "10400"}

 

Multiple arguments can be Excel arrays or cell ranges (but all non-single-value arguments must have the same size) and the function will produce a dynamic array of the same size

 

Examples

In this example, cell C3 contains a dynamic array function (EXPANDACCOUNTRANGE):

 

The function in cell D3 contains a dynamic reference to the entire array in cell C3.  Used this way, the ACCOUNTNAME function will return the name of every account shown in column C.


Each parameter in a function can reference a different array (as long as each array is the same size):

 

(here, both the ACCOUNT and BRANCH parameters reference a range of cells)

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