 |
|
|
ExpenseAnalysis() Returns expense and general ledger account allocation information. Syntax ExpenseAnalysis( <dDate1>, [<dDate2>], <cAccount1>, [<cAccount2>], [<cDepartment>], [<cAccount>]) --> xRet Arguments <dDate1> --> the first date to include in the range. <dDate2> --> the last date to include in the range. If not specified this is assumed to be the same as the first date. <cAccount1> --> is the name of the first account code to analyse. <cAccount2> --> is the name of the last account code to analyse. If not specified is this assumed to be the same as the first account. The totals for all accounts between the two account codes are included in the return value. <cDepartment> --> is the department code. Do not specify this value to return information for all departments. <cAccount> --> is the supplier account code. Do not specify this value to return information for all accounts. Returns The dollar total. Description The total dollar value is returned for all transactions (except payments) assigned to the designated account codes between the specified date range.
Example This example returns the dollar value allocated between the dates dDate1 and dDate2 for the account codes between 20000 and 20500. nValue := ExpenseAnalysis(dDate1, dDate2, "20000", "20500") This example returns the dollar value allocated between 01/01/2002 and 31/12/2002 for the expense or general ledger account code 21000 Return ExpenseAnalysis(DTOC("01/01/02"), DTOC("31/12/02"), "21000") ____________________________ Related Topics |
Performance can be improved by opening the allocation
database file ALLOC_3.DBF within the Links section of the form.
Nonetheless, if the file is not open, it will be opened
automatically when this function is executed.