One moment please...
 
 
Exact Financials (v3)   
 

CC_BAL

CC_BAL(acc_nr,cc,co,FY,period,balance_type,value,calc)

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'.


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