Article Details
Id: | 12241 |
Product: | finPOWER Connect |
Type: | NEW |
Version: | 2.02.00 |
Opened: | 15/09/2014 |
Closed: | 16/09/2014 |
Released: | 29/09/2014 |
Job: | J014069 |
Documents; Loan Statement VBA; Updated to exclude Deposits
The Loan_Statement.dot sample VBA templates has been updated with the following changes:
- SQL for ad-hoc publishing (via Report Explorer) now excludes "Deposit" Accounts.
- Structure (including DocumentSave function) updated to match new Deposit_Statement.dot VBA.
Since this template now uses version 2 functionality, the version number has been updated to 2.00.
To update existing Statement VBAs to exclude Deposits when printing from ad-hoc SQL, the following line needs to be added when building the SQL Where clause:
' Exclude Deposits
.AppendComparisonInteger "Account.AccountClass", "<>", isefinAccountClass_Deposit