One moment please...
 
 
Exact Financials (v3)   
 

CC_MAIN_CLASS

CC_MAIN_CLASS (main_class_cd,cc,co,FY,period,balance_type,value,calc,model)

Using this function you can include amounts of a cost center classification in the worksheet.

Note that a range of cost centers can be entered by separating the cost centers with a colon (:).

Example

CC_MAIN_CLASS(020,ADMI,621,2002,1,1,3,1,1)

As a result of the above function, the debit balance of the cost centers of main classification 020, financial year 2002 are included in the worksheet.

Parameters

Description Explanation Value
balance_type Amounts that are posted. 1
value The debit total. 1
The credit total. 2
The balance. 3
The total of values is only shown when it is positive (debit). 4
The total of values is only shown when it is negative (credit). 5
The quantity (entered on a cost center) is included. 6
calc Only the selected period is used. 1
The amount is the cumulative amount up to and including the selected period. 2
model This parameter should always be 1. 1


Excel Add-In contents | Alphabetical overview parameters

     
 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: 01.206.739
 Assortment:  Date: 11-03-2005
 Release:  Attachment:
 Disclaimer