| Id: | 12947 |
| Product: | finPOWER Connect |
| Type: | NEW |
| Version: | 2.03.00 |
| Opened: | 13/01/2015 |
| Closed: | 15/06/2015 |
| Released: | 09/07/2015 |
| Job: | J014744 |
 High Importance |
|
Bank Transactions; added DateCleared
The BankTransaction and AccountTransaction tables now include a "DateCleared" column. This makes it easy to query the database to find the date a Transaction will be cleared at the Bank.
The Account form, Transactions grid now includes an optional column "Date Cleared".
Previously this date could be found only by using the Business Layer.
The following Business Layer functions have been updated:
1. The finAccountTransaction object has a new property DateCleared. This would normally be accessed via finAccount.Transactions(n).DateCleared
2. finBankTransactionView includes a new property DateCleared. The existing GetDateFundsCleared property has been obsoleted.
Warning. This date does not take into account when a Cheque is lodged. If you are not lodging a cheque the day it is dated/ entered into finPOWER Connect you should consider adding an additional period onto the days before cleared.
Note, to update existing transactions the conversion has to go through a special post conversion process. This is a second step after the database has been updated.