Expert1 News

News relating to Expert1's Products and Services

For more information on our Loan Origination and Management products visit our Product Page.

For updates and product downloads visit our Support Files Page.

Tango32 V4.11 Released

19 May 2015

LOANS

Fixes

  • Fix calculation of next due date when account is in advance and arrears have been set to calculate from the as at date rather than the day after.
  • P & I Report should ignore "Disable Arrears" settings
  • (Tango / Tan-40) Monthly Chargeable subledgers were appearing in PI report twice
  •  Fix NULL value when exporting loan payments to creditors
  • When reversing a payout, clear disposal settings on any assets disposed as part of the original payout
  • Loan Direct debits now checks creditor available funds if paying via Creditor
  • Fix problem where rate change causes new direct debit amount to appear one month early for variations
  • Fix bug which un-smoothed repayment amounts during rate change on IO loans with smoothed repayments
  • Fix first payment amount for interest in advance loans with common anniversary day
  • Rate change on interest only in advance was starting one day too late in schedule
  • Fix incorrect calculation of unallocated Principal, Interest and Charges on the receipt allocation report.
  • Fix Formatted Postal Address in Form Letters
  • Fix Drawdowns and Credits so that they generate interest adjustments when entered prior to last interest run date
  • Fix criteria for a repayment appearing in schedule as being "Inertia" related
  • Fix incorrect minimum dd amount on variation screen
  • Fix "value too large for integer" error for subledgers with results larger than about 275,000 that require rounding.
  • Removing a subledger that affects repayment amounts from an active loan will now reduce repayment amounts on that loan.
  • Fix selection logic which incorrectly excluded accounts which started after the FROM date of the VEDA report.
  • Fix Set Focus error when trying to display consolidated DD summary
  • Consumer Credit Payout Quote - fix Insurance Rebate issues when run via Access 2012.


Mods

  • Add a second "related creditor" link to Business Codes.
  • Add suffixes for automatically generated Sub-Accounts, Related Accounts, and Related Creditors.
  • New direct debit interface for ACH (USA)
  • The system log now records each time direct debits are generated.
  • Added "Classification 7" to Clients.
  • Added "Classification 8" to Investment Accounts.
  • When generating correspondence, override the "No Correspondence" flag for Principal Borrowers, who should always be contacted.
  • New option for leases to to deduct arrears from finance-based payouts
  • Add account range to ACRA / VEDA export for testing purposes
  • New "Interim" and "Ongoing" direct debit variation facility.
  • (Tango / TAN-12) Add Clustered Index to FM_DirectDebitVariations on LoanAccountNumber
  • (Tango / TAN-13) Add extra fields to fm_directdebitvariations: WhoEntered, DateEntered, WhoUpdated, DateUpdated
  • (Tango / TAN-5) Add "Annual Fee" and "ongoing amount" to Regular DD


INVESTMENTS

Fixes

  • Improve the selection criteria which determines whether an investor should be included in an Invitation to Invest.
  • Fix duplicate Investment Payments when there were multiple 'IO' transaction types defined for different business codes
  • Fix null investor client name appearing when no individual contact is entered for the client
  • Fix selection criteria on Cheques and Remittances report


Mods

  • Add a new "Unallocated Funds Holding Account" for investments that are linked to loans.
  • "Investment Swap" facility which allows you to swap in/out investors to an investment-funded mortgage.
  • (Tango / TAN-38) Projected Interest report for Linked Investors no includes Pro rata adjustments for swapped in / out investors.
  • Add Remittances and Cheques to Processing Menu


Tango32 V4.10 Released

Changes to Tango32.

Version 4.10 6 March 2015

LOANS

Fixes

  • "Create Multiple Form letters" - Only exclude an account if all borrowers have "Do Not Solicit" =1.  Previously skipped if only one borrower had "Do Not Solicit"=1.  Also improved performance.
  • Fix error posting transaction via xml: "Error converting data type nvarchar to int."
  • Fix BSB formatting error for  EzDebit export.
  • Enforce unique Account# in FM_Loans
  • Internal API Function GetCSTransactionInfo - now handle nulls properly.
  • Internal API Function GetClientLoanAddress - Fix client long loan address problem with multiple accounts
  • In VEDA / ARCA Credit reporting: Fix DefaultStatusType, fix From / To Date Range to be no more than 24 months, exclude invalid drivers licence.
  • Fix repayment calc when Creating a schedule for a new loan which has a Deferred Interest Date on a Pro-rata Interest-Only loan.
  • Fix arrears days calculations when you don't keep arrears balance / days after maturity
  • Prevent PaidByTransactionID from being set when transactions are posted after payment has been generated but not posted.
  • Right-Align "Available" on frmClients Loans tab.
  • Fix formatting of header labels on User#3 customer statement
  • Fix logo alignment on User3 customer statement
  • Fix alignment of signature message on final page of customer statements
  • Fix page numbering on User#2 and User#3 customer statements when printing for bulk accounts.


Mods

  • Add the ability to specify a default statement format whenever a customer statement is printed.
  • Add a new flag to the "Responsibilities" system table to specify which account holders should be included in a credit agency report.
  • New option to specify if a borrower should receive statements via email (note this option only applies for the Tango online system)
  • New "Drivers License Number" column for borrowers which removes the need to enter it via the "Identification Information" tab.
  • New option to include inertia related subledgers on new Inertia Allocation Report
  • New option to exclude business code from interest run
  • Processing a new loan will now always process sub-account as well.
  • Improve indexes on Loans table to speed up processing.
  • Discounted Present Value Payout Quotes now include penalty fees.
  • New option to Print Direct Debit Schedule
  • "Projected maturity date" on loans form is now calculated asynchronously to speed up the user interface.
  • Signature message appears on every customer statement page and calculates keywords.


INVESTMENTS

Fixes

  • Internal API Function GetClientsOfAccountTable - Fix "String or Binary Data Would Be Truncated" error
  • Fix management fee calculations
  • Loan Investment form:  Fix error after tabbing out of Process As At Date.
  • Loan Investment form:  Fix "nothing happens" error when clicking on save or process for a loan with a second invitation.


Mods

  • New ability on investment business codes to specify a naming convention when naming new accounts which might be created automatically by the system (sub accounts, reinvestment accounts, etc)
  • New options to specify "Cleared Funds" or "Clearing Days" on investment transactions.  The option is set in the Transaction Types table.
  • New option to enforce PIN number before allowing Process of New Investment Invitations.
  • "Process invitations" now requires "As At" Date
  • New Projected Investment Income Report.
  • Show account name in loan -> investment funding details dropdown
  • Improve presentation of loan details when click "Invitations" button on Investor form
  • Invitations - allow search by Account# in dropdown list for new investors
  • Loan Investment form:  Add date picker to Process As At Date


GENERAL

Mods

  • Allow searching Clients using "%" wildcard.
  • New Email Templates Table


Tango32 V4.09 Released

Version 4.09 12 December 2014

LOANS

Fixes

  • Payout Quote should use AsAtDate when calculating "At Completion" subledgers
  • Don't smooth out schedule in IO loans imported via XML
  • Fix Veda XML Export
  • Payment hub - fix incorrect payment reference when using non-consoidated batches
  • Fix incorrect schedule generated when posting initial drawdown to zero balance LOC account when drawdown is set to extend term
  • RepairSchedule now recreates schedule properly on LOC accounts
  • Fix error in projected maturity date
  • Improve report sequence on Transaction Audit Report


Mods

  • Add void status to Transaction Audit Report
  • EzDebit API Mods
  • External Source ID (API)
  • Refresh loan form after saving
  • Disable mouse scroll wheel in loans form
  • Prevent mouse scroll on clients form
  • Rearrange Borrowers tab on Loans form to show User Field 6


INVESTMENTS

Mods

  • Disable mouse scroll in Investment Account Form


GENERAL

  • Improve usage of Clustered Indexes

Tango32 Version 4.08 Released

LOANS

Fixes

  • When displaying Borrower Names on most reports, only include those borrowers who receive correspondence. (E.g. Loan Activity Report)
  • Fix infinite loop in some situations when adjusting a repayment schedule.
  • Fix bug which omitted middle name while importing from XML
  • Fix # of payments in arrears & days in arrears when arrears calculated from day after due date.
  • Fix Ezy Debit import errors
  • fix error in "Minimum Amount Due" for regular direct debits affected by interest rate change
  • fix spurious entry in interest rates table when posting drawdowns
  • Fix Line of Credit Repayment Amounts when account isn't allowed to go into advance
  • If a batch is exported more than once, don't show it twice in the list of batches
  • Fix inaccurate repayment calc for P&I payments on Hybrid Loans during a rate change
  • Fix Next Payment Date / Amount when amount due is less than Delinquency threshold
  • fix truncated reference and comma on the end of narrative in "User 2" transaction import
  • Fix Null InterestType error when duplicating some investment accounts.
  • Balance projections will treat ODI & special charges like interest when they behave like debits. This is to ensure the balances match with the P&I Report and behave consistently when interest rates change
  • Fix error on P&I Report: Drawdowns in same batch as payment should not be treated as "Charges Due" debits generated automtically by subledgers.  The only debits that would behave like this would be stuff like GST, or fees related to payments.
  • fix incorrect display of null "total financed" field on form letters and payout quote
  • Current Month Calls Report now uses "Days In Arrears", instead of  "Next Due Date"
  • Fix Arrears Days "Out By One" error in Deli Reports.
  • fix incorrect journal when exporting loan transaction batch to creditor
  • Exclude zero value void transactions from Transaction Audit.
  • Fix "Type Mismatch Error" when saving a security to a loan with null checkboxes
  • Fix PK error when trying to duplicate blank securities on a loan.
  • Fix error when double-click on white-space in transaction batch list form
  • Fix incorrect calculation of first Interest-Only repayment when "Pro-Rata" is enabled and posting first drawdown to account which previously had a zero balance.
  • Fix rounding issue when refinancing loans


Enhancements

INERTIA TRANSACTIONS.
New facility to specify subledgers to be used when generating transactions at the start of the inertia period of a loan and for subsequent months during the inertia period.
New "intended termination date" for inertia period.
New "Inertia Only" subledgers which only activate when repayments are posted to an account in inertia.
Show " i " next to transactions that are inertia payments in Transaction Entry and Transaction Batch Report

PHONE NUMBER MASKS.
New facility to specify input masks for phone numbers.

TRANSACTION SUB TYPES. 
New option to disable a transaction sub-type

ARREARS CALCULATIONS.
New option to exclude penalty fees when calculating the number of days in arrears and arrears balance.

TRANSACTION BATCH REPORT. 
Added two additional  formats for reporting transactions in a batch.

VEDA / ARCA REPORTING.
New positive credit reporting interface for Veda Australia.

CUSTOMER STATEMENTS.
New option to create diary note when producing a customer statement (never, always or prompt)

DIRECT DEBITS.
New option to prevent variation direct debits from being summarized.
New option to import direct debit variations info via XML when creating a new loan.
New "Projected Maturity Date" is displayed on a loan based on Direct Debit Schedule
New direct debit export format for RBA Canada.
New direct debit dishonor import format for RBA Canada.
New direct debit export format for eSelect Plus Credit Cards (Canada)
New direct debit dishonor import format for eSelect Plus Credit Cards (Canada)

SUBLEDGERS.
New option to "always round down".

ACCOUNT REASSIGNMENT.
New option to "Flip" or "Reassign" an active loan from one Business Code and Subledger group to another.

DIARY REMINDERS. 
New option to prompt user for a comment after viewing a loan account.

INTEREST RATES.
New option to specify date after which to to Change Repayments when changing interest rates.
Any changes to the interest rate on a businsess code is now logged.

LOAN CLASSIFICATIONS.
Changes to these fields are now logged.
Add account description column to Creditor dropdown on Classification 2 & 3
The Loan wizard can get creditor from Classification2 just like it does for Classification 3

ARREARS.
New "Allocation" button on Loan Form shows allocation of payments received against repayment schedule and penalties.

REPORTS.
P & I Report has new option to use Scheduled Payments & Historic Interest when doing a projection.
Add "Date Posted" column on payment / dishonor summary report

LOAN FORM
 Show firstname + surname in title bar, not surname + firstname
 Add "Total Repayments" to Loans Tab on Client Form
 
INVESTMENTS

Fixes

INVITATIONS.
Disable processing Investment Invitations if insufficient funds

SUB ACCOUNTS.
Fix transaction type error when moving Interest Accruals between account and sub account
Posting IV credits to sub accounts now creates Payment (and IV_InvestmentPayment) where appropriate

PROCESS INTEREST. 
Business Codes on "Process Monthly Interest" form should show - even if they have zero interest rates.

Enhancements
INVESTMENT PAYMENTS.
New option to prevent a specific investment payment from being exported for direct credit.

GENERAL

Enhancements
LOGIN.
New server drop-down box when logging in.

CLOUD STORAGE. 
New options to compression backups before uploading to cloud storage.

Tango32 Version 4.07 Released

LOANS

Fixes

  • Fixed: When posting repayments, system was not ignoring cancelled subledgers related to payments.
  • Fixed Loan Activity Report - "User1" format had "Invalid Column" in "Group By" clause.
  • Fixed Principal & Interest Report which showed incorrect interest date for daily compouding loans
  • Fixed "Loan / Transaction Entry" to automaticalyl update list of batches after entering a new batch of transactions.
  • Fixed error when trying to delete a client with no related loans: "Either BOF or EOF is True, or the current record has been deleted?"


Enhancements

  • New method for importing repayments from PaymentHub
  • Improved layout of Transaction Batch Report
  • New ability to specify the number of BPAY check digits for Westpac "Recall" BPAY import format for direct debits.