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
| 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: |
Exact Financials (v3)
|
Date: |
11-03-2005 |
| Release: |
|
Attachment: |
|
| Disclaimer |