Excel Add-in: explanation of the CC_SUB_CLASS function
Introductie
Introduction
With the CC_SUB_CLASS (sub_class_code;cc;co;FY;period;balance_type;value;calc;reportdate) function,
you can include
amounts for a cost center by sub-classification or series of sub-classifications 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
'CC_SUB_CLASS'.
Sub-classifications
Select the sub-classification (Category 2), for which you want the balance
to be displayed. Select multiple sub-classifications as follows: 001:230. In this case
the balance for sub-classifications 001 through 230 will be displayed.
Cost center
Select the cost
center for which you want the balance to be displayed. Select multiple cost centers as
follows: a:bzzzz. In this case the balance for all the cost centers
that begin with an 'A' or a 'B' will be displayed. If you leave the field
empty, the balance for all cost centers will be included.
Financial year
Enter the financial year for which you want the amounts to be displayed. Only amounts that
have been entered in this financial year will be included.
Period
Enter the period
for which you want the amounts to be displayed. Only amounts that have been entered
on dates up to and inlcuding this period will be included.
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 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
Entries up to and including the date entered
here will be displayed in the result.
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
CC_SUB_CLASS("001:230";"ADM";100;2002;"12";1;3;2;"31/12/2002";2)
The cumulative balance 'after entry' for the cost
center 'ADM', sub-classification 001 through 230, through financial year 2002
and period 12 with reporting dates through 31 December 2002 for company 100 will
be included in the worksheet.
| 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.136.543 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |