By using this website, you agree to our Terms of Use (click here)
Does anyone have a comprehensive list of the functions currently available in Velixo Reports and what each one is used for?
Hi Animal,
I'm not sure how "comprehensive" these explanations are, but here is an attempt to answer your question.
ACCOUNTBEGINNINGBALANCE(Connection,Ledger,AccountClass,Account,Subaccount,Branch,AsOfPeriod)
This function is the equivalent of the Beg. Balance option in the Amount Type field in the Data Source window of Analytical Report Manager (ARM).
ACCOUNTENDINGBALANCE(Connection,Ledger,AccountClass,Account,Subaccount,Branch,AsOfPeriod)
This function is the equivalent of the Ending Balance option in the Amount Type field in the Data Source window of Analytical Report Manager (ARM).
ACCOUNTNAME(Connection,Account)
Basically, you just put in an account number (same as the Account field in the Chart of Accounts screen) and it will retrieve the account name (same as the Description field in the Chart of Accounts screen).
ACCOUNTTOTALCREDITS(Connection,Ledger,AccountClass,Account,Subaccount,Branch,FromPeriod,ToPeriod)
This function is the equivalent of the Credit option in the Amount Type field in the Data Source window of Analytical Report Manager (ARM).
ACCOUNTTOTALDEBITS(Connection,Ledger,AccountClass,Account,Subaccount,Branch,FromPeriod,ToPeriod)
This function is the equivalent of the Debit option in the Amount Type field in the Data Source window of Analytical Report Manager (ARM).
ACCOUNTTURNOVER(Connection,Ledger,AccountClass,Account,Subaccount,Branch,FromPeriod,ToPeriod)
This function is the equivalent of the Turnover option in the Amount Type field in the Data Source window of Analytical Report Manager (ARM).
BRANCHNAME(Connection,Branch)
Basically, you just put in a branch number (same as the Branch ID field in the Branches screen) and it will retrieve the branch name (same as the Branch Name field in the Branches screen).
FINANCIALPERIODENDDATE(Connection,Period)
You put in a financial period that corresponds to the Financial Period ID column in the Financial Periods screen and this function will return the End Date column from the Financial Periods screen.
FINANCIALPERIODSTARTDATE(Connection,Period)
You put in a financial period that corresponds to the Financial Period ID column in the Financial Periods screen and this function will return the Start Date column from the Financial Periods screen.
That's pretty comprehensive. Thank you!
Online Members
