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