Calculating the budget number for a Billing transaction

You can direct Infor Public Sector to calculate whether to use a budget number for a particular billing transaction using a budget number formula. For example, if your water revenue is broken down by district, your agency may use a different budget account for each district. You could write a formula that uses budget number NW013 if the district is NORTHWEST and budget number SW017 if the district is SOUTHWEST. Specify a budget number formula when you assign a budget number to a transaction type. If the formula already exists in your records, select it from the Formula popup accessed from the Credit Budget Number and Debit Budget Number fields. Note that before you can assign a budget number, you must define it using the Budget tools in the Infor Public Sector Resources product.

Budget number formulas use the oAccount object (an instance of the Hansen.Billing.Account class) and, depending on the transaction group in which the transaction type node is displayed, either the oDepositTransaction object (an instance of the Hansen.Billing.DepositTransaction class) or the oAccountTransaction object (an instance of the Hansen.Billing.AccountTransaction class) to set sBudgetNumber to one or more budget numbers, depending on conditions specified in the formula. If you want to use the same budget number for this transaction type, type sBudgetNumber = n where n is the budget number. For more information about this object and for sample code, click the Information tab in the Formula Editor.

If 
		  oAccount.Parcel.ParcelDistricts.District = "NORTHWEST" 
Then 
		  sBudgetNumber = "001-WU-NW-2017" 
Else 
		  sBudgetNumber = "001-WU-MISC-2017" 
End If