Excel Add-in: explanation of the CRD_DATA function
Introductie
Introduction
With the [CRD_DATA (crd_nr;co;field)] function you can include specific information
about a company (the name of the contact person, for
example) in the worksheet. If you do not select a field,
the description will be displayed.
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 "CRD_DATA".
Creditor number
Select the creditor you want to
have displayed in the report.
Column
Select the
field you want to have displayed in the report. If you do
not make a selection, the description of the creditor will
be displayed.
Example
CRD_DATA("
1020";17;"cmp_name")
The name of creditor 1020 from
company 17 will be displayed on the worksheet.
| 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.155.338 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |