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 3.88 Released


  • New bank transaction import format "PayWay".
  • New fields on Loan form show projected net balance inclusive and exclusive of current months interest.
  • New options on Business code to calculate new repayment amounts after drawdowns and rate variations based on Projected Net Balance Inclusive and Exclusive of current month interest.
  • The Loan Summary Report now has an option to include both ODI and Special charges on the report.
  • Fixed bug in Transaction Audit Report which mistakenly included reversals of special charges in the "Reversals" section instead of the "Special Charges" section.

Tango32 Version 3.87 Released

Sumary of changes:The "Original Term" of a loan is now recorded for historical purposes.New option to add the "Days of Grace" when working out the arrears balance in ODI calculations.New "Discharge Date" and "Discharge Amount" on Loan Securities.Loan LVR calculations now include "Scheduled" LVR which is based on the scheduled (as opposed to current / net) balance of the loan.New logic to allow the calculation for new repayment amounts to be based on the Scheduled (as opposed to current / net) balance when drawing down additional funds from a loan.New function to update the diary reminders when a drawdown affects the repayment amount of a loan.Fixed bug with Loans that move into Inertia which created multiple schedule entries the first time the account moved into inertia.Fixed bug where subledgers that were supposed to be charged in advance were not being charged when a loan activated.New option in Setup / Parameters which forces recreation of "chg" entries from Special Charges when repairing accounts.Fixed bug which incorrectly allocated payments against special charges when the account was past its maturity date.Tightened data validation to ensure an interest rate change date does not occur prior to a "Defer Interest Until" date for deferred interest accounts.

Version 3.86 Released


  • New facility to exclude special charges when generating direct debits.  To enable this, go into Setup / Business Codes, and tick the box "Direct Debits Exclude Special Charges".  If this option is set at the business code level, it can be disabled for individual loans on the repayment schedule screen by ticking the box "Direct Debits include special charges".
  • New facility to exclude Residual Values from inertia processing.  To enable this, go into Setup / Business Codes and tick the box "Exclude RV from Inertia".  You can also set an option which will only let Payout Transactions be allocated against the Residual Value in the repayment schedule.  Normal payments will then not be allocated to the RV.  To enable this option tick the box "Only allocate Payouts to RV".
  • New facility in subledgers to charge a subledger in advance.  To enable this, go into Setup / Subledgers and tick the box "Charge In ADvance".  When ticked, any monthly subledgers will be charged when a loan activates, and then on the day following an end of month interest run.
  • There is now a new report format "11" for the Delinquency System.
  • Drawdowns - fixed bug which reactivated loans incorrectly when a drawdown was posted to the account.
  • ODI - fixed bug which calculated incorrect ODI amount when the system was set to calculate arrears from the day after the due date.
  • Arrears Calculations - fixed bug which incorrectly included fee payments in advance twice when the account was paid in advance.
  • Current / Non-Current Report - fixed bug which showed incorrect calculations when the net balance exceeded the gross balance.
  • Principal and Interest Report - fixed bug which showed incorrect balances for an account with drawdowns.
  • New fields "Risk Grade" and "Risk Rating" are now available on the Clients form.
  • A new optional request / complaint handling module is available which links into the Diary Information on a loan.
  • Introducer Analysis Report - when subtotalling by Classification, now shows Classification Description instead of Classification ID.
  • Insurance Premium Renewal Report now shows individual loan securities rather than one entry per loan.  It also shows Title Reference instead of Security Description.
  • Variable Rate Loans have a new repayment calculation method.  When the interest rate changes, the new repayment can optionally be calculated based on the Scheduled (instead of Actual) net balance.
  • Hybrid and Interest Only Loans now show the interest only expiry date.  This date can be used as the selection criteria for creating bulk form letters.
  • Customer Statements now have a new option to only consolidate payments and special charge payments generated from the same transaction - which effectively hides the splitting of repayments against special charges on the statement.
  • Special Charges - Fixed bug when allocating "Current Month" due amounts before fee balances.  Previosuly if the account was due on the first day of the month, the system would mistakenly allocate Next Month as well.
  • Interest Calculations for Anniversary Day Accounts.  Fixed calculation error on anniversary day accounts when the due date in the month occurred on a day that didn't exist in the previous month (e.g. calculating interest on 30 March when interest last month was calculated on 27 Feb).
  • Loan Securities now show a "Scheduled LVR" as well as "Original" and "Current".

Investments / Other Accounts

  • New option in Transaction Types to specify whether a particular transaction includes GST for use on RCT Invoices.

Version 3.85 released (26 Oct 2010)

The security log will now be updated if someone changes the "Hold Processing" status of a loan.
Fixed a bug which caused monthly fees to be charged on accounts that had a settlement date after the date of the interest run.
New import format for CBA "Direct Entry Dishonnor" (MA23) format files.
Improved the narrative on interest payments to linked mortgagees.When entering a loan via the wizard, if you switch from an Interest-Only to a non-Interest-Only business code, the system will ask if you want to zero out the "Residual / Balloon" field.  Previously this field was left untouched which sometimes caused data entry errors when users didn't realize that a value was still in that field.

    Version 3.84 Released (19 Oct 2010)

  • Loans - Interest In Advance
  • If a business code is configured to have "Interest In Advance" loans, the interest cycle logic has been changed so that the cycle starts on the due date for the current repayment, and ends on the day prior to the due date for the next repayment.Fixed inaccuracies when interest in advance was charged on a common day.

  • Loans - Variable Rate
  • There are new form letter fields to record the details of the most recent interest rate change, to assist in creating correspondence about interest rate changes:

    • RateChangeDateEntered - The date the rate change was entered into the system
    • RateChangeOldRepayment - The repayment amount before the new rate was applied
    • RateChangeOldRate - The interest rate before the new rate was applied.
    • RateChangeNewRateDate - The date the new rate applies from.
    • RateChangeNewRate - The new interest rate
    • RateChangeNewRepayment - The repayment amount after the new rate is applied.
    • RateChangeNewRepaymentDate - - The date the next repayment amount is due

    When varying the rate on a loan there is a new option on the business code to specify the number of days that must transpire after the rate change before repayment amounts due should be adjusted. There is now a facility to print form letters for a group of loans based on the date that their interest rate was changed.

  • Loans - Projected Balance
  • The "Balance" tab of the loans form now also shows the "Projected Balance" of the loan which is the balance it would have if loan repayments were made as contracted. Fixed infinite loop when projecting the net balance on interest in arrears loans that were charged interest on the anniversary day instead of the last day of the month. * Loans - Principal and Interest Report This report has been enhaced to include drawdowns.

  • Loans - Extending Direct Debits
  • Business codes have an option to "Continue direct debits on maturiing loans when they are in arrears". This option has been fixed to use a more reliable repayment amount and frequency for the continuation.  Previously an incorrect repayment amount would be used in some situations.

  • Loan Summary Report
  • Fixed bug which doubled up outstanding fees on loan summary report when the system was configured to treat special charges and ODI like debits.

  • Manual interest
  • When manual interest is posted to an "Interest In Advance" account, this will no longer affect any subsequent interest calculations provided the manual interest transaction is prior to the next due date.

  • Investments
  • Fixed bug which incorrectly added one day to the start date of an investment when it was rolled into a new investment at maturity. Improved consistency of transaction Narratives when rolling over an investment. New facility to calculate commissions on investments based on an interest rate margin.

  • Linked Mortgages
  • Any ODI charged on a linked mortgage can now be included in payments made to investors. New facility to specify that funds are on a linked mortgage "cleared" when entered into the system to prevent the subsequent "clearing days" delay that normally applies before investors are paid.

  • Joint Account Indicators
  • Fixed bug in the Experian "Joint Account Indicator" which incorrectly marked both borrowers as the "first borrower" in some cases.  Added a new GetJointAccountIndicator() function to more reliably retrieve the indicator value.

  • Overdue Interest
  • Fix overstating of ODI when a dishonor is entered on the first day of the month and arrears is set to calculate from the day after the due date, when ODI is calculated using daily arrears balance.

    Version 3.83 Released (05 Aug 2010)

    • Loans
      • There is an option to allow loans to have interest charged to the account on the anniversary day of the loan rather than the last day of the month.  This version ensures that interest charges will be charged on the correct day for interest-in-advance loans.
      • New subledger option for subledgers that are charged when a loan completes to only charge the subledger for writeoff transactions instead of for all loan-completion transactions such as payouts.
      • Minor adjustment to the layout of the credit card export data for "Secure Pay"
      • Fix bug with the anniversary day flag when creating new payments due after a drawdown.
      • There is now a new "Line of Credit" caclculation method which allows you to set a "Minimum repayment amount" and a "Percentage of balance" which must be repaid each month.
      • Fix bug which charged extra interest on a loan with "simple interest" calculation methods, when the loan was paid out n the dat that interest was due to be paid.
      • Loan Data-Entry Templates now have a "Data Source" which allows you to specify where a value can be copied from to save the user having to enter it into a template.  
      • When using the API to insert drawdown transactions, the system will use the default transaction-subtype if it is enabled for a particular subtype.
      • When processing an interest run at the end of the month, the system will also process any loans that were supposed to be charged interest on their anniversary day, if that day occured prior to the end of the month, and interest had not yet been charged.
      • Fixed bug which set incorrect repayment frequency when extending repayment variations at the end of term of loans which were still in arrears.
      • Fixed bug with Principal / Interest report with arithmetic overflow error when projecting future balances on accounts with large gaps in repayment schedule.
      • Fixed bug with displaying and allowing changes to classification codes on the loan form.
    • Investments
      • Fixed bug which occasionally set the wrong balance of an investment when it was rolled over into an existing account.

    Version 3.82 Released(04 Aug 2010)

    Loans Fixed the "Invalid use of Null" error when displaying the repayment tab of a loan. Consumer Credit Payout Quotes now include subledgers charged at the completion of a loan. All payout quotes will ignore subledgers charged at completion of the Start / Stop month settings prevent that subledger being charged.

    Version 3.81 Released(03 Aug 2010)

    Loans Fixed the "Invalid use of Null" error when displaying the repayment tab of a loan. Consumer Credit Payout Quotes now include subledgers charged at the completion of a loan. All payout quotes will ignore subledgers charged at completion of the Start / Stop month settings prevent that subledger being charged. Version 3.81 Released    Loans When defining drawdown types, there are new options to: 1. Allow new payments due share the same anniversary day as prior payments. 2. Post a rebate transaction to account for any new unearned income added to the account as a result of the additional payments. Drawdowns enhanced to generate a repayment schedule for any loans that don't have them at the time the drawdown is posted. Form Letters.  New merge fields: 1. <<DrawdownsToDate>> shows the total value of drawdown transactions on the account since the account was opened. 2. <<ArrearsPlusUnpaidEnforcementExpenses2>> shows the total amount outstanding on the account but ensures this amount will not exceed any payout quote. New dynamic text facility.  (See Setup / System Tables / Messages) This lets you dynamically control the content (and color) of some messages that are displayed on the loan form for such things as: 1. Variation Information 2. Interest Free repayment info 3. Altered direct debit and credit card information New facility to prevent changes on active loans for Repayment Amounts Due or the Gross Interest. Previously these items were both locked.  Now either of them can be locked without locking the other. Direct Debits.  Fixed bug which treated an account as being complete if it had been completed then re-activated by a drawdown. Subledgers: 1. enhanced the "Start Term" and "Stop Term" settings to apply to subledgers based on the repayment amount of a loan. 2. Added a new "V" calculation method based on a percentage of the total amount advanced. 3. "At completion" subledgers will be included in any payout quotes for loans that have them. Loan Activity Report.  Optimized this report to iomprove performance. Classification Codes: 1. New facility to create a hierarchy of classification codes. (See setup / System Tables / Classification1,2,3,4) 2. New facility to disable classification codes so they may not be used when entering new loans. On the Loan form: 1. there is now a new "Total Advanced" field showing total drawdowns plus original amount advanced. 2. The "Arrears Details"  subform now also shows the current payout quote for the loan as well. Payout Quotes. Fixed bug when requesting a "Monthly Interest" type payout quote. (Implicit conversion from data type datetime to int is not allowed) Investment System New facility to rollover an existing investment into another existing investment account.

    Version 3.80 Released (02 August 2010)


    • New facility for drawdowns to re-activate completed loans, and remove any completed entries from the repayment schedule.
    • Fix bug which showed incorrect arrears on loans which had been re-activated by a drawdown.
    • New facility to set a particular type of drawdown as the default type to use when entering a drawdown transaction.
    • Fixed infinite loop bug when posting drawdown transactions on interest in advance loans with non-monthly interest periods.
    • The "Import from table" facility now includes the option to add a value for the "General Purpose 2" field.
    • Fixed "SET OPTIONS HAVE CHANGED" cursor bug when creating a loan summary report on a SQL 2005 database.
    • Fixed calculation for number of days in arrears when a payment is partially paid.
    • Fixed bug in calculating the interest component of the arrears balance. Previously payments in advance were incorrectly allocated to interest in advance.
    • Loan Activity Report now includes loans that were reactivated by Drawdown transactions.
    • Payout Quotes done via form letter will now include any drawdowns as part of the payout quote calculation.
    • For interest deferred loans the repayment schedule now shows an additional information about the minimum monthly repayment necessary to pay the loan out during the interest free period.
    • Fixed "type mismatch" error when re-creating automated credit card transactions in some circumstances.