With the CC_SUB_CLASS_DATE (sub_class_code;cc;co;VWeekFrom;VWeekTo;balance_type;value) function, you can include amounts for a cost center by sub-classification or series of sub-classifications within a particular date range in the worksheet.
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.
Select the function you want to use. In this case "CC_SUB_CLASS_DATE".
Select the sub-classification (Category 2), for which you want to see the balance. Select multiple sub-classifications as follows: 001:230. In this case the balance for sub-classification 001 through 230 will be displayed.
Select the cost center for which you want to see the balance. Select multiple cost units as follows: a:bzzzz. In this case the balance for all the cost units that begin with an 'A' or a 'B' will be displayed. If you leave the field empty, the balance for all the cost units will be included.
Select the date as of which you want the balance to be displayed. Transactions prior to this date will not be included.
Select the date through which you want the balance to be displayed. Transactions after this date will not be included.
You can retrieve information after entry. This means that information from unprocessed entries will also be displayed (unprocessed= 1; processed= 0).
Select which value you want to have displayed in the worksheet. You have the following options:
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.
This is where you indicate whether you want to include closing entries in the function.
CC_SUB_CLASS_DATE("001:230";"ADM";100;"1/1/2002";"31/1/2002";1;3;1;1)
Note: The balance 'after entry' for the 'ADM' cost center, sub-classification 001 through 230, entered in the entry date range January 1 through January 31, 2002, including closing entries for company 100 will be displayed on the worksheet.