<< Click to Display Table of Contents >> Navigation: PaXcel - functions > GL Functions > GLRepBudgetHist() |
GLRepBudgetHist(Company, ReportCategory, Period, Year )
This function will return the historical budget balances using Pastel's Report Writer Category.
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.
RepCat: This is the category code as defined by you within Sage Pastel; it can be from 1 to 99.
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 GLRepBudget() function.
Examples:
Return the total budget of fixed assets for Year 3 to period 12
GLRepBudgetHist(C1, "B35", "Year to Date 12", 3 )
Return the total budget of fixed assets for Year 4 to period 5
GLFinBudget(C1, "B35", "Year to Date 5", 4)
Return the total budget for report writer category 1 for periods 1 to 2 for historical year 3
GLRepBudgetHist(C1, "1", "Year to Date 2", 3 )
Return the total budget for report writer category 15 for periods 1 to 6 for historical year 4
GLRepBudgetHist (C1, "15", "Year To Date 6", 4 ) |