Tango News

News relating to Tango32 Loan Management System. For product information visit the Tango32 Product Page.

The latest version of Tango32 Download and the History of Changes.

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.




Tango32 Version 4.03 Released

LOANS

Fixes

  • Fixed intermittent error when importing loan transctions which cancelled the import when an error message was too long.
  • Fix bug which generated an incorrect regular direct debit amount after a loan had an interest rate change.
  • Fix precedence of global / business code settings for special charges when repairing schedule
  • Fix bug with ODI Calcs based on daily net balance when Interest is monthly nominal
  • Fix Receipt Alocation Report to handle From / To Dates which span more than one month
  • Fix out by one day error when calculating "Written Down Value" on assets
  • Modified "Principal and Interest Report" to correctly handly loans with interest free expiry dates


Enhancements

  • Loan Form:

New Transaction Summary Tab
New Credit Limit balances
Major performance improvamenents - form loads quicker.
Some data on the loan form is now calculated asynchronously, which prevents delays when displaying the form.

  • New facility to set up a direct debit which pays a loan by debiting an Investment / Creditor account
  • Added the ability to edit the "Security Types" system table via Setup / System Tables / Other System Tables / Security Types
  • New option to control whether or not a sublesdger is charged, based on the net balance of an account.
  • New ability to insert multiple related clients when importing from XML
  • New option on "Responsibilities" to specify that a contact should not receive any Correspondence
  • New ability to search for loans by: Responsibility, email, phone numbers
  • New ability to select which General Purpose field to search by.  Previously you could only search by "General Purpose 8".
  • The loans form now also shows Historical Arrears. This shows the arrears or advance position of the account for every month end since the account settled.
  • Limits and Drawdowns are now displayed on the Balance tab as well as Security tab
  • It's now possible to select "Redraw transactions" on Transaction audit report
  • New ability for special charges to generate credior transactions, and supply Creditor ID when posting transactions
  • Add phone number 5 to Client XML Import  
  • New option to export direct debit transactions in "PeopleHub" format


  • The Balance tab on the Loan form now shows

Total Payout figure
Net Balance + Outstanding ODI and Charges
Interest free balance when "interest free periods on drawdowns" is enabled


  • Setup/ Parameters

Configurable prompts for client phone numbers 1 to 4.
Option to enable interest free periods on drawdowns
Option to optionally prevent Lione of Credit accounts from being paid in advance
Configurable prompts for customer statement formats

  • Ability to specify Dr / Cr transactiion types on Subledgers, which controls the type of transactions generated in the Creditor system.


  • Business Codes:

Option to hide gross interest when displaying details of a loan.
Option to waive monthly interest lest than an specific amount.
Option to specify a global statement footer
Option to specify if Anniversary Day is based on Settlement or Instalment Date.
Option to create related investment account when creating new Loan.
Option to create a related sub account when creating a new loan account.
Option to add mandatory footer to Statements via business code
Option to allow an interest free period on debits applied to a loan.
Ability to charge interest every X days (instead of every X months)


  • New repayment calculation method for "Line of Credit" loans:

N/NULL = % of Net Balance
L      = % of Loan Limit
K      = % of Loan Credit Limit
C      = % of Client Credit Limit


  • New option on "Transction SubTypes" to specify months (as well as days) for period from drawdown to first repayment
  • New "Base Rate" for investments linked to loans.



INVESTMENTS

Fixes

  • Fix bug which created duplicate investor statements in some cases.



Enhancements

  • Ability to specify if an investment account can be used for management fees
  • Option to specify if an investment account can be used as a Funder.
  • Option to create a duplicate account when creating new investment via the wizard

Tango32 Version 4.02 Released

LOANS

Fixes

  • Fixed bug in drawdown module which created incorrect entries in the repayment schedule when the drawdown was supposed to extend the term of an existing loan.
  • Fix problem when variation is due on last day of 31 day month and loan settles on last day of 30 day month.  This was causing incorrect dates in the variation schedule.
  • Fix spelling error in Payway Credit Card export.
  • Fix "out by one day" error on smoothed interest in advance loans in their final month.  Previously the system was ignoring final (non-rv) interest amount and charging zero interest.
  • Fix inaccuracy with "C" type ODI not taking into account unaccrued interest.
  • Fix "Paid in full" report bug with wrong Unearned Income (UEI) figure showing when account had no UEI.
  • Fixed regular direct debit variation amount due on accounts where the nominated direct debit date was several days after the anniversary day, but before the last day of the month.
  • Fixed bug which didn't charge fee for chargeable form letters when the letter was open for editing, and the system unsuccessfully tried to delete it.


Enhancements

  • The summary on the Direct Debit Variation form now includes details of future direct debit variations.
  • New columns for Loan Templates: "Div 1 is number of Payments" and "Sub 2 is Multiplied bu Sub 1".
  • New option on Business Codes to hide the interest rate when printing statements.
  • Updated Customer Statement Form Security to include new controls.


INVESTMENTS

Fixes

  • Improved the Payout Quote and Rollover / Redemption Wizard to more accurately predict payout, interest and rollover amounts for accounts with & without ROI sub-accounts regardless of whether the new account started on the same or subsequent day as the payout.
  • Fixed Direct Credit Report which showed multiple lines for the same direct credit if an investment had multiple investors with multiple bank accounts.
  • Modified Investor Statement to exclude any interest payments / credit transactions where small amounts were rounded down to zero.
  • Fixed interest adjustment calculations on payouts to take into account the "High / Low" interest rates applicable on the account at the time.
  • Fixed formatting issue on "Opening Balance" in Investor Statements.


Enhancements

  • New option on Investment Business Codes to allow the generation of negative interest on accounts with negative balances.  This effectively allows a deposit to go into overdraft and be charged interest on the outstanding balance. 
  • When an investment is rolled over on a day for which interest has already been paid, this may generate an interest adjustment depending on the rollover settings.  If it does, this adjustment will affect the total value of any direct credits generated for interest payments on that account.



Tango32 V4.01 Released

LOANS

Fixes

  • fix string overflow error for direct debits with many conditions
  • Better error handling when Classification5 parameters are entered incorrectly
  • Fix interest calcs for Smoothed Interest Only loans in their first month
  • Fix "out-by-one" error on interest only offset days for non-smoothed IO loans
  • Fix balance error when repairing schedule
  • Fix direct debit variation problem with as at date prior to defer date
  • Fix direct debit variation problem where loan settles on last day of month and nominated date is on last day of short month
  • Fix bug with direct debit variation DD amount after interest rate change
  • Fix schedule generation on drawdowns which reactivate completed accounts
  • When deferring regular DD's, use the deferred amount, not the NEXT amount due
  • Fix inaccuracies in asset register (out by 1 day, including whole month, etc)



Enhancements

  • Add LoanLimitInterestOutstanding, LoanLimitPayoutQuote, SpecialChgFYApplied, SpecialChgFYOutstanding, SpecialChgFYPaid keywords
  • add BSP Direct Debit import file type
  • Improve error reporting when posting batches via XML
  • If a variation is created it will now be flagged to run concurrently with the schedule, so that if there is a payment due on the monthly interest run and a variation is created it stops the payment from being picked up on the month end dd processing.




INVESTMENTS

Fixes

  • Prevent creation of duplicate investment payment when interest is rolled into new investment
  • If account pays out on the TO DATE, and rollvers are dated as at the NEXT day, then balance will no longer include the payout if the Account Summary is run as at the Payout Date.
  • Ensure IP comes after IC on IV Statement



Enhancements

  • Add option to pay investment payouts via direct credit
  • Add "Rollover Interest" to Rollver Request table
  • Improve logic for testing when a completed account actually got paid out
  • Change sequence of clients on IV statements (Main, then others, secondary sort by clientnumber)


Tango32 V 4.00 Released

LOANS

Fixes

  • Fix problem with zero hold back accrual in first month when forcing even hold back accruals and account doesn't start on the first day of the month
  • Fix inaccuracy in "M" (Part Repayment) subledger calculation
  • Fix regular Direct Debit variation on IO loans
  • Fix Direct Debit Variation problem on variations prior to defer date
  • Fix double up of interest in Daily Interest Report for Interest In Advance accounts
  • Improved accuracy of "Change Schedule" function


Enhancements

  • Improve performance of monthly interest run
  • Improve performance when posting large batches of transactions
  • Add ABN (varchar(18)) and ACN (varchar(12)) to import XML
  • Allow Receipt Allocation Report to include non-chargeable accrual subledgers
  • New ability to exclude "DO NO SOLICIT" borrowers when printing bulk statements
  • More control over display of ABN, ACN, Credit License Number on statements.


INVESTMENTS

Fixes

  • Prevent negative entries being written to the investment payments table. This was happening when the rollover wizard paid out ROI accounts and the interest was withdrawn
  • Fix problem with incorrect amount written to payment table when non-roi account pays out using wizard and withdraws all interest and part principal
  • Fix inaccurate payout interest when rolling over an account that has already had interest paid up to the maturity date
  • Fix problem generating direct credits on accounts with Null payment type


Tango32 V3.99 Released

Loans

  • Fixed the misspelt form letter field "Gu7arantor2Address"
  • Fixed bug where expired direct debit variations cancelled direct debits based on the repayment schedule.


Investments

  • Modified "include active accounts" logic Account Summary Report to use the status of the account on the "As At Date" instead of the current date when working out whether an account should appear on the report.
  • Fix "out by one day" error when using the rollover wizard to roll over an investment into a new account when the  SetupInformation / RolloverOnSameDay flag is ticked.
  • Modified "Generate Direct Credits" option to handle Interest Withdrawals generated by the rollover wizard


Tango32 V3.98 Released

Loans

  • Fixed error "Could not find stored procedure" when trying to run direct debit for multiple days.
  • Fixed incorrect date of first Principal and Interest Payment for a hybrid loan where the first and last Interest-Only payments are due on the last day of the month, but the loan didn't settle on the last day of the month.

Tango32 V3.97 Released

Loans

  • New Direct Debit Variation facility to allow finer control over regular and one-off direct debits.
  • New Fields to record Credit Bureau scoring information against a loan at the time of settlement.
  • Fixed
    bug in Receipt Allocation Report which didn't pick up if an account had
    fees if that account had not been charged a penalty.  So accounts that
    had never been in arrears and weren't charged an overdue fee weren't
    showing account keeping fees on the report.
  • Modified Receipt Allocation Report to include non-chargeable up front subledgers if they're marked to be included on the report.
  • Fix rounding error on type 'C' ODI calcs
  • Improve accuracy of "depreciation per month" calculation for Prime Cost assets.
  • Fix rounding issues with asset disposals.
  • Improved performance of "Client" / "Search" screen when a client had more than one loan


Investments

  • New option for investments to set a "Low Rate" interest rate when an investment has a low balance
  • Modified Rollover / Reinvestment logic when rolling over so that Issue rate on sub accounts should be set to zero.
  • Fixed
    a bug in the form letter Printing wizard. While the number of letters
    to be printed seemed correct, the actual letters printed included a
    letter for the ROI sub account.  So for ROI accounts with sub accounts
    the wizard was printing two letters. For non ROI - sub accounts the
    wizard was only printing a single letter.  This caused the counters to
    be incorrect when sub accounts were involved.
  • Modified interest logic to not generate interest credits if accrual balance is negative.
  • Increase the lebngth of the "user" field in Diary Notes.
  • Fix performance issues with Generating Direct Credits for investors
  • Modified
    Rollover / Re-Investment logic to show interest payment separate from
    payout transaction.  Payout transactions on Investments now use the
    transaction description instead of just "Rollover".


General Ledger

  • Fixed bug which used incorrect Financial year start / end date was in some rare cases.


General

  • New facility to specify whether or not an ad-hoc query can be used as the data source for a form letter.