| |
| gl_excel:linebudget [2010/06/21 14:43 UTC] – created mwolfe | gl_excel:linebudget [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 |
|---|
| 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. | 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. |
| |
| %InlineCode{LineBudget(UserRpt, LineCode, BudgetDate, //Company//)}% | **LineBudget(UserRpt, LineCode, BudgetDate, //Company//)** |
| |
| ==== Example Usage ==== | ==== Example Usage ==== |
| * %InlineCode{=LineBudget("BALCON", "A01", "7/31/2009")}% Returns the budget for line A01 of the BALCON user report for the month of July 2009. | * **=LineBudget("BALCON", "A01", "7/31/2009")** Returns the budget for line A01 of the BALCON user report for the month of July 2009. |
| * %InlineCode{=LineBudget("BALCON", "A01", "3/17/2009", "Cit")}% Returns the budget 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. | * **=LineBudget("BALCON", "A01", "3/17/2009", "Cit")** Returns the budget 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. |
| |
| ==== Required Parameters ==== | ==== Required Parameters ==== |