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.
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 '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:
Calculation method Indicate which calculation method should be used. You have the following options :
DateEntries up to and including the date entered here will be displayed in the result.
RangeEnter 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.