Tango32

Tango32 V4.68 Released

Release notes - Tango - Version 4.68 Bug * TAN-1567 dbo.Select\_PaidInFull error when parameter not specified Improvement * TAN-1565 Flag Balloon pmts in Schedule \(BP\)

Continue reading

Tango32 V4.67 Released

Release notes - Tango - Version 4.67 Bug * TAN-1563 Interest adjustment generated when fees posted after monthly interest run on last day of month - adj incorrect * TAN-1562 YTD Balance not appearing on GL Reportwriter in some cases * TAN-1561 Contrib Quarterly Interest in advance - Pro rata 1st and last - smoothed repayment when no pro rata period - 1st pmt incocrrect * TAN-1560 Contrib in advance quarterly interest - 1st payment not calculating correct amount \* 3 * TAN-1552 Arrears does not adjust when penalty fee is reversed on LOC accounts Improvement * TAN-1564 New Parameter for Debtor Interest run to turn script run on and off New Feature * TAN-1559 Function to return LOC amount due based on Repayment Calc specified

Continue reading

Tango32 V4.66 Released

Release notes - Tango - Version 4.66 Bug * TAN-1558 Receipt allocation report shows incorrect holdback accrued in some situations * TAN-1557 Delinquency report fails with invalid column name error * TAN-1554 Interest run may fail with "Duplicate Key" error if it generates debits for Line of Credit accounts * TAN-1553 Interest in Advance - setting the incorrect date as the end of period date * TAN-1549 Incorrect RV for IO interest in Arrears - Contrib mortgages after invitation processing * TAN-1409 Variations ignored by repair schedule for Line of Credit repayment method Improvement * TAN-1550 Adjust dbo.

Continue reading

Tango32 V4.65 Released

Release notes - Tango - Version 4.65 Bug * TAN-1538 Periodic charge not generating subledger history entry

Continue reading

Tango32 V4.64 Released

Release notes - Tango - Version 4.64 Bug * TAN-1547 Fix "Invalid Authorization Specification" when connecting to some databases * TAN-1546 Incorrect Gross Interest showing on IO arrears account * TAN-1544 Loan Activity Report - Option to only Include NEW clients does not appear to be working * TAN-1540 Change VIEW to set Null to 0 for all bit columns * TAN-1539 Calculate_SpecialCharges not taking negative (Credit ODI) into account when calculating total * TAN-1538 Periodic charge not generating subledger history entry * TAN-1537 Cannot reverse loan repayment after several voids * TAN-1534 Payout generating small bad debt transaction * TAN-1528 Incorrect posting dr and cr to suspense causing Balance sheet account balance to different from Investor Account summary Improvement * TAN-1545 Add columns for new unitholding to Insert\_IV\_HeldBatch SP * TAN-1542 Change [dbo].

Continue reading

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