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
| 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: |
Exact Financials (v3)
|
Date: |
11-03-2005 |
| Release: |
|
Attachment: |
|
| Disclaimer |