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.

Version 3.85 released (26 Oct 2010)

Loans
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)

    Loans

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