Excel Add-in: explanation function MAIN_CLASS_DATA

Introduction

With the [MAIN_CLASS_DATA (main_class_cd;co;field;model)] function you can include a classification in the worksheet. If you leave the field empty, 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 'MAIN_CLASS_DATA'.

Classification number
Select the classification for which you want the balance to be retrieved.

Column
Using the magnifying glass, select the column you want to have displayed on the worksheet.

Example

MAIN_CLASS_DATA("001";17;"oms40")
The description of classification 001 for company 17 will be displayed.