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.
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.
FunctionSelect 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.