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.

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.

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")

____________________________