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 |