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.33 Released

21 Nov 2017

** Bug

  •     [TAN-596] - Current Non Current Analysis - Showing negative principal for accounts at end of term
  •     [TAN-616] - Creating multiple variations with precedence for a single account at once results in no variations with precedence
  •     [TAN-621] - Error Running Tango Current/ Non-Current Report
  •     [TAN-624] - Missing parameters in API
  •     [TAN-625] - PI Using History - Incorrect final PMT and Interest for Quarterly accounts
  •     [TAN-627] - Linked Investments - In Advance - No Allocation when 1 month term.
  •     [TAN-639] - Error when formletters for Completed Accounts
  •     [TAN-641] - ODI rate on business code set to zero - ODI still charged on the account
  •     [TAN-642] - Error running Direct debits
  •     [TAN-643] - Manual Processing fee issue - Direct debit reversal also includes reversal of MPF
  •     [TAN-645] - Void of only interest transaction in a loan results in incorrect "Last Interest Run Date"
  •     [TAN-646] - Error generating payout via Payout button or when part of Statement generation
  •     [TAN-649] - Payment allocation ignores payout transactions - Allocation to Principal/Interest and fees
  •     [TAN-650] - Delinquency Report - Format 6 - Issue with selection of accounts
  •     [TAN-654] - Incorrect Days in Arrears for LOC accounts where arrears balance exceeds net balance
  •     [TAN-655] - Scheduling of Fees in the Schedule when Scheduled to Next Due Date
  •     [TAN-656] - When ODI is charged via a subledger during a payout, ensure the ODI is included on the Receipt Allocation Report if the subledger requires it
  •     [TAN-661] - Direct Debit Variation - Duplicate payment when two active variation on same day


** Improvement

  •     [TAN-233] - Unit Testing Scripts
  •     [TAN-477] - Allow Net Effective business codes to have Anniversary Day interest cycles
  •     [TAN-575] - Creditor Statements SP
  •     [TAN-579] - Additional Items for SystemLists
  •     [TAN-615] - New SP Insert_FormLetterDiaryReminder
  •     [TAN-618] - Move Variations Run Concurrently with Schedule from Global to Variation
  •     [TAN-622] - Add parameter to Select_ProjectedInvestmentIncome to allow direct output of result set
  •     [TAN-628] - Option to specify a charge code for type "2" ODI transactions
  •     [TAN-630] - Create new function to get Investor base rate
  •     [TAN-632] - Linked Mortgages - Swap partial processes when insufficient funds
  •     [TAN-633] - Projection report Incorrect for Interest In Advance Contributory Mortgages - Initial period and after swap
  •     [TAN-636] - IV Transactions API Performance Improvements
  •     [TAN-637] - DD Variations API Improvements
  •     [TAN-638] - Improvements to REST Generator
  •     [TAN-640] - New Investment Interest cycle - Periodic
  •     [TAN-644] - Customer Statement Improvements
  •     [TAN-648] - Improvement to Creditor Payout Quote
  •     [TAN-651] - Improve validation in Periodic Direct Debits
  •     [TAN-652] - Term for LOC when paying min reducing repayment - Formletter keyword
  •     [TAN-662] - Add "IsDisabled" flag for tables FM_Businesscodes, FM_Subledgers, FL_Formletters, AdhocQueries


Tango32 V4.32 Released

Bug

  •     [TAN-521] - Statement Generation fails if Maturity date calc running
  •     [TAN-550] - Loan Activity & Loan Summary - Loans without clients not showing
  •     [TAN-562] - Loan Activity Report shows no results when selecting "All Activity"
  •     [TAN-563] - Completed Loans Report shows incorrect bad debt figure.
  •     [TAN-565] - Payout quote - Consumer Credit not including K-Payments in payout calc
  •     [TAN-567] - Payout interest incorrect - % of Purchase Price Interest method
  •     [TAN-569] - GetAllocatedInterestInArrears error in function
  •     [TAN-570] - Function [dbo].[PaymentAllocation] - should only allocate to ODI under certain conditions
  •     [TAN-572] - GetInterestinArrears calculations incaccurate
  •     [TAN-573] - Repair schedule does not handle out of date reversals well
  •     [TAN-576] - Enhancement to "Simple Interest #2" Interest Calculation Method
  •     [TAN-580] - Incorrect Interest Dates on Anniversary Day Loans with Interest Cycles longer than one month
  •     [TAN-582] - Simple Interest - Daily Interest Payout method - Issue with Payout transactions
  •     [TAN-583] - Asset Register Report - Calculation of Asset WDV out by one day, "Next Yr Orig. Cost" incorrect in some situations.
  •     [TAN-585] - Customer Statement CSV File header - Negative payments affecting Totals
  •     [TAN-587] - "Reschedule" and "Refinance" transactions posted to loans linked to other loans via subledger do not create related "Reschedule" and "Refinance" transactions
  •     [TAN-591] - "Last Day Of Previous Interest Period" function is incorrect (6 days early) for accounts where interest compounds daily
  •     [TAN-592] - At Completion Subledgers not generating charge at payout
  •     [TAN-593] - Interest run incorrectly using old Interest Rate Schedule entries for Interest calc
  •     [TAN-594] - Importing Transaction from Phoenix to Tango - GL accounts incorrect
  •     [TAN-595] - Receipt Allocation - Not showing net balance for accounts with no transactions in period
  •     [TAN-597] - Projected Balance incorrect on Interest Only in Advance
  •     [TAN-605] - Improve accuracy of PI report using Schedule
  •     [TAN-609] - Inconsistent Figures between Summary and Detail in Current Non Current report
  •     [TAN-612] - Deliquency report definition - Report fails to run when SQL definition greater than 2048 bytes


New Feature

  •     [TAN-588] - Finance Based Loans - Adding extra Assets post activation
  •     [TAN-589] - Additional Reference Columns for Transactions available in API
  •     [TAN-606] - Filter chargecodes by branch when entering transactions



Improvement

  •     [TAN-512] - Performance Improvements to Direct Debit Processing
  •     [TAN-545] - Current / Non-Current Report - Make Gross Balance Calculation consistent with Loan Summary Report
  •     [TAN-559] - New option to send specific Loan ODI Rate via XML Api
  •     [TAN-560] - Add support for MS Word 2016 for FormLetters
  •     [TAN-561] - Fixed Principal Repayment Schedule includes one extra Principal Only repayment in some circumstances.
  •     [TAN-574] - New Payout Method - Simple Interest #2
  •     [TAN-578] - New "Other Accounts" Statement Sequence - Account Description
  •     [TAN-581] - Gross Interest on Annual Cycle accounts inaccurate at setup
  •     [TAN-584] - Allow addition of assets without increasing the loan amount financed.
  •     [TAN-598] - Create BudgetPrices View
  •     [TAN-602] - Add p.a to Interest rate label on User #2 statement format
  •     [TAN-603] - Current Non Current - Export of report - Column headings not preserved


Tango32 V4.31 Released

** Bug

  •      [TAN-536] - Inertia transactions ignoring GL Accounts in Inertia Subledger as defined in business code
  •      [TAN-538] - Post backdated "2" transaction generates interest adjustment even if "Adjust Interest On Backdated Transactions" is disabled
  •      [TAN-539] - Incorrect Interest Arrears being reported
  •      [TAN-543] - GL Statement - Missing Transaction Amounts when exporting to Excel
  •      [TAN-546] - Minor issue with Contrib mortgage - Projection report. Mutiple months being incorrectly allocated in month #1.
  •      [TAN-548] - Issue deleting loans when Template has been used - Fm_TemplateData
  •      [TAN-551] - Tango API - Client filter not working properly for accounts
  •      [TAN-552] - Incorrect Projection on Contrib mortgages with Pro rata periods
  •      [TAN-553] - Incorrect allocation on Contrib mortgages when Extended
  •      [TAN-554] - Line of Credit Schedule fails to clear properly under certain circumstances
  •      [TAN-555] - Running Gross Balance on Statements not affected by special charges and special payments
  •      [TAN-558] - Zero Divide Error on Asset Register when Depreciation Rate is zero


** Improvement

  •      [TAN-518] - New repayment calculation method: Principal only to Fixed Principal plus Interest cycle
  •      [TAN-523] - Bulk Formletters not correctly selecting by days in arrears when penalties affect arrears balance
  •      [TAN-527] - The ability to set Principal and interest Allocation while entering a Transaction
  •      [TAN-547] - Investor funding row - incorrect rate and amount advanced
  •      [TAN-549] - Veda Positive Reporting - Exclude RepaymentHistory when sending corrections
  •      [TAN-557] - Auto Generate Writeoff - Selection Criteria improved


Tango32 V4.30 Released

Bug

  •     [TAN-493] - Incorrect Schedule Update for Line of Credit accounts.
  •     [TAN-525] - Improvement to Arrears Allocation view when payments allocated to Penalties
  •     [TAN-526] - Interest In Advance - Multiple month first payment - Actual non-smoothed Interest incorrect
  •     [TAN-532] - Part payment of Linked Mortgage Interest Allocation incorrect
  •     [TAN-533] - Exporting GL Statements excludes Credit column in Output


Improvement

  •     [TAN-490] - Additional General Purpose Fields
  •     [TAN-502] - New option to extend term of loan after a rate change instead of changing repayment amount
  •     [TAN-513] - Performance Improvements to Creditor Disbursements
  •     [TAN-514] - Blocking in Posting IV Transactions
  •     [TAN-516] - Small Performance Improvement in Schedule
  •     [TAN-520] - Payment Allocation function not showing correct principal allocation on P&I accounts
  •     [TAN-522] - API Arrears Endpoint Improvements
  •     [TAN-523] - Bulk Formletters not correctly selecting by days in arrears when penalties affect arrears balance
  •     [TAN-524] - ODI charded as Debit - GL should be driven from Chargecode
  •     [TAN-528] - Create Sec Log Entries for new Scheduled Variations
  •     [TAN-535] - Variation Performance Improvements
  •     [TAN-537] - Payout on Finance Based account with Asset that has zero depreciation rate causes zero divide error.

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