Both sides previous revision Previous revision Next revision | Previous revision |
gl_excel:linebudgetround [2010/06/21 16:32 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 line A01 of the BALCON user report for the month of March 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. |
| |
==== Required Parameters ==== | ==== Required Parameters ==== |
{{section>parameters#linecode}} | {{section>parameters#linecode}} |
{{section>parameters#budgetdate}} | {{section>parameters#budgetdate}} |
| |