GLRep(Company, ReportCategory, FromPeriod, ToPeriod, ThisYear )
This function will return the 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 Pastel Partner; it can be from 1 to 99.
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 effect 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 for report writer category 1 for periods 1 to 2 this year
GLRep (C1, "1", 1, 2, 1 )
Return the total for report writer category 15 for periods 4 to 6 for last year
GLRep (C1, "15", 4, 6, 0)
|