Excel Add-in: explanation of the CC_BAL function

Introduction

With the CC_BAL (acc_nr;cc;co;FY;period;balance_type;value;calc;reportdate) function you can include the balance sheet amount for a cost center by general ledger account in the worksheet.

Explanation of the fields

Company
Select the administration from which you want to retrieve the Exact data. If you select 'Default', the data will be taken from the default company. If you select a company, the data from the selected company will be displayed.

The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.

Function
Select the function you want to use. In this case 'CC_BAL'.

G/L account
Select the G/L account for which you want the balance to be displayed. You can also enter the account number. Select multiple general ledger accounts as follows: 0050:3000. In this case the balance of accounts 0050 through 3000 will be displayed.

Cost center
Select the cost center for which you want the balance to be displayed. Select multiple cost centers as follows: a:bzzzz. In this case the balance for all the cost centers that begin with an 'A' or a 'B' will be displayed. If you leave the field empty, the balance for all cost centers will be included.

Financial year
Enter the financial year for which  you want the amounts to be displayed.

Period
Enter the period for which you want the amounts to be displayed

Unprocessed
You can retrieve information after entry. This means that information from unprocessed entries will also be displayed (unprocessed= 1; processed= 0).

Value
Select which value you want to have displayed in the worksheet. You have the following options:

Calculation method
Indicate which calculation method should be used. You have the following options :

Report Date
All entries with a report date up to and including this date will be included. The report date is the date you can give every transaction upon closing a period via [Financial, VAT/Statistics, Close periods]. This field is only available if you use the Intercompany & Fiscal module (S1066).

Example

CC_BAL (3000;MAGAZIJN;100;2002;5;0;1;1;"31/5/2002",2)

The debit balance 'after entry' for the cost center 'Warehouse' in financial year 2002 and period 5 will be included, based on the amounts entered on general ledger account 3000 for company 100 with report dates through 31 May 2002.