CC_BAL
CC_BAL (acc_nr,cc,co,FY,period,balance_type,value,calc)
By using this function, you can include the balance of a cost center balance sheet accounts in the worksheet.
Example
CC_BAL(3000,WAREHOUSE,100,2002,12,1,1,1)
As a result of the above function, the debit balance of the cost center 'WAREHOUSE' is included in the financial year 2002 and period 12, based on the amounts entered in general ledger account 3000.
Note that a range of cost centers can be entered by separating the cost centers with a colon (:).
Example
CC_BAL(3000,ADMI:DIR,100,2004,6,1,1)
Returns the debit balance of all cost centers between 'ADMI' and 'DIR' in financial year 2004, period 6, on g/l account '3000'.
See also:
[Alphabetical overview of parameters]
Excel Add-in Manual > Contents > Functions > CC_BAL
| 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.649 |
| Assortment: |
Exact Financials
|
Date: |
01-12-2008 |
| Release: |
|
Attachment: |
|
| Disclaimer |