<< Click to Display Table of Contents >> Navigation: PaXcel - functions > GL Functions > GLFinBudget() |
GLFinBudget( Company, FinancialCategory, Period, BudgetType )
This function will return the budget balances using Pastel's Financial 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.
FinancialCategory: This is the financial category code as stored by Pastel
Code Description B05 Unallocated Balance Sheet B10 Share Capital B15 Retained Income B20 Shareholder's loans B25 Long term borrowings B30 Other long term liabilities B35 Fixed assets B40 Investments B45 Other fixed assets B50 Inventory B55 Accounts receivable |
Code Description B60 Bank B65 Other current assets B70 Accounts payable B75 Taxation B80 Other current liabilities I05 Unallocated Income Statement I10 Sales I15 Cost of Sales I20 Other Income I25 Expenses I30 Tax I35 Dividends |
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 total budget of fixed assets for this year to period 12
GLFinBudget(C1, "B35", "Year to Date 12", "C")
Return the total budget for fixed assets last year.
GLFinBudget(C1, "B35", "Last Year to Date 12", "L")
Return the total budget for sales for Last Year up to and including period 2
GLFinBudget(C1, "I10","Last Year to Date 2", "L" ) |