Exact Globe+

Excel Add-in: Explanation of function CC_MAIN_CLASS

Introduction

With the CC_MAIN_CLASS (main_class_code;cc;co;FY;period;balance_type;value;calc;reportdate) function, you can include amounts for a cost centre by classification of series of classifications 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".

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 centre

Select the cost centre 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 centres 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

Financial year

Select 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

Type the period for which you want the amounts to be displayed. Only amounts that have been entered through the end of 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 will be included.

Range

If you select Date, entries with entry dates that fall within the date range will be included in the result. If you select Reporting date, entries with reporting dates that fall within the date range will be included in the result.

Example

CC_MAIN_CLASS("001:022";"ADM";100;2002;"12";1;3;2;"31/12/2002";2)

The cumulative balance 'after entry' for the cost center 'ADM', classifications 001 through 022, through financial year 2002 and period 12 with reporting dates through December 31, 2002, for company 100 will be included in the work sheet.