Article Details
Id:15612
Product:finPOWER Connect
Type:NEW
Version:3.01.08
Opened:08/09/2017
Closed:06/12/2018
Released:13/12/2018
Job: J019611
Breaking Change

Account Statement; new script functionality added to omit Transactions

A script can now hide Transactions from the Loan and Deposit Statements documents.

The following changes have been made:

  • A new property "ShowInStatement" has been added to finAccountTransaction.
    • This indicates whether the Transaction should be shown in the Statement.
    • It is not stored in the database, rather it is used by scripts to customise which Transactions are shown in a Statement.
  • finAccountStatementDetails
    • StatementTransactions.
      • Includes all Transactions linked to the Statement, previously items not shown were removed.
      • Are a list of finAccountTransaction, so updating the "ShowInStatement" hides the Transactions from the Statement
    • BalanceOpening, TotalCredit and TotalDebits now factor in this flag, i.e. if False the Transaction's value is not included in the Balance or Total.

Obviously you should be very careful when hiding Transactions on a Statement. You should only hide Transactions that balance to zero, otherwise the Closing Balance of a Statement may not equal the Opening Balance of the next Statement.

The example script below could be added into the Loan Statement Document script to exclude all Transactions with a User Flag of "X". Place the code at the top of the CreateDocument function.

Dim AccountTransaction As finAccountTransaction

For Each AccountTransaction In di.StatementDetails.StatementTransactions
  If AccountTransaction.UserFlag = "X" Then AccountTransaction.ShowInStatement = False
Next