Velixo Functions

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

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

Written by Harry Lewis
Updated over a week ago

ACCOUNTCLASS function

Returns the account class code of a specified General Ledger account.

Written by Harry Lewis
Updated over a week ago

ACCOUNTCLASSLIST function

Written by Gabriel Michaud
Updated over a week ago

ACCOUNTCLASSNAME function

Returns the name of a specified account class

Written by Harry Lewis
Updated over a week ago

ACCOUNTCONSOLIST function

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

Written by Harry Lewis
Updated over a week ago

ACCOUNTNAME function

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.

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

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

Written by Harry Lewis
Updated over a week ago

ACCOUNTTYPE function

Written by Gabriel Michaud
Updated over a week ago

BRANCHLIST function

Written by Gabriel Michaud
Updated over a week ago

BRANCHNAME function

Written by Gabriel Michaud
Updated over a week ago

FINANCIALPERIOD function

Written by Gabriel Michaud
Updated over a week ago

FINANCIALPERIODBYDATE function

Written by Gabriel Michaud
Updated over a week ago

FINANCIALPERIODENDDATE function

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

Written by Gabriel Michaud
Updated over a week ago

FINANCIALPERIODSTARTDATE function

Written by Gabriel Michaud
Updated over a week ago

SUBACCOUNTNAME Function

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

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

Written by Harry Lewis
Updated over a week ago

COLLATE function

Combines multiple arrays or ranges into a single array

Written by Harry Lewis
Updated over a week ago

EXPANDACCOUNTCLASSRANGE function

Returns all general ledger account class codes within the specified range

Written by Harry Lewis
Updated over a week ago

EXPANDACCOUNTGROUPRANGE function

Returns all general ledger account group codes within the specified range

Written by Harry Lewis
Updated over a week ago

EXPANDACCOUNTRANGE function

Returns all general ledger account numbers within the specified range

Written by Harry Lewis
Updated over a week ago

EXPANDBRANCHRANGE function

Returns all branch codes within the specified range

Written by Harry Lewis
Updated over a week ago

EXPANDCOMPANYRANGE function

Returns all company codes for the tenant

Written by Harry Lewis
Updated over a week ago

EXPANDCOSTCODERANGE function

Returns all project cost codes within the specified range

Written by Harry Lewis
Updated over a week ago

EXPANDINVENTORYITEMRANGE function

Returns all inventory item codes within the specified range

Written by Harry Lewis
Updated over a week ago

EXPANDPROJECTRANGE function

Returns all project codes within the specified range

Written by Harry Lewis
Updated over a week ago

EXPANDSUBACCOUNTRANGE function

returns all general ledger sub-account codes within the specified range

Written by Harry Lewis
Updated over a week ago

FINANCIALPERIODLIST function

Written by Gabriel Michaud
Updated over a week ago

TEXTSPLIT Function

Converts a delimited list into an Excel array of values

Written by Harry Lewis
Updated over a week ago

UNIQUEBYPATTERN function

Written by Gabriel Michaud
Updated over a week ago

Project Module Functions

ACCOUNTGROUPDESCRIPTION function

Written by Harry Lewis
Updated over a week ago

COSTCODEDESCRIPTION function

Written by Harry Lewis
Updated over a week ago

INVENTORYITEMDESCRIPTION function

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.

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

Written by Harry Lewis
Updated over a week ago

PROJECTBUDGETAMOUNT function

Calculates the original budgeted amount of one or more projects and tasks

Written by Harry Lewis
Updated over a week ago

PROJECTBUDGETQUANTITY function

Written by Gabriel Michaud
Updated over a week ago

PROJECTCHANGEORDERAMOUNT function

Calculates the change order amount of one or more projects and tasks

Written by Harry Lewis
Updated over a week ago

PROJECTCHANGEORDERQUANTITY function

Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDAMOUNT function

Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDINVOICEDAMOUNT function

Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDINVOICEDQUANTITY function

Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDOPENAMOUNT function

Calculates the committed open amount of one or more projects and tasks

Written by Harry Lewis
Updated over a week ago

PROJECTCOMMITTEDOPENQUANTITY function

Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDQUANTITY function

Written by Gabriel Michaud
Updated over a week ago

PROJECTCOMMITTEDRECEIVEDQUANTITY function

Written by Gabriel Michaud
Updated over a week ago

PROJECTCOSTATCOMPLETION function

Written by Gabriel Michaud
Updated over a week ago

PROJECTCOSTTOCOMPLETE function

Written by Gabriel Michaud
Updated over a week ago

PROJECTDESCRIPTION function

Written by Harry Lewis
Updated over a week ago

PROJECTENDDATE function

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

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

Written by Harry Lewis
Updated over a week ago

PROJECTFORECASTAMOUNT function

Calculates the original forecasted amount of one or more projects and tasks

Written by Harry Lewis
Updated over a week ago

PROJECTFORECASTQUANTITY function

Calculates the original forecasted quantity of one or more projects and tasks

Written by Harry Lewis
Updated over a week ago

PROJECTFORECASTREVISEDAMOUNT function

Calculates the revised forecasted amount of one or more projects and tasks

Written by Harry Lewis
Updated over a week ago

PROJECTFORECASTREVISEDQUANTITY function

Calculates the revised forecasted quantity of one or more projects and tasks

Written by Harry Lewis
Updated over a week ago

PROJECTPENDINGINVOICEAMOUNT function

Calculates the pending invoice amount of one or more projects and tasks

Written by Harry Lewis
Updated over a week ago

PROJECTREVISEDBUDGETAMOUNT function

Calculates the revised budgeted amount of one or more projects and tasks

Written by Harry Lewis
Updated over a week ago

PROJECTREVISEDBUDGETQUANTITY function

Written by Gabriel Michaud
Updated over a week ago

PROJECTREVISEDCOMMITTEDAMOUNT function

Written by Harry Lewis
Updated over a week ago

PROJECTREVISEDCOMMITTEDQUANTITY function

Written by Gabriel Michaud
Updated over a week ago

PROJECTSTARTDATE function

Written by Harry Lewis
Updated over a week ago

PROJECTTASKDESCRIPTION function

Written by Harry Lewis
Updated over a week ago

PROJECTTASKENDDATE function

Written by Harry Lewis
Updated over a week ago

PROJECTTASKPLANNEDENDDATE function

Written by Harry Lewis
Updated over a week ago

PROJECTTASKPLANNEDSTARTDATE function

Written by Harry Lewis
Updated over a week ago

PROJECTTASKSTARTDATE function

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

Written by Harry Lewis
Updated over a week ago

PROJECTTURNOVERQUANTITY function

Written by Gabriel Michaud
Updated over a week ago

Generic Inquiry Functions

Introduction to Generic Inquiries

Bringing Acumatica Generic Inquiry results into Excel

Written by Harry Lewis
Updated over a week ago

GI function

Written by Harry Lewis
Updated over a week ago

GIFILTER function

Written by Gabriel Michaud
Updated over a week ago

GILOOKUP function

Written by Gabriel Michaud
Updated over a week ago

GILOOKUPF function

Written by Gabriel Michaud
Updated over a week ago

Audit Functions

LASTREFRESHDATE function

Returns an Excel date/time value of when the specified connection was last refreshed.

Written by Harry Lewis
Updated over a week ago

LASTREFRESHBY function

Written by Harry Lewis
Updated over a week ago

VELIXOVERSION Function

Written by Gabriel Michaud
Updated over a week ago

Writeback Functions

WRITEBACK function

Written by Gabriel Michaud
Updated over a week ago

WRITEBACKARGUMENTS function

Written by Harry Lewis
Updated over a week ago

WRITEBACKBUDGET Function

Written by Harry Lewis
Updated over a week ago

WRITEBACKPROJECTUPDATEBUDGET function

Written by Gabriel Michaud
Updated over a week ago

WRITEBACKPROJECTFORECAST function

Written by Gabriel Michaud
Updated this week