This is an old revision of the document!
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}%