One moment please...
 
 
Exact Globe+   
 

Excel Add-in: explanation function REV_DEBTOR

Introductie

Introduction

With the REV_DEBTOR function you can include revenue statistics per debtor and/or per representative in the worksheet. You can also do this with the REV_DEBTOR_FY function . The function works in the same way as REV_DEBTOR, except that with REV_DEBTOR_FY you can retrieve information per financial year.

 

Explanation of the fields

 

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_DEBTOR'.

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.

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:

  • Revenue (1)
  • Revenue PY (2)
  • Revenue quantity (3)
  • Revenue quantity previous year (4)
  • Revenue margin (5)
  • Revenue margin previous year (6)
  • Standard cost price (9)


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_DEBTOR("1010";5;17;"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 company 17.

 

 

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 13.159.657
 Assortment:  Date: 26-09-2022
 Release:  Attachment:
 Disclaimer