Both sides previous revision Previous revision Next revision | Previous revision |
gl_excel:linebudgetround [2010/06/21 16:31 UTC] – removed reference to unavailable Company parameter mwolfe | gl_excel:linebudgetround [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 |
---|
* then the Budget User Report Adjustment is applied | * then the Budget User Report Adjustment is applied |
| |
%InlineCode{LineBudgetRound(UserRpt, LineCode, BudgetDate)}% | **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.}% | %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.}% |
| |
==== Example Usage ==== | ==== Example Usage ==== |
* %InlineCode{=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", "7/31/2009")** Returns the budget in thousands for line A01 of the BALCON user report for the month of July 2009. |
* %InlineCode{=LineBudgetRound("BALCON", "A01", "3/17/2009", "Cit")}% Returns the budget in thousands for the Citizens Savings Bank accounts in line A01 of the BALCON user report for the month of March 2009 (ie, it excludes all of the service company accounts). See below for more information about the Company parameter. | * **=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. |
| |
==== Required Parameters ==== | ==== Required Parameters ==== |
{{section>parameters#linecode}} | {{section>parameters#linecode}} |
{{section>parameters#budgetdate}} | {{section>parameters#budgetdate}} |
| |