ACC_BAL
ACC_BAL (acc_nr,co,FY,period,balance_type,value,calc)
Using this function you can enter the balance of an account into the worksheet.
Example
ACC_BAL(1300,621,2005,1,1,3,1)
This function calculates the period balance of debtor account 1300, in company 621, financial year 2005, posted in period 1.
Parameters
| balance_type |
posted amount |
1 |
| entered amount (use 'Update after entry data' to update) |
2 |
| budget amount (use 'Recalculate Finance budget'
to update) |
4 |
| value |
debit total |
1 |
| credit total |
2 |
| balance |
3 |
| calc |
only selected period used |
1 |
| cumulative amount up to and including selected period |
2 |
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.691 |
| Assortment: |
Exact Financials (v3)
|
Date: |
11-05-2005 |
| Release: |
|
Attachment: |
|
| Disclaimer |