AvgBal

This is the average balance function. It returns the daily average balance of a GL account for a given month (or span of months).

%InlineCode{AvgBal(AcctNum, AvgBalDate, PosNeg, StartDate)}%

AcctNum

The GL account number or TFR line number. This must include any applicable company abbreviations.

"1010-000"
"1010-000CSB"
"SC110"
"SO11"

%fineprint{Used in: AvgBal, Balance, Budget, Description}%

AvgBalDate

The date that represents the month and year for which to compute the daily average balance (when used without the optional StartDate parameter).

"3/31/2009" Returns the daily average balance for 3/1/2009 through 3/31/2009, inclusive
"3/1/2009" Returns the daily average balance for 3/1/2009 through 3/31/2009, inclusive
"3/17/2009" Returns the daily average balance for 3/1/2009 through 3/31/2009, inclusive

The date that represents the month and year through which to compute the daily average balance (when used with the optional StartDate parameter).

"3/31/2009", with StartDate of 1/1/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive
"3/1/2009", with StartDate of 1/31/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive
"3/17/2009", with StartDate of 1/12/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive

%fineprint{Used in: AvgBal, FedRptAvgBal, LineAverage, LineAverageRound}%