Exact Globe+

Excel Add-in: explanation function REV_ITEM

Introduction

With the REV_ITEM function you can include revenue statistics per item and per debtor in the worksheet. Note that you will get a separate cell for every debtor and for every item. You can also use the REV_ITEM_FY function for this purpose. Both functions work in the same way, but with the REV_ITEM_FY you can also retrieve information per financial year.

Explanation

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_ITEM .

Item code
Select the item that you want to have displayed in the report.

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

Period
Select the 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:

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 transactions up to and including the selected period in the default currency.
• Period figures in secondary currency (3): Only figures from the selected period are displayed, in the secondary currency
• Cumulative in secondary currency (4): The cumulative amount, so all transactions up to and including the selected period in the secondary currency.

Example

REV_ITEM("AC1510";"1010";17;"7";1;1)

In the worksheet, the result displays the amount of item 'AC1510' that was sold to debtor 1010 in period 7 in company 17.

Note: It is easy to put this data in an easy-to-read table, by (using the FILE_FIRST and FILE_NEXT functions) putting all the debtors in the first column and all the time codes in the first row, so that you get a matrix. All the cells in the table now correspond to a specific debtor and a specific item.

Example: the first debtor is in cell A2 and the first item is in cell B1. Enter this function in cell B2 and put =B$1 after the item code and =$A2 after the debtor number. You fill in the remaining information as you require. Then copy this cell to all the remaining cells in the table. Note that there is an '=' sign in front of it and that there is a dollar sign at the beginning of the row in which the items are filled in and at the beginning of the column in which the debtors are filled in. This is important for copying to other cells.