Exact Globe+

Excel Add-in: explanation GL_TRANS function

Introduction

With the [GL_TRANS (acc_nr;co;curr_code;FY;period;calc)] function you can include the balance of all the transactions for a general ledger account 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 'GL_TRANS'.

G/L account
Select the general ledger account for which you want to retrieve the balance. Select multiple balances as follows: "8000: 8999". In this case, the balance of general ledger accounts 8000 through 8999 will be displayed.

Currency code
Enter the currency in which you would like the amount to be displayed (all transactions, regardless of currency code, will be included).

Financial year
Enter the financial year for which you want the amounts to be displayed. If you leave this field empty, the information for all the financial years will be included.

Period
Enter the period for which you would like the amounts to be displayed. If you leave this field empty, the information for all the periods will be included.

Calculation method
Indicate which calculation method should be used. You have the following options :

Example

GL_TRANS("0050";17;"EUR";2001;"12";1)

The balance for all the transactions entered in financial year 2001, period 12 for general ledger account 0050 for company 17 will be included in the worksheet. The amount will be displayed in the EUR currency.