Exact Globe+

Excel Add-in: Explanation of function CC_MAIN_CLASS_DATE

Introduction

With the CC_MAIN_CLASS_DATE (main_class_code;cc;co;VWeekFrom;VWeekTo;balance_type;value) function, you can include amounts for a cost center by classification or series of classifications, within a particular date range, in the worksheet.

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_MAIN_CLASS_DATE".

Classifications

Select the classification (Category 1), for which you want the balance to be displayed. Select multiple classifications as follows : 001:022. In this case, the balance of classifications 001 through 022 will be displayed.

Cost centers

Select the cost center for which you want to see the balance. 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 the cost centers will be included.

From date

Select the date as of which you want the balance to be retrieved. Transactions that occurred prior to this date will not be included.

To date

Select the date up to which you want the balance to be retrieved. Transactions that took place after this date will not 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

Range

Select the date or reporting date that 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

Include closing entries

This is where you indicate whether you want closing entries to be included in the function.

CC_MAIN_CLASS_DATE("001:022";"ADM";100;"1/1/2002";"31/1/2002";1;3;1;1)

The balance 'after entry' for the cost center 'ADM', classification 001 through 022, entered in entry date range January 1 through January 31, 2002, for company 100 will be displayed in the worksheet, including closing entries.