Excel Add-in: explanation function ITEM_GROUP_DATA

Introduction

With this function ITEM_GROUP_DATA you can enter the field value of an item group in the worksheet.

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 'ITEM_GROUP_DATA'.

Item group
Select the item group you want to use.

Column
Select the field you want to use. If you don't make a choice, the description of the item group will be used in the worksheet..

Example

ITEM_GROUP_DATA("2",5,"groepnaam")
This function results in the the description (group name) for item group code 2 from company 5.