Introduction
With the [ACC_BAL_DATE (acc_nr;co;VWeekFrom;VWeekTo;balance_type;value)] function you can include the balance of a general ledger account, entered within an indicated date range, in the worksheet.
Explanation of the fields
CompanySelect 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
General ledger account Select the general ledger account for which you want the balance displayed. You can also enter the account number. To select multiple accounts, type in: 0050:3000. This will result in the display of the balance of accounts 0050 through 3000.
From date Select a date as of which you want retrieve the balance. Transactions prior to this date will not be included.
To date Select the date up to which you want to retrieve the balance. Transactions after this date will not be included.
Unprocessed You can retrieve unprocessed information. This means that information from unprocessed entries will also be displayed (after entry= 1; after posting= 0).
Value Indicate which value you want to have displayed. You have the following options:
RangeIf you put this setting on 'Date', entries for which the date falls within the range are included in the result. If you put this setting on 'Reporting date', entries for which the reporting date falls within the range will be included in the result.
Include closing entries if you check this setting, the result displayed will include closing entries.
Example
ACC_BAL_DATE(" 1300";001;"21/6/2001";"21/6/2002";1;3;1;1) The result displays the balance after entry of general ledger account 1300, in company 001, with entry date between 21 June 2001 and 21 June 2002, including closing entries.