Excel Add-in: explanation function ACC_BAL_DATE
Introductie
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
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
'ACC_BAL_DATE'.
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:
- Debit (1):
the total of all the amounts that have been debited
- Credit
(2): the total of all the amounts that have been credited
- Balance (3):
the balance
of the debit total and the credit total
- Positive
(4): same as the balance, but only positive values are displayed
- Negative
(5): same as the balance, but only negative values are displayed
(as positive values)
- Quantity (6):
The quantity (as entered) is displayed
Range
If 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.
| Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
13.130.719 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |