gl_excel:linebudgetround

LineBudgetRound

This function returns the LineBudget in thousands. Its usage and parameters are the same as the LineBudget function, with the exception of the Company parameter*. The LineBudget function is called then the following calculations are performed on the result:

  • the value returned is rounded to the nearest thousand
  • then divided by one thousand
  • then the Budget User Report Adjustment is applied

LineBudgetRound(UserRpt, LineCode, BudgetDate)

%fineprint{*NOTE: The Company parameter is not supported for this function because it would require User Report Adjustments to be made on a company by company basis, which would add too much complexity to the process.}%

  • =LineBudgetRound("BALCON", "A01", "7/31/2009") Returns the budget in thousands for line A01 of the BALCON user report for the month of July 2009.
  • =LineBudgetRound("BALCON", "A01", "3/17/2009") Returns the budget in thousands for line A01 of the BALCON user report for the month of March 2009.

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}%

  • gl_excel/linebudgetround.txt
  • Last modified: 2023/07/24 14:33 UTC
  • by 127.0.0.1