CC_MAIN_CLASS
CC_MAIN_CLASS
(main_class_cd,cc,co,FY,period,balance_type,value,calc,model)
By 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 |
See also:
[Alphabetical
overview of parameters]
Excel Add-in Manual >
Contents
>
Functions
> CC_MAIN_CLASS
| 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: |
18.314.657 |
| Assortment: |
Exact Financials
|
Date: |
01-12-2008 |
| Release: |
|
Attachment: |
|
| Disclaimer |