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

Tango32 V4.17 Released


Bugs Fixed

  •     [TAN-214] - ODI charged via subledger as debit not appearing on Receipt allocation Rep
  •     [TAN-213] - VOID transactions display incorrect warning message with large voids
  •     [TAN-211] - Unable to create VOID transactions using API Stored Procedure
  •     [TAN-209] - Cannot select loan from search form when borrower has "No Correspondence" enabled


Improvements

  •     [TAN-212] - Expose Override Bank Account Details in XML API
  •     [TAN-210] - Add Import/Export Format for NZ Banking
  •     [TAN-207] - Allow entry of "Arrangement Amount" as part of a diary reminder which relates to an arrears arrangement
  •     [TAN-166] - Direct debit for credit cards now split into valid and error batch
  •     [TAN-159] - Changes to footer of Receipt Allocation Report
  •     [TAN-146] - Increase length of GP3 field from 2 characters to 40 characters
  •     [TAN-122] - Enhancement to Investment Statement to include Logo
  •     [TAN-79] - New Export Format for Bulk Statement run (csv)

Tango32 V4.16 Released

Bugs Fixed

  •     [TAN-206] - Error Printing form letter when "Display before printing" is not ticked.
  •     [TAN-205] - IV Customer Statement does not allow an empty statement to be generated
  •     [TAN-203] - Error when credit card type set to empty value
  •     [TAN-202] - Classification fields not being set in Wizard. Cannot be set on active account
  •     [TAN-201] - Error with CheckSecuritySetting
  •     [TAN-156] - Asset Register Report - YTD Depreciation incorrect in July of a Leap Year


Improvements

  •     [TAN-165] - Add bit flag on Form Letters to allow No Correspondence override
  •     [TAN-161] - Add Void Transactions for IV_Transactions

Version 4.15 Released

Bugs Fixed

  •     [TAN-200] - Creditor batches will not export
  •     [TAN-199] - VOID payments not generating subledger history
  •     [TAN-198] - Add bitmap filetype to image select window
  •     [TAN-133] - Add flag to formletters to filter based on account type

Tango32 V4.14 Released

Bugs Fixed

  •     [TAN-196] - Null BSB or Bank or Branch info causes Transaction Receipt/Deposit listing to fail
  •     [TAN-193] - Incorrect rounding of GST on sub ledgers applied to residuals
  •     [TAN-191] - Residual Value not showing at bottom of schedule
  •     [TAN-189] - Defer Payments in DD Screen out by one day
  •     [TAN-188] - Statement Output Format does not save on Customer Statement Form
  •     [TAN-187] - Copy Business Code Doesn't Migrate some columns
  •     [TAN-182] - ODI Grace Period Calculation out by one day
  •     [TAN-180] - Repair schedule adding entry prior to first due date
  •     [TAN-177] - Positive reporting not correctly excluding defaults
  •     [TAN-176] - Duplicate batch created when process Pay Creditors executed
  •     [TAN-175] - Imports and Exports not working - For Cardfast, Eselect and RBC
  •     [TAN-174] - Error exporting Pay Creditor Transactions
  •     [TAN-167] - Error Importing Form Letters
  •     [TAN-160] - Improvements to Batch Processing to allow higher volume of transactions to be posted concurrently
  •     [TAN-158] - Error in Export_Repayments_STGCreditCard CreditCard Expiry should not contain "/"
  •     [TAN-157] - Leading Zero on Credit Card Expiry not stored or displayed when viewed
  •     [TAN-155] - Weekly Fortnightly DD payments not updating on the correct date after rate change or drawdown
  •     [TAN-150] - Process button on Invitation disabled if any invitation not fully accepted
  •     [TAN-139] - Rate change at start of period should generate smoothed interest
  •     [TAN-93]  - Annual Fee Charging 1 month past anniversary


Improvement

  •     [TAN-197] - Show Creditor Account# on Classification and linked Subledgers
  •     [TAN-195] - Add Max Days in arrears to Current Month Calls report
  •     [TAN-194] - Improve email address validation
  •     [TAN-184] - Anniversary day interest run to process any missed accounts
  •     [TAN-179] - New function GetNumberConsecutivePayments
  •     [TAN-173] - Add Option to show BPay information on Customer Statement Footer
  •     [TAN-172] - Direct Debit process for Credit card to be restricted by Card type
  •     [TAN-168] - Add batch total to information displayed in Held batches
  •     [TAN-162] - Default file upload - separate process for VEDA Credit Bureau
  •     [TAN-154] - Use shell open on AdHocQueries to improve usability
  •     [TAN-153] - New option for variations which start on the last day of a 30 day month and should not fall due on day 31 next month
  •     [TAN-144] - Movement of funds when Settling and discharging
  •     [TAN-138] - Add addtional fields to IV Form Letters
  •     [TAN-137] - Add additional fields to invitation formletter source
  •     [TAN-134] - Allow Voids on all FM_Transactions
  •     [TAN-125] - Use default program open instead of Internet explorer when opening form letters
  •     [TAN-107] - Syndicated Statement - Invitation Amount/Accepted amount
  •     [TAN-106] - Invitation to Invest - auto set Max Anticipated Drawdown
  •     [TAN-103] - Investment Discharge and Swap Report - Add Primary Investor name
  •     [TAN-90]  - Allow Searching by Security address
  •     [TAN-10]  - Is Like on Business code for reports: Completed Loans, Loan Activity, Receipt Allocation


Tango32 V4.13 Released

Bugs fixed

  •     [TAN-87] - Error when generating direct debit when a loan has multiple Clients, one of which is not a main borrower.
  •     [TAN-93] - Annual Fee Charging 1 month past anniversary
  •     [TAN-98] - 'Account' button on Investment Transaction entry opens wizard and not Account Search
  •     [TAN-111] - Unticking 'Direct Debit' causes crash on save when 'autopay' enabled
  •     [TAN-114] - Direct Debit Varation not ordering with active on top
  •     [TAN-115] - FormLetters RecordSourceName Limits to 18 characters when adding New Letters using Access Runtime 2000
  •     [TAN-116] - After a rate change, Interest Only Repayments in Repayment Schedule Incorrect
  •     [TAN-118] - Clicking "Exclude Completed" on Investment funding form causes exception
  •     [TAN-120] - Discharge - incorrect repayment updated - incorrect pro rata amount
  •     [TAN-123] - Error "You must set the FROM date on or after this date" when changing interest rate on loan account
  •     [TAN-126] - "Exclude completed accounts" ignored when using the wildcard on the Client Search form
  •     [TAN-127] - Double Click on Document in Document library causes Tango to Crash
  •     [TAN-128] - Accounts imported from Phoenix with Residual - incorrect residual and number of payments
  •     [TAN-129] - Other Accounts - When adding creditor via wizard - Responsibility Type set to "I" instead of "C"
  •     [TAN-131] - Interest rate change does not create pro rata scheduled entry
  •     [TAN-141] - Linked Investments - Allocation incorrect in Projection report for first allocation - new account
  •     [TAN-143] - invitation Description won't allow more than 1 character - on existing loan
  •     [TAN-145] - Incorrect repayment after draw-down and rate change when out of date order
  •     [TAN-147] - Possible issue with allocation of funds on linked investment account.
  •     [TAN-148] - Error with function dbo.GetTerm when a residual value is supplied.
  •     [TAN-149] - Investments: Manual payments of interest - second payment not generating entry in Payments table
  •     [TAN-151] - Linked Investments - Allocation Issue for Swaps.
  •     [TAN-152] - Interest transaction generated to Investors without Loan Interest


Improvements

  •     [TAN-78] - Prevent Credit accounts from going negative - debit balance
  •     [TAN-89] - New Loan Security Formletters
  •     [TAN-94] - Print Funding Renewal - Syndicated statement
  •     [TAN-101] - Other accounts - Description field - increase length of field
  •     [TAN-104] - Partial Discharge - 1 Month Penalty interest to Discharged Investors - Paid by Mortgage holder
  •     [TAN-105] - Document Library - Order by newest to oldest
  •     [TAN-112] - Add index to IV_Transactions.TransactionTypeID
  •     [TAN-113] - Extend FormLetterName to allow 100 characters
  •     [TAN-117] - Use default program open instead of Internet explorer when opening files from Document Library
  •     [TAN-124] - Always show two decimal places for HighInterestRate/LowInterestRate on Select_InvitationFormLetters
  •     [TAN-132] - Improvements to Process_New_Investments
  •     [TAN-142] - Add the ability to Remove documents from Library

Tango32 V4.12 Released

Fixes

  • Bug            TAN-54    Repayment Variations not applied properly via API    Neil Ennis    Resolved
  • Bug            TAN-68    Connection not disposed properly on logoff under certain circumstances    Neil Ennis    Resolved
  • Bug            TAN-74    Doubling of IC transaction on Payout of Investment - 2 main investors    Neil Ennis    Resolved
  • Bug            TAN-76    Interest run may be generating Variations on accounts from Imported data    Neil Ennis    Resolved
  • Bug            TAN-80    Change in ongoing fee Subledger doesn't flow to DD screen    Neil Ennis    Resolved
  • Bug            TAN-86    Interest rate change cleared repayment schedule amount due    Neil Ennis    Resolved
  • Bug            TAN-96    Partial Swap not creating remainder entries in Funding details    Neil Ennis    Resolved
  • Bug            TAN-97    Direct Credit process - Crashes Tango    Neil Ennis    Resolved
  • Bug            TAN-99    Interest credit generated by Loan Payment picks up wrong loan client    Neil Ennis    Resolved
  • Bug            TAN-100    Same Investors twice on Funding details - not combining    Neil Ennis    Resolved
  • Bug            TAN-108    Rate and Drawdowns affecting first payment incorrectly    Neil Ennis    Resolved
  • Bug            TAN-73    DD schedule not updating for IO loans after rate change    Neil Ennis    Resolved
  • Bug            TAN-81    Repayment not affected by Drawdown in period drawdown applied    Neil Ennis    Resolved
  • Bug            TAN-83    Allocation not occuring when payment posted for Linked Investments    Neil Ennis    Resolved
  • Bug            TAN-56    Balance showing incorrectly with Drawdown    Neil Ennis    Resolved
  • Bug            TAN-63    RBC file export issue - Canada DD export    Neil Ennis    Resolved
  • Bug            TAN-71    Invalid Column 'isMissing'    Neil Ennis    Resolved
  • Bug            TAN-72    Cannot process Invitation - Live Tango_Eclipse    Neil Ennis    Resolved
  • Bug            TAN-75    Expired variations not sorted to bottom of listing    Neil Ennis    Resolved
  • Bug            TAN-82    Additonal Veda Positive Reporting changes    Neil Ennis    Resolved
  • Bug            TAN-95    Tango Crashes when Funding details- Invested amount dble clicked for Mngment fee    Neil Ennis    Resolved
  • Bug            TAN-110    Picking up incorrect information for borrowers and Guarantors    Neil Ennis    Resolved


Mods

  • Improvement    TAN-57    Pro rata Interest in Period of rate or drawdown - Linked Loan Investments    Neil Ennis    Resolved
  • Improvement    TAN-67    Document Library - change from Diary entry    Neil Ennis    Resolved


                    NOTE. There is a new document library tab on loans and investments which allows you to create a "Library" and store documents (PDF, DOC, RTF, JPG, etc) against loans.
                    You need to create a new public shared library folder which is accessible to all Tango users (Similar to the Form Letters folder)
                    You can drag / drop or import existing documents into the library.

  • Improvement    TAN-84    Investment Invitations using formletters    Neil Ennis    Resolved
  • Improvement    TAN-88    Alterations to VEDA Positive Reporting    Neil Ennis    Resolved
  • Improvement    TAN-36    Add monthly fees to Interest Only Scheduled entries    Neil Ennis    Resolved
  • Improvement    TAN-45    Improve Table Function dbo.GetNextVariationDirectDebit    Lachlan Ennis    Resolved
  • Improvement    TAN-50    API - Add GETAll for Classifications    Neil Ennis    Resolved
  • Improvement    TAN-39    Swap Processing Report    Neil Ennis    Resolved
  • Improvement    TAN-46    Diary entry and Log entries should be flagged with User and not DBO    Neil Ennis    Resolved
  • Improvement    TAN-47    Dishonour Payment import - ABC    Neil Ennis    Resolved
  • Improvement    TAN-48    Add Direct Debit or Payment method label for better visibility    Neil Ennis    Resolved
  • Improvement    TAN-49    Ability to delete an unprocessed invitation    Neil Ennis    Resolved
  • Improvement    TAN-51    Funding form - Display rate on label - rate to be calculated as described    Neil Ennis    Resolved
  • Improvement    TAN-52    Changes to Loan Funding form - Set rate editable    Neil Ennis    Resolved
  • Improvement    TAN-53    Linked Investment Discharge Process    Neil Ennis    Resolved
  • Improvement    TAN-55    Dishonoured Credit Card Payment Import     Neil Ennis    Resolved
  • Improvement    TAN-58    Changes to Loan Investment Invitation    Neil Ennis    Resolved
  • Improvement    TAN-60    Sort Funding form by Investor and then by Date    Neil Ennis    Resolved
  • Improvement    TAN-61    Ability to set Subaccount on Unallocated or Unlinked account    Neil Ennis    Resolved
  • Improvement    TAN-62    Restrict Available Export formats available    Neil Ennis    Resolved
  • Improvement    TAN-65    Implement corrections for Veda positive reporting    Neil Ennis    Resolved
  • Improvement    TAN-66    Use Index to Improve load performance of Funding form    Neil Ennis    Resolved
  • Improvement    TAN-69    Minor change to Swap and Discharge process - Completion and Start date    Neil Ennis    Resolved
  • Improvement    TAN-85    Add ContractualMinimumAmountDueAsAt to API    Neil Ennis    Resolved
  • Improvement    TAN-109    Reverse order of document display in Document library tab    Neil Ennis    Resolved
  • Improvement    TAN-43    Withholding Tax Rate - Ability to Store 2nd Rate    Neil Ennis    Resolved
  • Improvement    TAN-44    Add Indexes to Optimise Performance    Neil Ennis    Resolved
  • Improvement    TAN-59    Add warning when adding a drawdown for an account in advance, suggest redraw    Neil Ennis    Resolved
  • Improvement    TAN-70    Change SP Get_Borrowers_Of_Loan to not use a cursor    Neil Ennis    Resolved
  • Improvement    TAN-77    Adjust Transaction narratives to remove leading new line and white space characters    Neil Ennis    Resolved



Tango32 V4.11 Released

19 May 2015

LOANS

Fixes

  • Fix calculation of next due date when account is in advance and arrears have been set to calculate from the as at date rather than the day after.
  • P & I Report should ignore "Disable Arrears" settings
  • (Tango / Tan-40) Monthly Chargeable subledgers were appearing in PI report twice
  •  Fix NULL value when exporting loan payments to creditors
  • When reversing a payout, clear disposal settings on any assets disposed as part of the original payout
  • Loan Direct debits now checks creditor available funds if paying via Creditor
  • Fix problem where rate change causes new direct debit amount to appear one month early for variations
  • Fix bug which un-smoothed repayment amounts during rate change on IO loans with smoothed repayments
  • Fix first payment amount for interest in advance loans with common anniversary day
  • Rate change on interest only in advance was starting one day too late in schedule
  • Fix incorrect calculation of unallocated Principal, Interest and Charges on the receipt allocation report.
  • Fix Formatted Postal Address in Form Letters
  • Fix Drawdowns and Credits so that they generate interest adjustments when entered prior to last interest run date
  • Fix criteria for a repayment appearing in schedule as being "Inertia" related
  • Fix incorrect minimum dd amount on variation screen
  • Fix "value too large for integer" error for subledgers with results larger than about 275,000 that require rounding.
  • Removing a subledger that affects repayment amounts from an active loan will now reduce repayment amounts on that loan.
  • Fix selection logic which incorrectly excluded accounts which started after the FROM date of the VEDA report.
  • Fix Set Focus error when trying to display consolidated DD summary
  • Consumer Credit Payout Quote - fix Insurance Rebate issues when run via Access 2012.


Mods

  • Add a second "related creditor" link to Business Codes.
  • Add suffixes for automatically generated Sub-Accounts, Related Accounts, and Related Creditors.
  • New direct debit interface for ACH (USA)
  • The system log now records each time direct debits are generated.
  • Added "Classification 7" to Clients.
  • Added "Classification 8" to Investment Accounts.
  • When generating correspondence, override the "No Correspondence" flag for Principal Borrowers, who should always be contacted.
  • New option for leases to to deduct arrears from finance-based payouts
  • Add account range to ACRA / VEDA export for testing purposes
  • New "Interim" and "Ongoing" direct debit variation facility.
  • (Tango / TAN-12) Add Clustered Index to FM_DirectDebitVariations on LoanAccountNumber
  • (Tango / TAN-13) Add extra fields to fm_directdebitvariations: WhoEntered, DateEntered, WhoUpdated, DateUpdated
  • (Tango / TAN-5) Add "Annual Fee" and "ongoing amount" to Regular DD


INVESTMENTS

Fixes

  • Improve the selection criteria which determines whether an investor should be included in an Invitation to Invest.
  • Fix duplicate Investment Payments when there were multiple 'IO' transaction types defined for different business codes
  • Fix null investor client name appearing when no individual contact is entered for the client
  • Fix selection criteria on Cheques and Remittances report


Mods

  • Add a new "Unallocated Funds Holding Account" for investments that are linked to loans.
  • "Investment Swap" facility which allows you to swap in/out investors to an investment-funded mortgage.
  • (Tango / TAN-38) Projected Interest report for Linked Investors no includes Pro rata adjustments for swapped in / out investors.
  • Add Remittances and Cheques to Processing Menu