MAIN_CLASS_BAL
MAIN_CLASS_BAL (main_class_cd,co,FY,period,balance_type,value,calc,model)
By 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 |
See also:
[Alphabetical
overview of parameters]
Excel Add-in Manual >
Contents
>
Functions
> MAIN_CLASS_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.686 |
| Assortment: |
Exact Financials
|
Date: |
01-12-2008 |
| Release: |
|
Attachment: |
|
| Disclaimer |