Excel Add-in: Explanation of function SUB_CLASS_BAL
Introduction
With the [SUB_CLASS_BAL (sub_class_cd;co;FY;period;balance_type;value;calc;reportdate)] function you can retrieve the balance sheet amount for a sub-classification or a range of sub-classifications (category 2).
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 "SUB_CLASS_BAL".
Sub-classification number
Select the sub-classification (category 2) for which you want to retrieve the balance sheet amount. Select multiple sub-classifications as follows: 001:005. In this case, the balance of sub-classifications 001 through 005 will be displayed.
Financial year
Enter the financial year for which you want the balance sheet amount to be displayed.
Period
Enter the period for which you want the balance sheet amount to be displayed.
Unprocessed
You can retrieve information after entry. This means that information from unprocessed entries will also be displayed (unprocessed= 1; processed=0).
Value
Select which value you want to have displayed in the worksheet. You have the following options:
- Debit (1): the total of the amounts debited
- Credit (2): the total of the amounts 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 included
Calculation method
Indicate which calculation method should be used. You have the following options:
- Period figures (1): Only the figures from the selected period will be displayed, in the default currency
- Cumulative (2): The cumulative amount, so all the transactions up to and including the selected period in the default currency
Date
When the date field is filled in, only the entries with a (reporting) date less than or equal to this date will be included in the results of the function.
Range
Enter whether the date or the reporting date should be used when selecting the information. If this field is left empty, the value from the settings will be used. This setting concerns the date field described above.
Example
SUB_CLASS_BAL("001:003";17;2001;"8";1;3;2;"31/8/2001";2)
Note: The cumulative balance after entry of the sub-classifications 001 through 003 for the amounts realized in period 8 with reporting dates through August 31, 2001, financial year 2001 for company 17 will be displayed on the worksheet.
| Main Category: |
Attachments & notes |
Document Type: |
Support - On-line help |
| Category: |
|
Security level: |
All - 0 |
| Sub category: |
|
Document ID: |
13.153.498 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |