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.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.

Tango32 Version 4.06 Released

LOANS

Fixes

  • Fix invalid repayment calculation method & inaccurate repayment calculations when processing drawdowns on Line-Of-Credit loans.
  • Fix incorrect "Joint Account Indicator" for Referee contacts.
  • Fix auto-increment on "Lot Numbers" when a loan has more than 10 securities.
  • Fix error in API which posted to incorrect GL accounts when debit transactions with charge codes were added via the API.
  • Fix incorrect security settings when an item is secured based on the "General Purpose 1" setting of the loan.


Enhancements

  • New "Export Log" tracks direct debit exports to help keep a record of which direct debit batches have been exported and processed, and to prevent duplicate exports.
  • Held Transaction Batches now show "Date Exported" in the list of batches.
  • New flexible "Arrears Buckets" allow finer control of the periods used for reporting arrears profiles on the arrears details screen.
  • New "Middle Name" field for clients.
  • New option for important diary reminders to display on a pop-up screen whenever a loan is opened.
  • New option to adjust arrears balance when it exceeds the net balance of the loan due to unusual interest charges or fees.
  • New "Funding Invitations" system to allow fund-raising for specific loans by inviting clients to invest.  Loans that are part of the invitation process now have a new status of "Invitation" until they are fully funded.
  • New option to make Business Codes available as part of the fund-raising process to send out invitations to invest.
  • New option on Interest-Only Business Codes with smoothed monthly repayments to either smooth or pro-rata the first interest-only payment based on the number of days between settlement and first payment date.
  • Add "60 day arrears amount" to form letters.
  • Add "ClientType" to API when adding new clients via the API.
  • New import / export interface with PaymentHub online payment processing system.
  • New export interface with Payway online payment processing system.
  • New import formats for "EZDebit" payment processing system.
  • New facility to automatically charge weekly / fortnightly / monthly account keeping fees via a scheduled SQL Job.



INVESTMENTS

Fixes

NONE

Enhancements

  • New "Suggested Funding Invitation Amount" for investors to be used when sending funding invitations to potential investors.
  • New "Classification 6" flexible field with lookup values for Investment Accounts.
  • New option to allow selection of Form Letter Recipients based on Series and Issue numbers.



GENERAL

Fixes

NONE

Enhancements

  • New interface to Amazon Web Services to allow secure Cloud-based backups of Tango databases, with a tracking system to monitor all backups currently in cloud storage.
  • New "Protected Schemas" facility allows you to name certain private schemas which will not be touched during Tango upgrades.  Any schemas not "Protected" will have its ownership changed to "dbo".