<< Click to Display Table of Contents >> Navigation: PaXcel - functions > GL Functions > GLBudget() |
GLBudget( Company, Account, Period, BudgetType)
This function will retrieve the budget for the company, account, period and budget set required.
The arguments are as follows:
Company: This is the path to your Pastel directory. For example: c:\PastelData\_demo would enable you to retrieve information from the Pastel Partner demo company.
Account No: This is the Pastel GL account number that you wish to retrieve information for; for example this could be account no 1000000 which is the Sales account. It can also be a range of accounts as with GLBALANCE.
Period: This is either a number from 1 – 13 or a keyword combination for Year to Date
Year to Date x
Last Year to Date x
Future Year to Date x
(where x is the period).
Budget Set: Can be one of the following:
C – Current year budget
L – Last year budget
F – Future year budget
NB: If the Period keyword is of type "Year to Date" and your Budget Set code entered doesn't match the keyword type it will be altered. For example, if you request to display your 'Future' budget set and enter a period keyword of 'Year to Date x' instead of 'Future Year to Date x' then PaXcel will recognise this and internally change the keyword to 'Future Year to Date x'. This will ensure that the expected figures are returned.
Return the budget for period 1 current year.
GLBudget(C1, A9, "1", "C" )
Return the budget for period 1 last year.
GLBudget(C1, A9, "1", "L")
Return the budget for period 1 future year.
GLBudget(C1, A9, "1", "F")
Returns the Year to Date budget figure up to and including period 2
GLBudget(C1,A9, "Year to Date 2", "C")
Returns the Future Year to date budget figure up to and including period 2
GLBudget( C1, A9, "Future Year to Date 2", "F")
|