Excel Add-in: explanation function REV_GROUP_FY

Company
Select 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.

Function
Select the function you want to use. In this case  REV_GROUP_FY.

Assortment
Select the assortment you want to have displayed in the report.

Debtor number
Select the debtor you want to have displayed in the report.

Financial year
Select a financial year.

Representative
Select the representative you want to have displayed in the report .

Period
Select the period for which you what the amounts displayed in the report.

Type
Select the value for the information you want to have displayed. You have the following options:

Calculation method
Indicate which calculation method should be used. You have the following options :

• Period figures (1): Only figures from the selected period will be displayed, in the default currency.
• Cumulative (2): The cumulative amount, so all the transactions up to and including the selected period in the default currency.

Example

REV_GROUP_FY("109";5;1010;17;2001;12;1;1)

In the worksheet, the result displays the amount in items from item group '109' that representative 5 sold to debtor 101 in period 12 in company 17.