Tango32

Tango32 V4.63 Released

Release notes - Tango - Version 4.63 Bug * TAN-1531 Contrib Interest in advance - smoothed pmts not calculating period interest or correct schedule * TAN-1530 Contrib Interest in advance - Charge and Pay when Mortgage Interest Paid not generating Investor Pmt * TAN-1529 Error during interest run when repairing schedule on accounts with "Repayment Frequency" set to "Q" \(Quarterly\). * TAN-1527 Error running V4.62 script on a 4.61 version db * TAN-1526 Mirror transaction do not appear to being generated * TAN-1523 Contrib Mortgages - Subsequent invitation mid period causing interest cr and pmt to already paid investors * TAN-1522 VOID drawdown not reversing initial Pro rata pmt correct for some accounts * TAN-1521 Incorrect repayment schedule after posting drawdown * TAN-1507 Gross Interest adjustment incorrect when posting drawdowns to IO accounts * TAN-1506 IO Arrears - Smoothed repayment amount incorrect after drawdowns * TAN-1505 Recalc adding additional schedule entry to schedule * TAN-1503 Interest In Arrears Smoothed repayments - error in repayment calc when rpmts smoothed and not actual Improvement * TAN-1533 Improve performance of view IV\_Transactions\_By\_Account * TAN-1532 Improve Investor Statements performance * TAN-1504 Smoothed IO with Pro rata period should use smoothed amount for 1st and last pmt split * TAN-1500 Improve Performance when Posting Drawdowns * TAN-1474 Batch Category on FM\_HeldBatches - DB change only New Feature * TAN-1520 Set Add Edit sort order for Classifications to Alphabetic * TAN-1499 Classification 9 filter to reports which currently have Class1 through 4 filtering

Continue reading

Tango32 V4.62 Released

Release notes - Tango - Version 4.62 Bug * TAN-1502 Adhoc queries which use Google Charts fail for complex queries * TAN-1497 Arithmetic overflow when large balance involved in Payout quote calculation * TAN-1496 Interest only in Arrears - RV being dated the month prior to the last pmt * TAN-1493 FM\_loans\_Rest view performance very poor. * TAN-1488 Line of credit Percentage of net plus interest - not preserving overdue schedule entries when drawdown posted * TAN-1486 Investor Interest run deadlocks Improvement * TAN-1501 Add Classification9 to FM\_Loans\_REST * TAN-1494 Include clearing days for Available funds calc for Investors * TAN-1492 NEW SP Insert\_ClientFormLettersQueue * TAN-1491 Change description of Setting * TAN-1490 Add category to Settings * TAN-1489 Include Classification 7 in Client Search results - Enterprise only change * TAN-1487 Add Settlement Status description to view FM\_Loans\_By\_Client * TAN-1481 DB changes only - Add assigned employee column to FM\_Loans\_By\_Client and IV\_Accounts\_By\_Client * TAN-1480 New Settings category to better group settings * TAN-1479 New settings for Creditor Wizard - more settings * TAN-1403 Improvements to Import XML duplicate detection New Feature * TAN-1485 DB changes only - Add Workflow status to Creditor Search results * TAN-1484 DB changes only - Add Client Workflow description to Client search results * TAN-1483 DB changes only - New Client Workflow status * TAN-1415 PPSR Prototype

Continue reading

Tango32 V4.61 Released

Release notes - Tango - Version 4.61 Bug * TAN-1477 Repair schedule removing valid entries from Schedule * TAN-1476 Contrib mortgage interest run failing due to inclusion of specific accounts out of date sequence * TAN-1472 Update User\_Classification2FormLettersBase SP to return the AccountNumber * TAN-1470 Discounted Present value issues when SP Select\_Payout\_Quote used in a query - Asset XML causing differences * TAN-1469 Cannot enable Service broker * TAN-1467 Change Schedule not detecting IO for full term accounts correctly * TAN-1466 RV flag set to last std pmt amount and not final rv amount after change schedule * TAN-1465 Charges due does not update correctly on schedule change when account has fixed monthly fees * TAN-1464 Payout quote not passing AsAtdate through to subledger external function call * TAN-1463 VOID of discharge or partial where adj generated not voiding the clearing account transactions * TAN-1462 Duplicate principal reduction amount showing in Primary investment statement * TAN-1461 Incorrect Interest paid for swapped out account * TAN-1451 Null keywords are being added to FM\_Search table * TAN-1439 Regenerate Tango API REST Scripts * TAN-1437 Error in Update\_From\_XML * TAN-1422 Improve validation on Bank Account details used to export Direct Debits * TAN-1409 Variations ignored by repair schedule for Line of Credit repayment method * TAN-1383 Incorrect Interest on P & I Report when Account with monthly fees has multiple months between settlement and first payment Improvement * TAN-1474 Batch Category on FM\_HeldBatches - DB change only * TAN-1473 Adhoc query security - control who can run the query * TAN-1460 Separate settings to control pmt adjustment for Swap and discharges on contrib mortgages * TAN-1459 New setting to control interest in advance schedule entries for mid period adjustments * TAN-1458 Restrict transaction to Short description when transaction defined at the subledger level * TAN-1457 Add disabled bit column to FM\_DocumentLibraries * TAN-1456 Add Creditor Link to FM\_Classification4 table * TAN-1452 New FM\_Loan Column - InsurancePolicyStartDate * TAN-1403 Improvements to Import XML duplicate detection New Feature * TAN-1478 DB changes only - add assigned employee to search result for Debtor and creditor search * TAN-1475 AssignedEmployeeID to FM\_Clients, FM\_Loans and IV\_Accounts * TAN-1471 IV\_Businesscode new statement setting - CS\_PrintToLetterhead * TAN-1468 Classification 1 to 4 filters for Transaction Audit report * TAN-1454 New FM Classification 9 table - cascade link to higher classification and creditor link * TAN-1453 Creditor Business code - additional columns * TAN-1448 Single Search field * TAN-1432 Security Document library - Security and Assets \(DB changes only\) * TAN-1426 New Dr Classification table * TAN-1421 dbo.

Continue reading

Tango32 V4.60 Released

Release notes - Tango - Version 4.60 Bug * TAN-1450 Cannot generate creditor letter using SP as datasource * TAN-1449 Separate columns for Sundry Income and Bad Debt transactions on Completed Loans Report * TAN-1445 Processing Invitations uses the same ThreadID for Interest and Drawdown transactions. * TAN-1434 VOIDING Debtor or Creditor transactions causes duplicated voids on the GL transactions * TAN-1433 Possible disconnect when Enterprise and Tango run at same time * TAN-1431 Update to Defer Interest until date does not update Last interest run date under some circumstances * TAN-1430 Cannot set defer interest until date via calendar control only via manual date entry * TAN-1428 Changing Classification3 value clears Classification4 value * TAN-1424 Interest in Advance - Incorrect schedule update after drawdown and manual interest transaction * TAN-1423 Error when running Receipt allocation report * TAN-1420 Error "Invalid column name 'ID'.

Continue reading

Tango32 V4.59 Released

Release notes - Tango - Version 4.59 Bug * TAN-1419 Some differences between payout amount shown on balance tab and payout quote * TAN-1418 Tango crashes when viewing the balance tab of a completed account * TAN-1413 Allow XML import to match Asset Item Type on either Item Code or Description * TAN-1412 Contrib mortgage - Investor statement incorrect after swap and auto interest adj for both swap in and out * TAN-1411 Contrib Mortgages - Older interest pmts can be missed when a discharge or swap occurs in a past period * TAN-1410 Posting a manual interest transaction to contrib account can cause additional allocation to investors of combined amounts.

Continue reading

Tango32 V4.58 Released

Release notes - Tango - Version 4.58 Bug * [TAN-1401] Strange behaviour when processing invitation - showing Main Account for on contract tab * [TAN-1399] Incorrect interest charge generated for initial period of some interest in advance accounts * [TAN-1397] dbo.GetBorrowersTable returns NULL Name under certain circumstances * [TAN-1396] Contrib mortgage - Partial discharge interest adj narrative shows incorrect period for adj dates * [TAN-1395] Partial discharges generating principal repayment entry matching revised RV entry.

Continue reading

Tango32 V4.57 Released

Release notes - Tango - Version 4.57 Bug * [TAN-1311] - XML import ignoring months in advance when importing the repayment amount * [TAN-1329] - Voiding a transaction - list of available transactions is empty * [TAN-1335] - New option for simple interest to be based on Opening Gross Interest Balance rather than Current Gross Interest Balance * [TAN-1340] - Export from Phoenix fails when trying to update existing Tango client record.

Continue reading

Tango32 V4.56 Released

Release notes - Tango - Version 4.56 Bug * [TAN-1317] - IV batch showing as duplicate - appears to be an issue withe IV_held batches view * [TAN-1318] - Improve performance of "Special Charge Summary" section of Loans Form when Penalty Debits are enabled * [TAN-1321] - Reversal of pmt results in reversal of GST with 1c difference between original GST and reversal GST transaction * [TAN-1322] - Contrib interest in arrears - pro rata period for last pmt - narrative shows full period * [TAN-1323] - Interest only with Pro rata 1st and last and smoothed in full period - incorrect smooth repayment amount * [TAN-1325] - Batch was hidden due to TransType being set to I - manually entered batch * [TAN-1326] - Asset Register - Depreciation MTD logic * [TAN-1327] - Payout Method - NPV Method - correct handling of penalties and odi * [TAN-1332] - Interest in Advance accounts being ignored by Interest run * [TAN-1333] - Wizard error when setting up new account - Invalid column name SheduleID * [TAN-1334] - Imported Interest inAdvance setting incorrect 1st payment amount * [TAN-1337] - Issue running Anniversary day interest run on investment accounts * [TAN-1338] - Chargeable subledger added to loan after activation permanently increases opening balance even after deletion * [TAN-1339] - Interest rate change on new Line of Credit plus interest sets all repayments to be the same New Feature * [TAN-1328] - New SP to update branch user * [TAN-1330] - New Weekly Interest cycle for Loans * [TAN-1331] - New Line of Credit repayment method - Line of Credit method + Interest for period Improvement * [TAN-1324] - Further validation to XML import - RepaymentVariationStart * [TAN-1336] - New setting to control transaction available to completed accounts

Continue reading

Tango32 V4.55 Released

Release notes - Tango - Version 4.55 Bug * [TAN-1303] - New account with blank schedule and non monthly repayment frequency - drawdown creates monthly schedule. * [TAN-1311] - XML import ignoring months in advance when importing the repayment amount * [TAN-1317] - IV batch showing as duplicate - appears to be an issue withe IV_held batches view * [TAN-1319] - Transaction mirroring using Part Payment generating incorrect amount * [TAN-1320] - Creating a new loan may incorrectly update FM_Loans.

Continue reading

Tango32 V4.54 Released

Release notes - Tango - Version 4.54 Bug * [TAN-1252] - Diary Reminder Report doesn't allow numerals in "Action Code" criteria * [TAN-1283] - Payout of RV generates Interest and bad debt transactions * [TAN-1288] - Contrib mortgage - allocation of Interest pmt not in correct sequence for some investors * [TAN-1290] - Contrib Mortgages - Pro rata first and last - schedule incorrect after processing invitation * [TAN-1293] - Error when responding yes to Investment Interest rate change via business code * [TAN-1294] - Error when running upgrade scripts via - Development ->Tools -> Run SQL Script * [TAN-1296] - Invalid Authorisation specification message when connecting to Tango db from Windows 10 home * [TAN-1297] - Flat Cancel Doesn't correctly reverse up-front subledgers * [TAN-1299] - Drawdown not updating schedule correctly when more than 1 month from settlement to 1st pmt * [TAN-1300] - Depreciation calculations inconsistent during a leap year.

Continue reading