Excel Add-in: explanation of the CU_DATA function

Introduction

With the CU_DATA function you can include information about a cost unit in the worksheet. If you don't select a field, the description will be included.

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 CU_DATA.

Cost unit
Enter the cost unit for which you want the information to be displayed.

Column
Ener the column for which you want the information to appear in the field.

Example:

CU_DATA("ACCE";555;"valcode")

The currency code for cost unit 'ACCE' for company 555 will be displayed.