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


Tango32 Version 4.05 Released

NOTE - This version includes updates from version 4.04 which was not publicly released.

Version 4.05 18 March 2014

LOANS

Fixes

  • If an account settles on the last day of the month and direct debits are deferred, the date of the next direct debit was incorrectly moving to the last day of the month of the deferment.
  • In some situations Regular & Variation Direct Debits were being selected even if the due date was outside the specified date range.
  • Data was imported incorrectly from PeopleHub transaction files.
  • Incorrect entries dated prior to the settlement date were being added to the interest rate schedule.
  • Some accounts were not correctly being selected as having variation direct debits.
  • Accounts were showing an incorrect interest bearing balance when the account balance reduced below zero.
  • Improve accuracy of Net Balance Projection when repayments have charges on them.
  • Fixed incorrect GL Accounts on Journals when refinancing a loan.
  • Fixed Receipt Allocation Report to exclude only include fees that are specifically flagged to appear on the report.
  • Top Introducer Report now shows Classification Description instead of ID.
  • Fix missing "Security" and "Insurance" tabs on Loans form.

Enhancements

  • Cash flow Report now includes Direct Debit transactions
  • Improve speed / performance of Direct Debit processing.
  • New flag to specify that a Variation Direct Debit "has precedence".  If set, the variation will cancel any other transactions due while it is active.
  • Loan Wizard now lets you enter a desired repayment amount, in which case it will calculate the desired term.
  • Loan Wizard will adjust the final payment on loans where term varies according to repayment
  • The Principal and Interest Report will no longer force the net balance to zero when projecting balances for one account.  This makes it easier to see if the current repayment schedule will under-pay or over-pay the balance.
  • Loan transactions now record "Posted by user" and "Date Posted".
  • New facility to add 3-letter initials to deli employees which allows deli reports to generate entries in a task list for collection staff.
  • New facility for In-Full subledgers to be processed when they are added to active loans.
  • New Minimum and Maximum Value options for subledgers.
  • New ability to change the text prompt for "Postcode" when entering address information.
  • New ability to import / export direct debit and payment information via the PaymentHub web service.
  • Transaction Batch Report now shows current repayment frequency for any repayment-type transactions.
  • Display an informational message if the loan is paid by debits to a creditor account
  • Add GeneralPurpose 2, 3, 4, 5, 6 and Location & 2 to XML Import Interface 
  • The consolidated direct debit summary now allows  display of direct debit info for periods longer than a year
  • New "Pmt / Dishonor" button on the "Repayments" tab of the loan form shows a simple summary of repayments and dishonors
  • New
    "Consolidated DD Summary" button the "Repayments" tab of the loan form
    allows you to show consolidated direct debits for a loan.
  • New facilty to import dishonor information from "Peoplehub" system.
  • Added extra logging to show when the interest rate schedule is changed


INVESTMENTS

Enhancements

  • All IV transactions now have a "Paid By Transaction ID" which links them to the transaction which paid them.
  • New form letter keywords: BonusRateAddition, IssuePlusBonusRate, InterestFrequencyDescription
  • Payout Quote now shows interest accrued to last interest run date rather than to the payout date.


GENERAL

Enhancements

  • The daily "User Default Job" now allows "Schedule Fees" to be charged to accounts.
  • New API function to allow selection of "Correspondence Only" borrowers for reports.