Table of Contents

LineBudget

This function returns the budget of a user report line for a given month and year. The day portion of the date is ignored.

When budget numbers are entered in the GL they are entered for the current month only. However, for income and expense accounts, the LineBudget function returns the cumulative year-to-date budget number. For example, if a user report line consisted of a single income account that had a constant monthly budget of $10,000 per month, the LineBudget function would return $40,000 for the April budget.

LineBudget(UserRpt, LineCode, BudgetDate, Company)

Example Usage

Required Parameters

UserRpt

The name of the user report (not its description)

"BALCON"
"INCST2"

%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%

LineCode

The 3-digit user report line item code.

"A01"
"C15"

%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%

BudgetDate

The date that represents the month and year used to retrieve the budget numbers

"3/31/2009"    Returns the budget for March 2009
 "3/1/2009"    Returns the budget for March 2009
"3/17/2009"    Returns the budget for March 2009

%fineprint{Used in: Budget, FedRptBudget, LineBudget, LineBudgetRound}%

Optional Parameters

Company

The company suffix code used to restrict user report numbers to a single company. To include all companies, either 1) do not enter anything for this parameter or 2) use the abbreviation "Con" (for Consolidated). To include only the default Citizens company, use either 1) double quotes with nothing inside: "" or 2) the abbreviation "Cit" (for Citizens).

           Consolidated
"Con"      Consolidated
""         Citizens Savings Bank
"Cit"      Citizens Savings Bank
"CSA"      CSA Services, LLC
"CSB"      CSB Services, Inc.

%fineprint{Used in: FedRptAvgBal, FedRptBalance, FedRptBudget, LineAverage, LineBalance, LineBudget}%