Using arrays or cell references as parameters in GL functions

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)

Troubleshooting

When using arrays as cell references, it is usually necessary to only use one array reference within a function.  

For example, here we are using an array reference to the array of account codes in column C (but only to the individual branch code in row 6):

If we tried to use an array reference for *both*, we would get an error message (because the two arrays are of different sizes):

(Argument size mismatch: all arguments containing more than one value are expected to be of the same size.)