With the REV_ITEM_FY function you can include revenue statistics per year per item and/or debtor in the worksheet. This function works in the same manner as the REV_ITEM function. For more information, see Excel Add-in: Explanation function REV_ITEM.
To use the REV_ITEM_FY function, launch Microsoft Excel, and then click Exact Globe: Function at the menu. Next, select REV_ITEM_FY at Function.
Select the administration from which you want to retrieve the Exact Globe Next data. If you select Default, the data will be taken from the default company. For more information, see Excel Add-In: Open or select a 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.
Select the function you want to use. In this case, REV_ITEM_FY.
Select the item you want to be displayed on the report.
Select the debtor you want to be displayed on the report. You can also select a range of debtors by using ":" to separate the debtors. To display the debtors from 1111 to 3086, type 1111:3086.
Select a financial year.
Select the period for which you want the amounts to be displayed.
Select the value for which you want information to be displayed. You can select the following options:
Indicate which calculation method should be used. You have the following options :
REV_ITEM_FY("AC1510";"1010";2001;17;"7";1;1)
In the worksheet, the result displays the amount for which item 'AC1510' has been sold to debtor 1010 in period 7 of 2001 in company 17 .