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