Excel Add-in: Explanation of function CC_DATA
Introduction
With the CC_DATA (CC_DATA (cc;co;field)) function, you can include information from a cost centre in the worksheet. If you do not select a field, the description will be displayed.
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 "CC_DATA".
Cost centre
Type or select the cost centre for which you want the information to be displayed.
Column
Type or select the column for which you want the information to be displayed.
Example
CC_DATA("ADMI";555;"oms25")
The description of cost centre ‘ADMI’ for company 555 will be displayed.
| Main Category: |
Attachments & notes |
Document Type: |
Support - On-line help |
| Category: |
|
Security level: |
All - 0 |
| Sub category: |
|
Document ID: |
13.136.375 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |