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 V4.29 Released

** Bugs fixed

  •      [TAN-476] - Regular Direct Debit amount includes Special charges regardless of Special Charge Direct Debit setting
  •      [TAN-481] - User Statement format 5 unavailable on business code
  •      [TAN-482] - Current month calls all accounts flagged as no Direct Debit or Credit Card
  •      [TAN-488] - Cybersource export issue
  •      [TAN-489] - Last Paid date and Amount not updating under certain circumstances
  •      [TAN-493] - Incorrect Schedule Update for Line of Credit
  •      [TAN-509] - Funding Projection on Sub account causes Tango to crash



** Improvements

  •      [TAN-458] - (API) Performance Improvements Inline Functions
  •      [TAN-463] - New Principal & Interest Paid columns on P&I reports
  •      [TAN-470] - Add IV Direct Credit Export Log
  •      [TAN-480] - Allow a variety of different fee amounts to be charged to issue a form letter, depending on the account
  •      [TAN-483] - Suppress new header message on subsequent statement pages
  •      [TAN-484] - New statement keyword "InterestPaid" to match existing "TotalInterest" keyword for the statement period
  •      [TAN-485] - New facility to add Arrears adjustments via Schedule
  •      [TAN-486] - Adhoc listing should not close when Adhoc report opened
  •      [TAN-487] - (API) Add SubledgerID Output Parameter to Duplicate_Subledger
  •      [TAN-492] - New facility to charge multiple months interest in advance
  •      [TAN-494] - Improve Permissions Check for Upgrade
  •      [TAN-497] - NAB Transact Credit Card export
  •      [TAN-499] - Improvements to Creditor Disbursements
  •      [TAN-500] - New Feature to Select accounts and Statement by Cycle
  •      [TAN-501] - (API) New SetReplacementAccount# Stored Procedure
  •      [TAN-502] - New option to extend term of loan after a rate change instead of changing repayment amount
  •      [TAN-504] - Indexing Improvements
  •      [TAN-505] - Performance Improvements
  •      [TAN-506] - New Quick API EndPoint for Arrears Querying
  •      [TAN-507] - (API) Improvement to Client Search

Tango32 V4.28 Released

Bug

  •     [TAN-462] - Transaction Deadlocks
  •     [TAN-466] - Error on P&I report for accounts with Hybrid Repayment schedule
  •     [TAN-471] - Customer Statement API incorrectly filtering when loan has only one borrower
  •     [TAN-472] - Import.  Fix Comparison Rate Calc when Loan has a term of 1.   
  •     [TAN-473] - Batch Number not obtained correctly when processing Investment rollovers
  •     [TAN-475] - Incorrect Error "Subledger code requires / does not allow a related subledger" when adding loans via XML Import
  •     [TAN-478] - Customer Statement CSV Format - Date Format Inconsistent


Improvement

  •     [TAN-421] - Cyber source payment processing - Debit and Credit cards via API
  •     [TAN-433] - Transaction Performance Improvements when posting loan transactions.
  •     [TAN-437] - Performance Improvements when adding Loan Direct Debit Variations
  •     [TAN-441] - General performance improvements to system functions
  •     [TAN-442] - Index Improvements to Loan - Client relationship table.
  •     [TAN-452] - Add new Date and Time activated to FM_Loans
  •     [TAN-454] - Modify Daily Fee Job to charge a fee X days after settlement
  •     [TAN-455] - Prevent Formletters opening for edit when generated in Bulk run
  •     [TAN-457] - Change SQL Compatibility Level of Tango database to require SQL 2005 or higher
  •     [TAN-460] - Update API Stored Procedures with new quicker Inline functions
  •     [TAN-461] - Update Client_Search_Process_Options to use quicker Inline Functions
  •     [TAN-462] - New ability to store Statement Header Text at the Business Code Level
  •     [TAN-467] - New View to show loans with missing Repayment Information
  •     [TAN-468] - Veda Export should only report "PreviousAccountID" since last Export
  •     [TAN-472] - Show override and client DD and CC info on Current Month Calls Report
  •     [TAN-474] - XML Import check to avoid duplicate subledgers
  •     [TAN-477] - Allow Net Effective business codes to have Anniversary Day interest cycles
  •     [TAN-479] - ODI description on arrears tab should include rate


Tango32 V4.25 Released

Bugs

  •     [TAN-299] - Error on Check for New Version
  •     [TAN-365] - Deadlocks during levels of intensive high system concurrency.
  •     [TAN-366] - Adhoc query output misaligned when query contained Classification Description which included a linefeed character
  •     [TAN-369] - GL Transactions with Null Reference or Narrative cause incorrect balances in report writer
  •     [TAN-373] - Distinct DD variations generating consolidated amount
  •     [TAN-384] - LOC accounts - final schedule removed in Interest run when balance < min
  •     [TAN-375] - Incorrect interest charges showing on P&I (Use history) report when account has drawdowns.


Improvement

  •     [TAN-210] - Add Import/Export Format for NZ Banking
  •     [TAN-233] - Unit Testing Scripts
  •     [TAN-313] - New Arrears letters and Default letter processing - Form letter select
  •     [TAN-347] - Canadian TU positive Reporting extract
  •     [TAN-356] - Add GP 1 to Select criteria on Bulk Formletters
  •     [TAN-360] - Add Entered by and date to GL Journal entries
  •     [TAN-367] - Cleared Funds and Amounts displayed on Balance tab
  •     [TAN-368] - Formletter filter based on Business Code Account type - Exclude or Restrict to
  •     [TAN-370] - Add Client# to Loan Statement Header CSV file
  •     [TAN-372] - Allow backdated payout quote on customer statement   
  •     [TAN-374] - Veda / ACRA Export to show address and DOB changes as corrections
  •     [TAN-377] - New option to force installments to Last day of month
  •     [TAN-382] - Other Accounts - Account Summary - Filter by Processing model
  •     [TAN-386] - Incorrect YTD depreciation amount (out by 1 day) shown on Asset Register
  •     [TAN-387] - Show label of whats held when individual options used
  •     [TAN-388] - Clear unpaid schedules after zero balance - set last paid amount due to amount paid

Tango32 V4.24 Released

BUGS

  • TAN-364     XML Import matches on incorrect company when existing company client has no address details
  • TAN-363     Add clustered index to IV_HeldBatches
  • TAN-361     Improvements to Posting Transactions
  • TAN-358     REST API not linking client to automatically generated duplicates of IV_Accounts
  • TAN-352     Asset Register "Exclude accounts without depreciation rate" excludes detailed assets as well.
  • TAN-350     Custom Addressline2 - not setting the value on Client screen
  • TAN-348     Process_New_Investments improvements
  • TAN-346     Search SP fails when Column search using GP1 is selected
  • TAN-344     Month End Improvements
  • TAN-341     Issue with import from Phoenix and incorrect client being linked to account
  • TAN-330     Principal and Interest Report doesn't include drawdowns and credit reductions


IMPROVEMENTS

  • TAN-343     Delinquency reports limit account number display to 10 chars
  • TAN-224     LOC - Remove unpaid scheduled when balance goes from zero to credit
  • TAN-345     Search SP - add business code filter or new Search based on Business code
  • TAN-349     Change status of Creditors to Active when first transaction posted
  • TAN-351     Hide State where state is not needed
  • TAN-353     Cleared Funds bit and date

Tango32 V4.23 Released

BUGS

  • TAN-299 - Fix error when checking for a new version
  • TAN-330 - Principal and Interest Report doesn't include drawdowns and credit reductions
  • TAN-331 - Incorrect interest calculation when date range spans several months and there is a rate change in one month
  • TAN-333 - Unable to post payout transaction to account prior to "Defer Interest Until" date
  • TAN-336 - Error in creating debtor void transaction via API
  • TAN-338 - Creditor statements fail with error - Error Preparing IV Statement
  • TAN-341 - Issue with import from Phoenix and incorrect client being linked to account
  • TAN-342 - Cannot generate bulk Form Letters when Exclude Arrears less than option is set


IMPROVEMENTS

  • TAN-178 - Improvements to Loan Repayment Calculator
  • TAN-294 - Statement and Formletter filter and logo merge for statements
  • TAN-327 - Direct Debit Due report
  • TAN-328 - “Account type” Filter on Loan Summary Report
  • TAN-329 - Modify Daily Job SP to be able to charge a monthly fee based on the anniversary day of the loan
  • TAN-332 - New Interest Method = % of Amount Financed
  • TAN-335 - Log Client email address changes

Tango32 V4.22 Released

BUGS

  • TAN-315 - Variations with precedence set

IMPROVEMENTS

  • TAN-292 - Pre Activation GL and Transaction Summary
  • TAN-314 - Business code change schedule
  • TAN-316 - Check if client exists when importing applicants from Phoenix
  • TAN-324 - Allow Monthly nominal interest charge to be Anniversary cycle
  • TAN-325 - New Interest Method = % of Loan Limit, % of Purchase Price

Tango32 V4.21 Released

BUGS

  • TAN-258 - Failed Import still creates client record
  • TAN-296 - Statement signature message incorrect arrears
  • TAN-299 - Error on Check for New Version
  • TAN-301 - Branch Copy not copying all information
  • TAN-303 - Diary Reminder Report Screen
  • TAN-319 - Incorrect Total Dr and Total Cr in CSV output of Statement



IMPROVEMENTS

  • TAN-102 - Partial Discharges of Linked Investments - Check Available funds
  • TAN-178 - Loan Repayment Calculator / Quick Quote - restrict interest rate to two decimal places.
  • TAN-233 - Unit Testing Scripts
  • TAN-294 - Allow Customer Statements and Form Letters to filter by Logo associated with "Classification 3"
  • TAN-297 - Charge with Payment setting should include Payout transactions
  • TAN-302 - Diary Reminder Report Improvement
  • TAN-304 - Include ODI in Payouts over month end
  • TAN-309 - Add default value for OpenForEditing when editing Form Letter Definitions.
  • TAN-317 - When Interest charge are linked to a Subledger - ensure the interest narrative uses the Subledger Description
  • TAN-318 - Loan Summary Report to select by Business Code based on Historical (not current) Data
  • TAN-321 - New Simple Interest method based on closing monthly balance.
  • TAN-323 - Add a security log entry when a variation is deleted



DATABASE / API Changes

  • TAN-320     Adjust GetArrearsBalance and GetArrearsBase functions to refer to "Adjust arrears when it exceeds the net balance" flag on Business Code
  • TAN-312     Create new "Interest Types" table to allow better description of Interest Methods for Investments
  • TAN-311     Add AccountHash Filter to Clients API
  • TAN-310     Investment SP to return the account details when passed an AccountNumber
  • TAN-308     Implement Client-based Notes and Tasks - DB only
  • TAN-307     Additional and Breakdown of held status
  • TAN-306     Duplicate settings on IV Diary reminders to match FM Diary reminders - DBonly
  • TAN-305     Add new  "EmailTest" Security log Entry Type
  • TAN-298     Customer Statement SP improvements
  • TAN-293     Search to Use SP rather than in-line SQL


Tango32 V4.20 Released

Release Notes - Tango - Version 4.20

NOTE. Currently the minimum server requirement to run Tango is SQL Server 2000.  We will
soon change this to SQL Server 2008 so that we can take advantage of the more modern
features of the newer version of SQL.  If you have an older version of SQL, Tango will
display a warning message and ask you to contact us.  Please do not ignore this message.


Bug

  • [TAN-251] - Simple interest - double in first period
  • [TAN-261] - Deadlock Issues in high-intensity environment with many connections.
  • [TAN-267] - Issue with CC expiry date validation
  • [TAN-268] - Footer message for Statements persistent even after deletion
  • [TAN-277] - Add GrossSummaryTotal to Loan Statement CSV output
  • [TAN-280] - Recovery wizard not populating some fields from original account
  • [TAN-287] - Menu item "Libaries" spelt incorrectly
  • [TAN-288] - Receipt Allocation does not show fees for some accounts



Improvement

  • [TAN-233] - Unit Testing Scripts
  • [TAN-254] - Formletter templates to be stored in database
  • [TAN-260] - Add menu option to view Export log
  • [TAN-264] - Display warning for any systems running on SQL2005 or earlier
  • [TAN-265] - Improvements to GetClientLoanAddress Function
  • [TAN-269] - REST API should create IV SubAccount when required
  • [TAN-272] - Improve formatting of dbo.GetClientNames function
  • [TAN-273] - Additional Fields for API
  • [TAN-274] - Charge interest as Special Charge type 2
  • [TAN-275] - Reversing payments on Same day when one split to Special PMT
  • [TAN-276] - Customer Statement Stored Procedure API
  • [TAN-278] - Add Classification Filters to Clients API
  • [TAN-281] - Payout quote on Accounts where interest charged as Type 2
  • [TAN-282] - Add SendStatementsViaEmail to Select_Formletters SP
  • [TAN-283] - Improvements to dbo.Update_From_XML API

Tango32 V4.19 Released

Release Notes - Tango - Version 4.19

Bug

  • [TAN-225] - Repayment schedule incorrect after drawdown on IO to PI accounts are broken
  • [TAN-227] - Expected Maturity Date function does not return a value
  • [TAN-228] - Loan Activity not reporting when Not Like utilise for Business code filter
  • [TAN-230] - Monthly Nominal Interest not being charged in last few months before maturity
  • [TAN-232] - Changing Classifications and Updating linked subledgers clears GL Dr
  • [TAN-240] - Interest rate update clears scheduled amount due
  • [TAN-241] - Improve Credit Card Expiry Validation
  • [TAN-243] - NET format customer statement splits over two pages when not necessary
  • [TAN-245] - Issue with repayments changing after a rate change or drawdown
  • [TAN-248] - Error in GetStatementKeywords
  • [TAN-249] - Regular Direct Debit displaying zeroon summary screen
  • [TAN-252] - Infinite Loop calculating interest on anniversary day account with 3 monthly interest cycle
  • [TAN-256] - Double Interest Charged during first month of Monthly Nominal and Simple Interest Accounts



Improvement

  • [TAN-178] - Improvements to Loan Repayment Calculator
  • [TAN-226] - Add Classification filter to ClientSearch
  • [TAN-229] - Add tango version number to REST scripts when generated
  • [TAN-233] - Unit Testing Subsystem allows simple scripts to guarantee integrity of system.
  • [TAN-234] - Cascading Classifications values
  • [TAN-235] - Remove ODI rate ambiguity in prompts for ODI rate.
  • [TAN-236] - Add Business Code filter to client search form
  • [TAN-237] - Ability to run Adhoc queries as part of the Monthly Interest run
  • [TAN-238] - Create Customer Statement by payment due date from and to
  • [TAN-239] - Option to set Final Payment to be net balance and exclude accrued interest
  • [TAN-244] - Add New Guarantor Name Fieldsto Form Letters
  • [TAN-246] - Allow monthly subledgers to be processed even if "Defer Interest Until" date is set
  • [TAN-247] - New output format for Statement output to CSV
  • [TAN-250] - Function to return value from table/columnName
  • [TAN-257] - Add "StopInterestAfter" to Tango Import API

Tango32 V4.18 Released

Bugs Fixed

  •     [TAN-222] - Loan transaction reversals with Creditor trans - reversals generate same GL trans
  •     [TAN-220] - Type mismatch when creating VEDA extract
  •     [TAN-219] - Add better field validation errors for New Client Wizard


Improvements

  •     [TAN-218] - Re-assign Process to have Process as at Date
  •     [TAN-216] - Optional Change to Arrears for LOC accounts
  •     [TAN-215] - Change image saving to remove leading characters
  •     [TAN-163] - Ability to save a form letter to the document library on generation
  •     [TAN-140] - Prevent debit accounts from going negative
  •     [TAN-135] - Expand width of Postcode and Postal and Residential addresses