Exact Globe+

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