Excel Add-in: explanation function REV_DEBTOR_FY
Introductie
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
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_FY'.
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:
- 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_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.
| 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.685 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |