<< Click to Display Table of Contents >> Navigation: PaXcel - functions > GL Functions > GLHistBud() |
GLHistBud( Company, Account, Period, YearNo)
With the release of Pastel 2009 came the ability to report on historical balances
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
i.e Year to Date x (where x is the period).
YearNo: Pastel has 5 years of budget figures stored in the new table, however years 1 and 2 are actually kept with in the master table, to retrieve these you should use the GLBudget() function.
Return the budget for period 1 year 3
GLHistBud(C1, A9, "1", 3 )
Return the budget for period 1 year 4
GLHistBud(C1, A9, "1", 4)
Returns the Year to Date budget figure up to and including period 2 for year 3
GLHistBud(C1,A9, "Year to Date 2", 3 )
|