Introduction
With the REV_DEBTOR_FY function you can include revenue statistics per year, per debtor and/or per representative in the worksheet. This function is the same as the REV_DEBTOR function, except that with the REV_DEBTOR_FY function you can retrieve information per financial year.
Explanation of the fields
CompanySelect the administration from which you want to retrieve the Exact data. If you select 'Default', the data will be taken from the default company. If you select a company, the data from the selected company will be displayed.
The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.
FunctionSelect the function you want to use. In this case
Debtor number Select the debtor you want to have displayed in the report.
Representative Select the representative you want to have displayed in the report.
Financial year Select a financial year.
Period Select a period for which you want the amounts displayed in the report.
Type Select the value for the information you want to have displayed. You have the following options:
Example
REV_DEBTOR_FY("1010";5;17;2001;"6";1;2)
The result displayed in the worksheet is the amount that representative 5 sold to debtor 1010 up to and including period 6 in financial year 2001 in company 17.