Velixo Functions

A listing of each Velixo function, what it does, and how to use it.

Gabriel Michaud avatar Harry Lewis avatar
86 articles in this collection
Written by Gabriel Michaud and Harry Lewis
General Ledger Functions

ACCOUNTBEGINNINGBALANCE function

Calculates the beginning balance of one or more general ledger accounts, for a specific period
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

ACCOUNTCLASS function

Returns the account class code of a specified General Ledger account.
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

ACCOUNTCLASSLIST function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

ACCOUNTCLASSNAME function

Returns the name of a specified account class
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

ACCOUNTCONSOLIST function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

ACCOUNTENDINGBALANCE function

Calculates the ending balance of one or more GL accounts as of a specific period
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

ACCOUNTNAME function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

ACCOUNTTOTALCREDITS function

Calculates the total credits of one or more general ledger accounts over a given period.
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

ACCOUNTTOTALDEBITS function

Calculates the total debits of one or more general ledger accounts for a given period
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

ACCOUNTTURNOVER function

Calculates the turnover of one or more GL accounts as of a given period
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

ACCOUNTTYPE function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

BRANCHLIST function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

BRANCHNAME function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

FINANCIALPERIOD function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

FINANCIALPERIODBYDATE function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

FINANCIALPERIODENDDATE function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

FINANCIALPERIODOFFSET function

Returns the Acumatica financial period that is a specific number of periods before or after the listed period
Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

FINANCIALPERIODSTARTDATE function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

SUBACCOUNTNAME Function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago
List Functions

ACCOUNTSANDSUBACCOUNTSWITHHISTORY function

Returns a dynamic array of each branch, account, and subaccount with account history
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

ACCOUNTSWITHHISTORY function

Returns an Excel array listing accounts for which there is account history during the specified period
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

COLLATE function

Combines multiple arrays or ranges into a single array
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

EXPANDACCOUNTCLASSRANGE function

Returns all general ledger account class codes within the specified range
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

EXPANDACCOUNTGROUPRANGE function

Returns all general ledger account group codes within the specified range
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

EXPANDACCOUNTRANGE function

Returns all general ledger account numbers within the specified range
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

EXPANDBRANCHRANGE function

Returns all branch codes within the specified range
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

EXPANDCOMPANYRANGE function

Returns all company codes for the tenant
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

EXPANDCOSTCODERANGE function

Returns all project cost codes within the specified range
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

EXPANDINVENTORYITEMRANGE function

Returns all inventory item codes within the specified range
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

EXPANDPROJECTRANGE function

Returns all project codes within the specified range
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

EXPANDSUBACCOUNTRANGE function

returns all general ledger sub-account codes within the specified range
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

FINANCIALPERIODLIST function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

TEXTSPLIT Function

Converts a delimited list into an Excel array of values
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

UNIQUEBYPATTERN function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago
Project Module Functions

ACCOUNTGROUPDESCRIPTION function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

COSTCODEDESCRIPTION function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

INVENTORYITEMDESCRIPTION function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTBEGINNINGAMOUNT function

Calculates the beginning amount of one or more project(s) and task(s) as of a specific period.
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTBEGINNINGQUANTITY function

Calculates the beginning quantity of one or more projects and tasks containing Inventory Item information
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTBUDGETAMOUNT function

Calculates the original budgeted amount of one or more projects and tasks
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTBUDGETQUANTITY function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTCHANGEORDERAMOUNT function

Calculates the change order amount of one or more projects and tasks
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTCHANGEORDERQUANTITY function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDAMOUNT function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDINVOICEDAMOUNT function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDINVOICEDQUANTITY function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDOPENAMOUNT function

Calculates the committed open amount of one or more projects and tasks
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTCOMMITTEDOPENQUANTITY function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDQUANTITY function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDRECEIVEDQUANTITY function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTCOSTATCOMPLETION function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTCOSTTOCOMPLETE function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTDESCRIPTION function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTENDDATE function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTENDINGAMOUNT function

Calculates the ending amount of one or more projects and tasks as of a specific period
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTENDINGQUANTITY function

Calculates the ending quantity of one or more projects and tasks containing Inventory Item information
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTFORECASTAMOUNT function

Calculates the original forecasted amount of one or more projects and tasks
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTFORECASTQUANTITY function

Calculates the original forecasted quantity of one or more projects and tasks
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTFORECASTREVISEDAMOUNT function

Calculates the revised forecasted amount of one or more projects and tasks
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTFORECASTREVISEDQUANTITY function

Calculates the revised forecasted quantity of one or more projects and tasks
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTPENDINGINVOICEAMOUNT function

Calculates the pending invoice amount of one or more projects and tasks
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTREVISEDBUDGETAMOUNT function

Calculates the revised budgeted amount of one or more projects and tasks
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTREVISEDBUDGETQUANTITY function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTREVISEDCOMMITTEDAMOUNT function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTREVISEDCOMMITTEDQUANTITY function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago

PROJECTSTARTDATE function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTTASKDESCRIPTION function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTTASKENDDATE function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTTASKPLANNEDENDDATE function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTTASKPLANNEDSTARTDATE function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTTASKSTARTDATE function

Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTTURNOVERAMOUNT function

Calculates the turnover (net change) amount of one or more projects and tasks over a given period
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

PROJECTTURNOVERQUANTITY function

Gabriel Michaud avatar
Written by Gabriel Michaud
Updated over a week ago