One moment please...
 
 
Exact Financials (v3)   
 

MAIN_CLASS_BAL

MAIN_CLASS_BAL (main_class_cd,co,FY,period,balance_type,value,calc,model)

Using this function you can retrieve the balance sheet amount of a main classification.

Example

MAIN_CLASS_BAL (001,100,2005,12,1,3,2,1)

As a result of the above function, the balance of the main classifications 001 is shown, of the actual amounts in period 12, financial year 2005, in company 100.

Parameters

Description Explanation Value
Balance_type Amounts that are posted. 1
Amounts updated after entry, but not yet posted. 2
Budget amounts. 4
Value The debit total. 1
The credit total. 2
The balance. 3
The total of values is only shown when it is positive. 4
The total of values is only shown when it is negative. 5
Calc Only numbers of the selected period are 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.856
 Assortment:  Date: 11-03-2005
 Release:  Attachment:
 Disclaimer