GLFin( Company, FinancialCategory, FromPeriod, ToPeriod, ThisYear )
This function will return the 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 |
FromPeriod: This specifies the starting period of the period range. If you enter this as zero, then, for balance sheet categories, Pastel includes last year's balances. If you enter this as any other period number, Pastel will sum each period's values without taking last year's totals into account. For last year's balance sheet financial categories, or for income statement financial categories, entering zero here has the same affect as entering a value of one.
ToPeriod: This specifies the last period in the period range, and can be any value between one and the number of periods in the financial year.
YearNo: Enter 1 for this year's figure. Enter 0 for last year's figure.
Return the total of fixed assets for this year period 1 to 12 only.
GLFin(C1, "B35", 1, 12, 1)
Return the total of fixed assets including last year.
GLFin(C1, "B35", 1, 12, 0)
Return the total sales for periods 1 to 2 for last year.
GLFin(C1, "I10",1, 2, 0) |