Excel Add-in: Explanation of function FILE_FIRST

Introduction

With this function [FILE_FIRST (file;co;index;column)], you can enter the key for a specific table in the worksheet. You can use this function with the functions FILE_NEXT and FILE_FIELD.

Fields

Company

Select the company for which you want to get the Exact data. If you select Default, the data will be taken from the default company. If you select a company, the data for 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. To select the key from the first record of a specific table, choose the function "FILE_FIRST".

Table

Select the table from which you want to get data, for example, "grtbk" for general ledger accounts or items for items.

Index

Select the index. Generally, the right index is equal to the table name.

Example

FILE_FIRST("btwtrs";001;"btwtrs")

The key of the first VAT-code in company 001 will be displayed.

Column

This field can be used to select the field from the table which you want to see. Most of the time, this field is left blank.

Keep in mind: When you define this field, No index value is returned but the content of this field from the database. In this case, the field in the cell in the Microsoft Excel worsksheet cannot be used as a parameter for the FILE_NEXT and FILE_FIRST functions. When you want to use the result of this function to retrieve the next index value, you should leave this field blank.

Example

FILE_FIRST("btwtrs";001;"btwtrs")

The key of the first VAT-code in company 001 will be displayed.

FILE_FIRST("btwtrs";001;"btwtrs";"landcode")

The value of the field "Landcode" from the first VAT-code in company 001 will be displayed.