Exact Globe+

Excel Add-in: Explanation of function FILE_NEXT

Introduction

With this function [FILE_NEXT (cell;file;co;index)], you can enter the next key (if you have a previous key by using the function FILE_FIRST) from a certain table in the worksheet. You can use this function with the functions FILE_FIRST  and FILE_FIELD. 

Fields

Company

Select the company for which you want to retrieve 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 next key (there must be a key created by FILE_FIELD or FILE_FIRST) choose the function "FILE_NEXT".

Cell

Select the previous key. If the previous key is in cell A2, then fill in ‘=A2’.

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.

FILE_NEXT(A2;"btwtrs";001;"btwtrs")

This function displays the key of the next VAT code – the first key is in cell A2 – from company 001.