Changes to Tango32. Version 3.94 23 December 2011 * Loans Modified Statement Fee charging option to use the DR GL Account from the Business Code of the loan being charged if the subledger for the fee does not have a DR GL Account. New option on Business Codes to charge ODI as a debit, and to specify a related subledger. New option on Delinquency Reporting System to specify a filter used to calculate totals used as a basis for percentages in the footer of the report. New facility to add Loan Assets via XML from an external system such as Phoenix. New facility to specify up to 5 related clients when adding a new Loan via XML from an external system such as Phoenix. Improved accuracy of projections on the P&I Reduction Report, and Projected Net Balances - especially when a repayment includes a recurring charge such as GST. New "Payway" Export Format for Direct Debit and Credit Card transactions. * Investments Fixed inaccuracy in interest calculations when rolling over an ROI investment account. Fixed inaccuracy in interest projection report. Fixed rounding error in IV Payout Quote Version 3.93 15 November 2011 * Investments Fixed interest balance projection for accounts where interest is paid to investor when due. Fix interest projection report when account starts on the last day of an interest period Modified payout quote on investments where interest is paid to investor rather than being capitalized. The interest credit and interest payment now both show on the payout quote. * Loans Prevent changes to the "Outstanding Balance" field on the "Change Schedule" form. Modified Statement Fee logic to use GL Debit from Business Code if one is not supplied on the subledger. Added a "Do not solicit" flag to clients which can be referenced when generating form letters. Modified system to store the Interest Only term for each hybrid loan rather than extracting this info generically from the Business Code. (This allows hybrid loans in the same business code to have different Interest Only terms. New facility to display Projected Loan Balance based on History to date as well as Projected balance based on Schedule only. Added a new "Subledger Type" table which allows classification of Subledgers for use in reporting. New "Commission Statement" report to display upfront and trailing commissions for each loan per Introducer. Fixed bug in recalculating repayments for Interest Only loans. Modified "Days In Arrears" calculation to include penalty fees. New calculation methods to specify how repayments should be calculated when the interest rate changes on a loan. New logic to Lock the Repayment Schedule of Active Loans, but still allow changes via the "Change Schedule" form. Changed logic on Interest only loans where the repayment schedule must be updated to match interest charges: This will now happen even when the repayment schedule on the account is locked. Version 3.92 30 September 2011 * Loans - Diary Reminders / Tasks A new facility to tick a diary reminder so that it will appear in a new "Task List". New options under the client menu to display "My Tasks" and "All Tasks". * Loan Repayment Schedules Fix bug with due dates for loans that have interest charged on their Anniversary Day when the loan settles on the 30th of the month. * Loan Repayment Calculations Improve accuracy of repayment calculations for large principal amounts (> $1m) * Loan Interest Calculations Fix bug recalculating backdated interest when ODI was charged last interest run and it affects the balance Ensure backdating transactions prior to first interest run generates an adjustment if required * Loan Receipt Allocation Report Improve accuracy of allocation when account is paid ahead but still in arrears due to fees * Loan Delinquency Reports New "Disable" flag to hide old reports from being displayed. New format 12 delinquency report. Fixed bug which didn't show totals on some reports. * Investment Interest Calculations When an investment is paid interest in frequencies other than monthly, ensure investment interest compounds on the last day of the period. * Investment Payouts Investment Payouts now include balances from related sub-accounts. Improve accuracy of payout quote of a sub account when the parent account is complete Added validity check to ensure rollover transactions can't predate the target investment. * Loan Repayments - Variable Rate Fix bug when trying to change repayment schedules one month after settlement. * Loan Subledgers Fix bug which caused excessive transactions when the same subledger is added to a loan more than once. Fix bug which duplicated subledgers when browsing backwards and forwards between loans then clicking on the subledger tab. Version 3.91 11 August 2011 * Loans- Business Codes A new option to specify the number of days after a rate change / interest run to schedule a new repayment calculation when the rate changes. You now have the ability to specify a different number of days for the interest-only and principal portions of a hybrid loan. A new option to preserve any unpaid / overdue entries in the repayment schedule when changing the schedule. A new option to charge all fees as "D" (Debit) transactions instead of "2" (Special Charge) transactions, and to have those debits affect the arrears balance of the loan. The arrears details form will now also show outstanding fee balance for any debit fees applied to a loan. * Loans - ODI Improved the accuracy of Overdue Interest Calculations on accounts where interest is charged on the Anniversary Day where days of grace are specified. * Loans - Repair Schedule Fixed Infinite Lopp Bug, and incorrect allocation of special charges when repairing the schedule of a Line-of-Credit loan. * Completed Loans Report Improved accuracy of report to ensure reversals of paid-in-full accounts net out the outstanding special charge balance on an account. * Loans - Principal / Interest & Projected Balance Improved the accuracy of the Principal / Interest Report, and Projected Balance estimates for Interest Only accounts. Fixed bug which did not take drawdowns into account when calculating a projected net balance. * Loans - Variable Rate / Drawdown Improved the accuracy of repayment re-calculations when varying the rate or applying drawdowns to a loan. * Loans - Receipt Allocation Report Improved the speed and accuracy of the receipt allocation report. * Loans - Extended direct debits Fixed a bug when extending direct debits on accounts past their due-to-complete date, to ensure payments due on the day of the interest run are properly included * Loans - Mortgage Security Add Unit / Lot Number to a security item. * Loans - Repayment Calculations Improved accuracy of repayment calculations for large (> $1m) loans. * Loans - Transaction Entry A new facility in Setup / Parameters / Loan-2 to restrict the transaction types allowed when manually entering transactions. * Investments Improved Accuracy of projected interest charges on the Interest Schedule report. Fixed bug on projected balance calculation which ignored transactions on the account dated after the last interest run. Improved accuracy of Investment Payout Quote to match projected balance. Version 3.90 21 April 2011 * Loans Fix bug with interest rebates not appearing on payout quotes for accounts that had not yet been through an interest run. Improved the accuracy of the "Change Schedule" option for accounts that are already active. New "RepaymentFrequency" parameter when using the API to create new loans. Fixed "Ambiguous column TransactionDate" error on the Receipt Allocation Report Version 3.89 11 April 2011 * Loans New option on subledgers "Include On Receipt Allocation Report" which will treat any transactions for this subledger as Holdback Income on the receipt allocation report. Fixed bug when creating interest only repayment schedules to improve the accuracy of repayment amounts based on the number of days in a month. Fixed inaccuracies in the "Projected Balance" fields on the loan form. Fixed inaccuracies in ODI calculations which were based on the number of days in arrears. Fixed inaccuracies in interest-only calculations on accounts where interest was charged on the anniversary day of the loan. Fixed GL journal inaccuracy when posting a bad debt transaction on a flat cancellation. When posting flat cancellations, prevent "Early Payout Fee" from being charged. Modified Loan Summary Report to optionally include "Security Category". New Report: Fee Reconcilliation Report (Report/ Transactions / Fee Reconcilliation) Version 3.88 11 Feb 2011 * Loans New bank transaction import format "PayWay". New fields on Loan form show projected net balance inclusive and exclusive of current months interest. New options on Business code to calculate new repayment amounts after drawdowns and rate variations based on Projected Net Balance Inclusive and Exclusive of current month interest. The Loan Summary Report now has an option to include both ODI and Special charges on the report. Fixed bug in Transaction Audit Report which mistakenly included reversals of special charges in the "Reversals" section instead of the "Special Charges" section. Version 3.87 3 Feb 2011 * Loans The "Original Term" of a loan is now recorded for historical purposes. New option to add the "Days of Grace" when working out the arrears balance in ODI calculations. New "Discharge Date" and "Discharge Amount" on Loan Securities. Loan LVR calculations now include "Scheduled" LVR which is based on the scheduled (as opposed to current / net) balance of the loan. New logic to allow the calculation for new repayment amounts to be based on the Scheduled (as opposed to current / net) balance when drawing down additional funds from a loan. New function to update the diary reminders when a drawdown affects the repayment amount of a loan. Fixed bug with Loans that move into Inertia which created multiple schedule entries the first time the account moved into inertia. Fixed bug where subledgers that were supposed to be charged in advance were not being charged when a loan activated. New otpion in Setup / Parameters which forces recreation of "chg" entries from Special Charges when repairing accounts. Fixed bug which incorrectly allocated payments against special charges when the account was past its maturity date. Tightened data validation to ensure an interest rate change date does not occur prior to a "Defer Interest Until" date for deferred interest accounts. Version 3.86 16 Dec 2010 * Loans New facility to exclude special charges when generating direct debits. To enable this, go into Setup / Business Codes, and tick the box "Direct Debits Exclude Special Charges". If this option is set at the business code level, it can be disabled for individual loans on the repayment schedule screen by ticking the box "Direct Debits include special charges". Nre facility to exclude Residual Values from inertia processing. To enable this, go into Setup / Business Codes and tick the box "Exclude RV from Inertia". You can also set an option which will only let Payout Transactions be allocated against the Residual Value in the repayment schedule. Normal payments will then not be allocated to the RV. To enable this option tick the box "Only allocate Payouts to RV". New facility in subledgers to charge a subledger in advance. To enable this, go into Setup / Subledgers and tick the box "Charge In ADvance". When ticked, any monthly subledgers will be charged when a loan activates, and then on the day following an end of month interest run. There is now a new report format "11" for the Delinquency System. Drawdowns - fixed bug which reactivated loans incorrectly when a drawdown was posted to the account. ODI - fixed bug which calculated incorrect ODI amount when the system was set to calculate arrears from the day after the due date. Arrears Calculations - fixed bug which incorrectly included fee payments in advance twice when the account was paid in advance. Current / Non-Current Report - fixed bug which showed incorrect calculations when the net balance exceeded the gross balance. Principal and Interest Report - fixed bug which showed incorrect balances for an account with drawdowns. New fields "Risk Grade" and "Risk Rating" are now available on the Clients form. A new optional request / complaint handling module is available which links into the Diary Information on a loan. Introducer Analysis Report - when subtotalling by Classification, now shows Classification Description instead of Classification ID. Insurance Premium Renewal Report now shows individual loan securities rather than one entry per loan. It also shows Title Reference instead of Security Description. Variable Rate Loans have a new repayment calculation method. When the interest rate changes, the new repayment can optionally be calculated based on the Scheduled (instead of Actual) net balance. Hybrid and Interest Only Loans now show the interest only expiry date. This date can be used as the selection criteria for creating bulk form letters. Customer Statements now have a new option to only consolidate payments and special charge payments generated from the same transaction - which effectively hides the splitting of repayments against special charges on the statement. Special Charges - Fixed bug when allocating "Current Month" due amounts before fee balances. Previosuly if the account was due on the first day of the month, the system would mistakenly allocate Next Month as well. Interest Calculations for Anniversary Day Accounts. Fixed calculation error on anniversary day accounts when the due date in the month occurred on a day that didn't exist in the previous month (e.g. calculating interest on 30 March when interest last month was calculated on 27 Feb). Loan Securities now show a "Scheduled LVR" as well as "Original" and "Current". * Investments / Other Accounts New option in Transaction Types to specify whether a particular transaction includes GST for use on RCT Invoices. Version 3.85 26 Oct 2010 * Loans The security log will now be updated if someone changes the "Hold Processing" status of a loan. Fixed a bug which caused monthly fees to be charged on accounts that had a settlement date after the date of the interest run. New import format for CBA "Direct Entry Dishonnor" (MA23) format files. Improved the narrative on interest payments to linked mortgagees. When entering a loan via the wizard, if you switch from an Interest-Only to a non-Interest-Only business code, the system will ask if you want to zero out the "Residual / Balloon" field. Previously this field was left untouched which sometimes caused data entry errors when users didn't realize that a value was still in that field. Version 3.84 18 Oct 2010 * Loans - Interest In Advance If a business code is configured to have "Interest In Advance" loans, the interest cycle logic has been changed so that the cycle starts on the due date for the current repayment, and ends on the day prior to the due date for the next repayment. Fixed inaccuracies when interest in advance was charged on a common day. * Loans - Variable Rate There are new form letter fields to record the details of the most recent interest rate change, to assist in creating correspondence about interest rate changes: RateChangeDateEntered - The date the rate change was entered into the system RateChangeOldRepayment - The repayment amount before the new rate was applied RateChangeOldRate - The interest rate before the new rate was applied. RateChangeNewRateDate - The date the new rate applies from. RateChangeNewRate - The new interest rate RateChangeNewRepayment - The repayment amount after the new rate is applied. RateChangeNewRepaymentDate - - The date the next repayment amount is due When varying the rate on a loan there is a new option on the business code to specify the number of days that must transpire after the rate change before repayment amounts due should be adjusted. There is now a facility to print form letters for a group of loans based on the date that their interest rate was changed. * Loans - Projected Balance The "Balance" tab of the loans form now also shows the "Projected Balance" of the loan which is the balance it would have if loan repayments were made as contracted. Fixed infinite loop when projecting the net balance on interest in arrears loans that were charged interest on the anniversary day instead of the last day of the month. * Loans - Principal and Interest Report This report has been enhaced to include drawdowns. * Loans - Extending Direct Debits Business codes have an option to "Continue direct debits on maturiing loans when they are in arrears". This option has been fixed to use a more reliable repayment amount and frequency for the continuation. Previously an incorrect repayment amount would be used in some situations. * Loan Summary Report Fixed bug which doubled up outstanding fees on loan summary report when the system was configured to treat special charges and ODI like debits. * Manual interest When manual interest is posted to an "Interest In Advance" account, this will no longer affect any subsequent interest calculations provided the manual interest transaction is prior to the next due date. * Investments Fixed bug which incorrectly added one day to the start date of an investment when it was rolled into a new investment at maturity. Improved consistency of transaction Narratives when rolling over an investment. New facility to calculate commissions on investments based on an interest rate margin. * Linked Mortgages Any ODI charged on a linked mortgage can now be included in payments made to investors. New facility to specify that funds are on a linked mortgage "cleared" when entered into the system to prevent the subsequent "clearing days" delay that normally applies before investors are paid. * Joint Account Indicators Fixed bug in the Experian "Joint Account Indicator" which incorrectly marked both borrowers as the "first borrower" in some cases. Added a new GetJointAccountIndicator() function to more reliably retrieve the indicator value. * Overdue Interest Fix overstating of ODI when a dishonor is entered on the first day of the month and arrears is set to calculate from the day after the due date, when ODI is calculated using daily arrears balance. Version 3.83 5 August 2010 * Loans There is an option to allow loans to have interest charged to the account on the anniversary day of the loan rather than the last day of the month. This version ensures that interest charges will be charged on the correct day for interest-in-advance loans. New subledger option for subledgers that are charged when a loan completes to only charge the subledger for writeoff transactions instead of for all loan-completion transactions such as payouts. Minor adjustment to the layout of the credit card export data for "Secure Pay" Fix bug with the anniversary day flag when creating new payments due after a drawdown. There is now a new "Line of Credit" caclculation method which allows you to set a "Minimum repayment amount" and a "Percentage of balance" which must be repaid each month. Fix bug which charged extra interest on a loan with "simple interest" calculation methods, when the loan was paid out n the dat that interest was due to be paid. Loan Data-Entry Templates now have a "Data Source" which allows you to specify where a value can be copied from to save the user having to enter it into a template. When using the API to insert drawdown transactions, the system will use the default transaction-subtype if it is enabled for a particular subtype. When processing an interest run at the end of the month, the system will also process any loans that were supposed to be charged interest on their anniversary day, if that day occured prior to the end of the month, and interest had not yet been charged. Fixed bug which set incorrect repayment frequency when extending repayment variations at the end of term of loans which were still in arrears. Fixed bug with Principal / Interest report with arithmetic overflow error when projecting future balances on accounts with large gaps in repayment schedule. Fixed bug with displaying and allowing changes to classification codes on the loan form. * Investments Fixed bug which occasionally set the wrong balance of an investment when it was rolled over into an existing account. Version 3.82 25 June 2010 * Loans Fixed the "Invalid use of Null" error when displaying the repayment tab of a loan. Consumer Credit Payout Quotes now include subledgers charged at the completion of a loan. All payout quotes will ignore subledgers charged at completion of the Start / Stop month settings prevent that subledger being charged. Version 3.81 24 June 2010 * Loans When defining drawdown types, there are new options to: 1. Allow new payments due share the same anniversary day as prior payments. 2. Post a rebate transaction to account for any new unearned income added to the account as a result of the additional payments. Drawdowns enhanced to generate a repayment schedule for any loans that don't have them at the time the drawdown is posted. Form Letters. New merge fields: 1. <> shows the total value of drawdown transactions on the account since the account was opened. 2. <> shows the total amount outstanding on the account but ensures this amount will not exceed any payout quote. New dynamic text facility. (See Setup / System Tables / Messages) This lets you dynamically control the content (and color) of some messages that are displayed on the loan form for such things as: 1. Variation Information 2. Interest Free repayment info 3. Altered direct debit and credit card information New facility to prevent changes on active loans for Repayment Amounts Due or the Gross Interest. Previously these items were both locked. Now either of them can be locked without locking the other. Direct Debits. Fixed bug which treated an account as being complete if it had been completed then re-activated by a drawdown. Subledgers: 1. enhanced the "Start Term" and "Stop Term" settings to apply to subledgers based on the repayment amount of a loan. 2. Added a new "V" calculation method based on a percentage of the total amount advanced. 3. "At completion" subledgers will be included in any payout quotes for loans that have them. Loan Activity Report. Optimized this report to iomprove performance. Classification Codes: 1. New facility to create a hierarchy of classification codes. (See setup / System Tables / Classification1,2,3,4) 2. New facility to disable classification codes so they may not be used when entering new loans. On the Loan form: 1. there is now a new "Total Advanced" field showing total drawdowns plus original amount advanced. 2. The "Arrears Details" subform now also shows the current payout quote for the loan as well. Payout Quotes. Fixed bug when requesting a "Monthly Interest" type payout quote. (Implicit conversion from data type datetime to int is not allowed) * Investment System New facility to rollover an existing investment into another existing investment account. Version 3.80 18 May 2010 * Loans New facility for drawdowns to re-activate completed loans, and remove any completed entries from the repayment schedule. Fix bug which showed incorrect arrears on loans which had been re-activated by a drawdown. New facility to set a particular type of drawdown as the default type to use when entering a drawdown transaction. Fixed infinite loop bug when posting drawdown transactions on interest in advance loans with non-monthly interest periods. The "Import from table" facility now includes the option to add a value for the "General Purpose 2" field. Fixed "SET OPTIONS HAVE CHANGED" cursor bug when creating a loan summary report on a SQL 2005 database. Fixed calculation for number of days in arrears when a payment is partially paid. Fixed bug in calculating the interest component of the arrears balance. Previously payments in advance were incorrectly allocated to interest in advance. Loan Activity Report now includes loans that were reactivated by Drawdown transactions. Payout Quotes done via form letter will now include any drawdowns as part of the payout quote calculation. For interest deferred loans the repayment schedule now shows an additional information about the minimum monthly repayment necessary to pay the loan out during the interest free period. Fixed "type mismatch" error when re-creating automated credit card transactions in some circumstances. Version 3.79 1 April 2010 * Loans Fixed bug which prevented upfront interest charges on accounts with "Interest in Advance" business codes. Fixed bug which generated incorrect GL Journals for Interest Charges on loans with Net Effective Interest Calculation Methods. Version 3.78 30 March 2010 * Loans New "Minimum ODI Charge" on business codes. If the ODI amount is less then this amount then it is either waived or set to the minimum amount depending on which option you select on the business code. Discounted Present Value payouts were slightly underestimating the amount due when a payout was not done up to the loan anniversary date. Fixed the Unearned Income column on the Completed Loans report to show a negative amount if a loan payout was reversed. Fixed error handling when importing loans via XML for several loans at once. Modified system so that when Voiding transactions that include interest the last interest run date will be recaculated. Fixed errors in gross interest calculation for active loans when adjusting schedule. Fix logic for extending loan term when posting type 3 drawdowns. New facility to restric transactions imported from a bank import file based on whatever branches the user is authorized to. Fixed NAB import to not truncate account#'s to 8 characters. * Investments Fixed bug which caused incorrect GL journals when paying out an investment that still had uncredited interest transactions. * Importing Added "GeneralPurpose7" to the Loan Import XML Schema. Version 3.77 22 Feb 2010 * Loans New "Transaction Sub-Type" facility which lets you categorize standard transactions into different sub-types for administratoive purposes. Drawdowns may now be split into various types with different processing options such as: - How to extend the repayment schedule as a result of the drawdown. - Whether or not to take interest into account when calculating new repayment amounts. - How many days should elapse between the drawdown and the next repayment - whether or not a drawdown should be able to re-activate a previously completed loan. To manage subtypes, see Setup / System Tables / Transaction Subtypes New facility to allow net-effective P&I loans to have interest rate variations. To enable this option, see Setup / Parameters / Loan-2 and tick the option "Display Interest Schedule for Net Effective Loans" New facility to allow interest rate changes mid-month. If the interest rate on a loan is scheduled to change mid-month, the end-of-month interest run will take this into account and calculate the correct interest charge. Prior to this, you had to do two interest runs - one mid-month and one at the end of the month. With this enhancement, only one end-of-month interest run is required. Fixed bug in "User 1" format statements which showed incorrect YTD debit and credit totals. Version 3.76 10 Feb 2010 * Investments / Creditors Fixed bug on Investment Statements which showed incorrect totals when printing the statement as a Recipient Created Tax Invoice. * Loans New "Checklist" facility for loans. Checklists are a simple way to implement work flow control on loans. A variety of different Checklists can be created via Setup / System Tables / Checklists. The is a new Checklist tab on the loans form where you can add as many check lists as you like. If you prefer to use another word instead of "Checklist" go to Setup / Parameters / Custom Labels / "Checklist Description" You can specify a default Checklist to be added to a loan by setting the "Checklist" on the Business Code. New Securepay Creditcard export facility. This is two parts: 1. The One-time upload data for Creditcard numbers is generated via Development / Export / Export Securepay Data 2. After generating a batch of credit card direct debits, export the batch using the "Securepay Credit Card" file format. New facility to summarize loan transactions before posting. Enable this option by ticking the Setup / Parameters / Loan-2 / "Summarize Loan Postings Where Possible" checkbox. When enabled, any transactions with the same date, type, reference and narrative will be added together into one transaction before being posted to a loan. Version 3.75 19 Jan 2010 * Loans Added a new "Checklist" tab to loans. You can set up a variety of different check lists via Setup / Checklists. You can rename "Checklist" to something more meaningful for you via Setup / Parameters / Custom Labels. Added a new facility to import the "General Purpose 7" field via the "Insert_FM_Loans" and "Update_From_XML" stored procedures. Modified the Experian Export facility to exclude any loans that don't match the selected branch list. Modified the Completed Loans / Paid In Full reports to show negative Amount Financed and Unearned Income figures for reversals. Modified Customer Statements to fix bug which showed wrong arrears amount when hiding negative arrears on accounts in advance. Version 3.74 16 Dec 2009 * Loans New setup option to allow display of Interest Schedule on net effective loans. See Setup / Parameters / Loan-2 New option on repayment overides to allow override to run concurrently with standard repayments. New Merchant Fee subledger ID for Credit Card Types. This allows you to charge a merchant fee when collecting repayments via credit card, and allows different merchant fees depending on the type of credit card. Enhanced API "Insert_FM_HeldBatches" to allow insertion of drawdown transactions. Modified payout quotes to ignore outstanding GST special charges on payouts that include GST. Version 3.73 13 November 2009 * Loans Fixed OLE error when trying to add new business codes without creditor or template. Fix NULL parameter error in Insert_FM_Loans Stored Procedure Version 3.72 11 November 2009 * Investments Fix bug with concurrency issues on Investment Rollovers which caused outdated amounts to be posted when rolling over an investment when two difference users tried to rollover the same investment simultaneously. Ensure the correct interest frequency is used when rolling over investments * Loans Modified "Process New Loans" to not use "Advance" GL bank account for posting payments/payouts at activation time. New "User1" format for customer statements. Column headings can be altered via the "Headings" button that appears on the statement prompt when you select "User1" statement formats. Fix Loan Import routine when importing data into a European database. New facility to set a second interest rate and start date to loans when adding them via the Stored Procedure and XML interface. Version 3.71 28 October 2009 * Loans Fix bug where GST was being included inconsistently in payout quotes. New subledger calculation methods / options: Percentage of monthly interest - Option to include current month interest - option to subtract an amount from the current months interest and use the amount remaining Percentage of net balance - Option to include interest based on the number of days in the current interest period. Fixed bug in inertia calculations where accounts had a residual value / baloon payment. Business Codes now have an optional "GL Advance Bank Account" which lets you specify a different bank account for disbursements as opposed to using the same Bank Account for Receipts. * Direct Debits - New option to ignore residual values when generating direct debits. * Current / Non-Current Report - Added an extra ageing period to the report. * Form Letters When creating multiple form letters, there is now a new option to exclude accounts based on the oldest amount due. This is useful when you want to select accounts that are X days in arrears, but you don't want to include any accounts where the oldest amount due is only a few dollars. E.g. "Select accounts that are 90 days in arrears, but exclude accounts where the 90 day arrears amount is less than $10". New keyword "NumberPaymentsRemainingFromAsatDate" which shows the number of payments remaining on or after the "As At" date of the form letter. * Cheque Cashing New facility to enter a "Cash" and "EFT" amount when cashing a cheque. New options on Cheque Cashing business codes to specify "Cash" and "EFT" subledgers. * Assets Fixed bug which prevented depreciation from being charged on accounts that did not have an opening balance for depreciation entered. Now, if there is no opening balance for depreciation, the system will use the purchase price of the loan. * Delinquency Reporting New Delinquency Report - "Format 10" which includes next scheduled payment date and amount. * Transaction Audit. Added "Date Posted" to Transaction Audit Report. * Investments Added new fields for IssueDescription and SeriesDescription Fixed interest calculation rounding error when rolling over investments. Version 3.70 18 September 2009 * Loans New option to exclude advance payments of special charges from arrears calculations when an account is already in advance. To enable this, tick the box "Arrears Ignore Special Payments In Advance" in Setup / Parameters / Loans-1. Include "Total Financed" in totals on the Loan Summary Report. Modified security system to ensure any changes to "date due" in the repayment schedule get logged in the security log. Version 3.69 10 September 2009 * Loans New facility to add hourly rate to Action Codes New facility to add Billable Time and Rate to Diary Reminders New facility to manage loans where interest is paid in advance. Fixed bug when doing a payout quote based on Discounted Present Value of paynments. Previously if GST was payable on the repayments, this was not being included in the quote. New transaction type (K) "Credit Payment", reduces the balance of an account without affecting arrears, and appears with standard payments for auditing purposes. Useful for recording receipt from proceeds of sale, or government rebate. * Investments When an Investment Account is rolled Over it will now inherit the interest frequency of its business code. New Formletter fields: IssueDescription - A description of the currently selected investment issue. SeriesDescription - A description of the currently selected investment series. SelectedBankBSB - The BSB of the currently selected bank account. SelectedBankAccountNumber - The Account Number of the currently selected bank account. Version 3.68 4 Aug 2009 * Loans New ODI Charge method "C" - Charge ODI Based on the net balance of the loan using an interest rate plus margin, only for the period of the month for which the account is in arrears. This differs from the existing "B" method which charges ODI based on the net balance of the loan using interest rate plus margin for the entire month that an account is in arrears. Business Codes now have "First Payment Offset Months" and "Defer Interest Months" settins which let you specify a default number of months to defer the first payment and/or interest start date. This makes it easier when entering loans via the wizard where you would normally need to specify a date when the first payment falls due, or when interest should be deferred until. Business Codes now have a new facility to Schedule Special Charge repayments to the maturity date of the loan where those charges have been charged AFTER the maturity date of the loan. This only applies if the loan is already past its maturity date when the charge is applied. Otherwise, if the loan has not yet matured and a special charge is entered, the payment will be scheduled as at the date of the charge. Data Entry Templates now have a new facility to specify whether or not to copy the gross amount from the previous line. This is useful where you have more than one subledger based on the same gross amount. Data Entry Templates now have a new "Overflow" facility where you can specify the maximum value for a subledger, with the remainder being added into the next subledger. The "Name on Title" field on loan security has had its maximum length increased to 250 characters. Fixed bug with interest calculations where an interest only account paid out in its first month. Fixed bug which reduced direct debits to zero for accounts whose direct debits were supposed to extend past the maturity date of loans in arrears. New setup option to allows you to enter payouts and other payment transactions in the same batch. When posting, payout transactions will then be separated into their own batch. Modified holdback calcs to take into account min/max term of subledger. Management Reportables Report now allows restriction of diary notes by action code. Fix bug with flat cancelling loans with subledgers linked to creditors when "Use Credt" is specified on the subledger. Improved accuracy of the yield / comparison rate calculations. * General Ledger New facility to Copy Report definitions from another database. * Investments Fixed bug where accounts that parially rolled over into a new account direct credited the wrong amount remaining to the investor. * Form Letters New keywords: ArrearsBalance (Arrears backdated to the date of the form letter) ArrearsBalancePositive (Only shows arrears balance if positive) ArrearsBalanceNegative (Only shows arrears balance if negative / in advance) DaysInArrears (Number of days an account is in arrearS) DaysInArrearsPositive (Only shows days in arrears if positive) DaysInArrearsNegative (Only shows days in arrears if negative / in advance) Version 3.67 2 July 2009 * Loans New facility to calculate a Loan Comparison Rate which complies with Australian Government Consumer Credit regulations. To enable this facility for a particular business code, edit the business code and tick "Use UCCC Comparison Rates". New facility to enter a drawdown transaction against an account, and have the system automatically generate a repayment schedule entry X days after the drawdown for the full amount. To specify the number of days after the drawdown, edit the business code and put a number of days in the box "Days after drawdown to schedule payment in full (blank for not at all)"/ NOTE this facility is only available if "Drawdowns affect repayment amounts" is ticked. Fixed bug in repayment calculations when a drawdown is entered against an account. If the system is configured to alter the remaining repayments on a loan when a drawdown is posted, there was a bug which calculated the repayment amount based on the original term of the loan rather than the remaining term. New Import Format for adding loans and clients to Tango via CSV ile. Fixed bug which caused "Invalid use of NULL" error when viewing security details of a loan with a credit limit. Altered layout of "Net2" format on Customer Statements to better fit in a window-faced envelope. * Investments Fixed bug which caused "Open Form Action Cancelled" error when entering rollovers during an investment payout. * General Ledger Fixed bug which incorrectly included year end appropriation journals twice when calculating last year balances on P&L accounts. Version 3.66 25 June 2009 * Loans Fix bug where net balance was displayed instead of arrears balance in some circumstances. Version 3.65 25 June 2009 * Investments Improved the accuracy of investment payouts so that they no longer include unpaid interest in the capital balance when calculating the final interest credit during a payout. Improved the investment rollover procedure. When rolling over an investment the system will show you exactly what transactions will be generated in the new account. * Loans Improved performance when matching payouts and writeoffs with reversals. New facility to cancel standard direct debits once a variation expires. See the direct debit variation screen for info. Whenver a drawdown (R) transaction is posted the system will now update the TotalDrawdowns balance. Fixed arrears calculations which (in some unusual circumstances) would show an arrears balance even after an account was no longer active. Improved delinquency reports (Management Reportables) to allow inclusion of current month arrears when deciding which accounts to include on the report. For line of credit loans, if a "Credit Limit" is entered on the Security tab of a loan, the system will also show "Remaining Limit". Version 3.64 5 June 2009 * Loans Bank Accounts - New interface to make it easier to add and change bank accounts. Loan Deletion - you now receive a warning if you try to delete a loan that has attached securities. Customer Statements - New Facility to exclude completed accounts that did not complete via a normal payout transaction. This lets you exclude flat cancels, writeoffs, etc from the output. Create Multiple Form Letters - New facility to exclude accounts that don't have a value in "Postal Address 1" of the address. New "Quick Quote" facility allows you to generate a fast loan quote based on several parameters. Added New Mergefield for formletters: AccountWithCheckDigit2 This represents the current account numnber, stripped of its last digit, with a check digit appended to this. It is useful for making BPAY payments from to an account whose Account# is based on a prior account#. New database function GetPresentValue to make it easier to write ad-hoc queries which may need the ability to calculate the present value of a payment. Fixed inaccuracies in the Rule of 78 Rebate Calculation. Modified Loan Summary Report to clear out any outstanding special charges from the balance of a loan that has completed. Modified Paid In Full and Loan Activity Reports to allow sorting / grouping by Loan Status Modified Interface with Experian Italy to not show a delinquency status for any borrowers affected by Earthquake in L'Aquilla province. * Investments Two new options in Setup / Parameters / General: "Rollover Investments on Same Day as Payout" "New Rollover Account#'s are original Account# with Suffix" These let you control how a rollover of an investment is handled. The rollover screen now allows you to specify the start date of the new account. Version 3.62 18 May 2009 * Loans Fixed bug in Interest Calculations for Payouts and Payout Quotes on interest-only accounts where interest is charged less frequently than monthly. * General Ledger New option to display statements for credit accounts with credit balances as either negative or positive. Version 3.61 8 May 2009 * Loans Fix bug with "Classification 5" selection logic which showed wrong classification code at times. Fix bug with repayment variations which cancelled direct debits after they expired, but should not have. Fixed infinite loop in monthly interest run when changes to repayment schedules were locked but accounts had Inertia enabled. * Assets Modified Asset Register to show organization name where appropriate Fix bug which excluded nonheld accounts when including held accounts on asset register Fix bug which calculated incorrect p/l on sale of asset journals when asset details weren't entered in the asset table. * Investents Fixed utility which clears the balances of completed investment accounts. Version 3.60 9 April 2009 * Word / Office 2007 Tango is now aware of Word / Office 2007 and will use Word 2007 to print form letters if it's installed. * Loan Transactions Fixed an intermittent problem which sometimes caused the "TotalRepayments" field to be blank for some accounts even when payments had been received. * Interest / Yield Rate Calculations Improved Accuracy of Interest and Yield Rate calculations based on repayment amounts. * Statements Fixed error "Invalid Column Name 'ThreadID'" when printing a customer statement using consolidation. Version 3.59 8 April 2009 * Investment System Fixed small balance issue when completing an investment. * Loans New "Classification 5" field which allows you to automatically classify a loan based on a set of conditions. Version 3.58 3 April 2009 * Investment System Fixed error printing Investor form letters Version 3.57 3 April 2009 * Added "Date Traded" column for Investment Accounts. The prompt for this column can be changed via Setup / Parameters / "Custom Labels 2" / "Date Traded". If you enter a value for this date on an account, it will appear on the investment statement. * LVR Calculations Improved Accuracy of LVR calculations. * Discounted Present Value Payout Quotes Improved accuracy of this method by excluding fees when calculating the DPV. (Fees are added after the calculation of the DPV) * Asset Register Fixed bug which prevented the account with the largest alphabetic account# from displaying on the report when the length of the account# was longer than 8 characters. * Delinquency New "Management Reportables #3" report, is identical to "Management Reportables #2" except that it uses the number of days in arrears rather than the Recency Date. * Form Letters New formletter fields which are based on what the payout figure of a loan would be if it matured sometime in the next 30 days. ODIToMaturity InterestToMaturity TotalPayoutMaturity TotalPayoutPlusETPMaturity ODIPlusInterestMaturity PayoutSubTotalMaturity TotalPayoutBalanceDueMaturity * Investment Rollovers Fixed bug which set an incorrect "First Interest Payment Date" when rolling over an account which ended on the last day of the month. * Void Transactions Improved the performance of processing Void transactions. Void transactions no longer appear on customer statements unless you explicitly request them via page 2 of the statement options screen. * Interest Rate Calculation New option on Business Codes to allow you to specify the repayment amount and have the system calculate the appropriate interest rate. To enable this option, check the "Calculate Interest Rate In Wizard" option on the repayments tab of the business code. The wizard will operate as usual, but after you enter the repayment amounts, it will calculate the appropriate interest rate and ask you if the account should be set to this rate. * Loan Summary Report Security Information can now be displayed on all versions of the Loan Summary Report. Version 3.56 17 March 2009 * General Ledger New option to allow Report writer to enahce readability of reports by chosing the sign to use when printing balances of debit and credit accounts. * Clients New option to specify whether or not system should auto update the name of a person or the contact of an organization when user changes the given names or surname of a client * Loans New option on Business Codes to disable arrears calculations for certain accounts to improve performance. * Subledgers The "Use Credit" option on a subledger will now also apply to "monthly % of repayment" transactions paid to creditors. * Linked Investments Fixed bug which failed to pay management fees to an management account with no investment amount. * Investments New keywords for form letters: IssueDescription SeriesDescription * Delinquency Reports Added a new format for delinquency reporting. There are now 9 different formats. Version 3.55 23 Feb 2009 * Loans New facility to charge interest on the Anniversary Day of a variable rate loan. To use this facility, edit the details of a variable rate business code and tick the box "Allow Anniversary Day Interest Run" on the interest tab. This will then make the option available on the Processing / "Monthly Interest Run" screen. * Yield Rates Improved the accuracy of the yield rate calculations for loans. * Loan Summary Report New option to show Security Information on the report. * Import from IBS Fix bug which created extra RV entry in the payment schedule for leases. * Linked investments Fixed bugs in payment of mortgage interest to linked investors Version 3.54 3 Feb 2009 * Performance Added new indexes to database to improve search performance on Loan Transaction table. * Loan Summary Report New option to exclude backdated transactions when calculating the balances for the report. When this option is selected and you run the report as at a particular date, the report will ignore any transactions ENTERED after that date, even though they might be DATED on or before that date. * Investments Improved accurace of utility which closes off balances on completed accounts with no maturity date. * ODI Fixed calculation of 'B' type ODI (based on daily net balance) to charge ODI if the account was in arrears at any time during the period, not just at the end of the period. * Loan Statements New option to print statements for accounts that completed during a specific period. New option to display email and web address in company header on statements. Version 3.53 7 January 2009 * TangoWeb New "Data Extracts" facility that lets web users extract data via ad-hoc queries. * Investments Modified Investment Summary Report to not select any accounts that started after the asat date. * Form Letters Fix Anniversary ordinal dates subtract HOLD and IFEE from PurchasePriceLessEstDDFee form letter field. * Delinquency Management Reportables Added an optional new report format showing more info. * Experian Export Fix problem with negative repayments getting in data * First Payment Default Reports Fix bug with some accounts not appearing on report properly. Version 3.52 2 December 2008 * Interest Rates The ability to schedule a future interest rate change date when changing rates on variable loans. A diary reminder is created when an interest rate change is SCHEDULED. A diary reminder is also created after the interest rate is actually changed. * Loan Payout Fixed bug which caused incorrect GL Journals to be created if you did not specify an ODI Accrual Account on a Business Code. * Investments / Other Accounts. Client bank accounts may have a "Type". If you tag a bank account with a "Type" you can then specify that when paying a creditor or investor that only bank accounts of that type should be used. This gives you a more flexible way of paying money into different bank accounts for the same creditor without having to manually change the bank account of the creditor. * General Function for ad-hoc queries: GetInterestRateOnDate - improved performance. Function for ad-hoc queries: GetIdentificationValue(@LoanAccountNumber, @IdentificationMethod) given a loan and identifcation method, return identification value for that loan. Function for ad-hoc queries: GetRepaymentDue(@LoanAccountNumber, @AsAtDate) returns the payment amount due for a loan as at a particular date. * Form Letters New fields to extract identification methods for a client for use in a form letter: ID_ReferenceName1, ID_ReferenceName2, ID_ReferenceName3, ID_RefAddress1, ID_RefAddress2, ID_RefAddress3, ID_RefPhone1, ID_RefPhone2, ID_RefPhone3, ID_Relationship1, ID_Relationship2, ID_Relationship3 * ODI fix bug with ODI when arrears is calculated from the day after the payment is due and a payment dishonors on the date of the last interest run. * Ad-Hoc queries New facility to specify a column separator character other than a comma. This will mean that the output may not be viewable via Excel, but it is helpful when trying to use ad-hoc queries to do data exports / extracts. Version 3.51 17 November 2008 * Investments New "Anticipated Maximum Investment" field which lets you specify the maximum balance you expect an investment to achieve. This balance is used as a check when allocating investments against a mortgage. * Loan Security New checkbox to specify whether an particular item should be included in the Group LVR for a borrower. New screen layout to show the LVR percentages for loan securty items. * Form Letters Modify form letters to allow the inclusion of LVR percentages. Modufy form letters to allow the inclusion the the last six diary reminder notes. * Reports New "Projected Liquidations" report. New "Projected Interest Income" report. Both new reports on the "Reports" / "Income" menu. * Assets. Fix bug caused when paying out a lease that had assets, and the payout was then reversed and re-entered. * Creditors New facility to allow for a number of days for funds to clear when paying creditors. * Banking Interface Minor modification to the Westpac NZ Credit card interface. * Loan Customer Statements New facility to change the font and size of notes entered in statement footers. * Diary Reminders New facility in Setup / Parameters to specify whether or not some diary reminder fields should be mandatory. * Linked Investments New facility to specify that loans may be linked directly to a set of investment accounts for funding and payment of interest. Version 3.49 8 October 2008 * Form Letters New keywords: NextDirectDebitAmount NextDirectDebitDate ListSixDiaryReminders Security_Description, Security_MortgageNumber, Security_NameOnTitle, Security_TitleReference, Security_Category, Security_Type, Security_IsPrimary, Security_ValuationDate, Security_MarketValue, Security_Encumberance, Security_Address, Security_PolicyRenewal, Security_Insurer, Security_PolicyNumber, DailyInterestCharge * Schedule of borrowings Fixed bug to ensure schedule reflects balances and number of accounts as they were on the "AS AT" date. Version 3.48 24 September 2008 * Loan Security Added a new facility to specify that a particular securty is the "primary securty" for a loan. * Loans New facility on business codes to specify an "Account Prefix" which is used when generating new Account#'s in the wizard. * Loan Statements New facility to specify that any statement messages you enter should be used for all users. Prior to this, the messages you entered only applied to your session and no one elses. New Keywords for use in statement messages: &!PayoutQuote& - The payout quote figure for the account as at the "To Date" of the statement. &!OutstandingCharges& - Total fees and ODI charged to the account but not yet paid. &!CurrentMonthInterest& - Total interest charged to the account during the month of the "To Date" of the statement. * Form Letters New keywords which relate to the first primary security of a loan: Security_Description, Security_NameOnTitle, Security_TitleReference, Security_Category, Security_Type, Security_IsPrimary, Security_ValuationDate, Security_MarketValue, Security_Encumberance, Security_Address * Residual Values Add better intelligence to function which identifies the RV in a repayment schedule Fix the way inertia loans are extended when they have an RV Fix repair schedule so if an RV and a repayment are due on the same day, the RV gets paid last. Fix transaction posting so if an RV and a repayment are due on the same day, the RV gets paid last. * Repayment variations. Fixed "Domain Error" message that occurred sometimes when the system was configured to automatically extend the repayment variation of a loan with an outstanding balance past maturity. * Export payments to electronic banking Fix formatting of WBCNZ Credit Card Export. Fix truncate of lodgement ref on aba exports. * Gross Balance on Loans Fix problem with backdating gross balance in loan summary report when including fees in the gross balance. Fix problem with backdating gross balance on completed loans. * General Ledger The value of all journals to the GL will be truncated to have no more than two decimal places. * Subledgers Fixed bug which prevented using "%" types as part of a monthly accrual subledger pair. Fixed 'out by one' error on % subledgers forced to have even amounts. * Investment / Creditor Statements New facility to print a creditor statement as a Recipient Created Tax Invoice. Version 3.47 1 September 2008 * Loan Payout Transactions When posting payout transactions, fixed bug which caused the error: "insert statement conflicted with COLUMN FOEIGN KEY contstraint" Version 3.46 28 August 2008 * Principal & Interest Report Modified report to correctly handle upfront fees on accounts where ODI and Special Charges behave like debits. * Asset Register Report Increased the width of the Account# column to show all characters in the Account# * Receipt Allocation Report New option on the report to allocate payments against the holdback subledger before paying interest and principal. Previously the report would only allocate against Interest first. * Investment Reporting Improved general performance of investment reports. * Form Letters Modified system to be able to charge fees on form letters and at the same time leave the GL Debit account of the fee blank so that the Receivables Account from the Business Code can be used instead. * Security Enhancements You can now enter multiple security items against a loan. Each security item can be used as security on a number of different loans. The layout of the "Security" tab on the Loans form has been enhanced to enable multiple security itemss. * Experian Reporting Fixed Zero Divide error on loans with a term of only one month. * Repayment Calculations New facility to ensure that a subledger will affect the repayment calculations of loan regardless of its type. * Credit Cards New facility to deduct repayments via credit card using Westpac NZ. * Assets Enhanced system to automatically dispose of assets on paid out accounts of any type - not just tax based accounts. * Investments / Other Accounts New facility to exclude zero balance accounts from the "Other Accounts" / "Account Summary" report. * GL Report Writer Modified Report Writer to ensure GL Accounts appear in account# sequence within their reporting detail group on GL reports. * Investments Fixed bug in Investment Projected Interest report which was incorrectly excluding past-period interest from the report. Version 3.45 7 August 2008 * OVerdue Interest New facility to alter the narrative of overdue interest transactions as they appear on the customer statements. You can set the narrative for these transactions via Setup / Parameters / "Interest Charges". Fixed bug in ODI calculations which charged ODI on accounts that were in advance but had not made a payment in the current month. * Variable Rate Loans New facility to specify how to recalculate the new repayment amount when varying the interest rate on a loan. On each business code, if the loan is variable rate, you can specify how to calculate the repayment amounts when the loan is in arrears, advance, or up to date. New facility to adjust the amounts paid on the repayment schedule after varying the rate on variable loans. To enable this facility, go to the "Interest" tab on a variable rate Business Code * Redraws Fixed bug in redraw ("W") transactions which generated incorrect GL journals. * P&I Report Enhanced report to take into account rate changes on variable loans. * Arrears Fixed bug which incorrectly calculated arrears on accounts where ODI and Special Charges behaved like debits but did not affect the schedule. In this situation, special charges and their payments should not affect the arrears balance but they were. * Investment Rollovers Fixed Foreign Key violation problem when rolling over investments that had no Series ID or Issue ID. * Form Letters Fixed "Type Mismatch" error when printing multiple form letters. Version 3.44 25 July 2008 * Banking The "MAV" payment method now has a custom label attached to so you can rename it to be any new method you like. Alter the label via Setup / Parameters / Custom Labels-2. The Check Digit calculation method can now be varied using parameters in the "BPAY Check digits" section on Setup / Parameters / Loan2 * Interest New [ + / - ] button which lets you vary the interest rates on all loans in a business code by a set percentage rather than changing them all to the same new rate. This way if you have several loans in a business code with slightly different rates, you can alter those rates by the same amount. * Form Letters New "FormattedPostalAddress" keyword, which lets you show a postal address in one block without any blank lines in it. New option on a form letter "Do Not Prompt For Fee" which lets you charge a fee when printing a form letter without having to ask the user whether or not to charge the fee. * BPAY Fixed "times 100" problem when importing transaction amounts from the CBA BPAY import file. * Loan Payouts Fixed bug which caused interest calculation inaccuracies if a payout was reversed, and interest calculated after the event. The Transaction Entry screen will now prompt you whether or not to charge a payout fee if you enter a payment (not a payout) which might subsequently pay the account out. * Investments Fix bug in interest calculations on investemtns which start, and then have the "Open Investment" transaction reversed and re-entered on a later date. * Inserting Clients New keywords on the "Insert_FM_Clients" stored proc: @PhoneNumber5 @NetAssets * Experian UK. New logic to exclude loans that are active, held and excluded. Version 3.43 4 July 2008 ************************ * Investments Interest Projection Table - updated to correctly include compounded interest payments Where account#'s have a prefix and leading zeroes, allow searching by the account# without the prefix and leading zeroes. So for account H00001234 you can also search for this as account 1234. Eased the restriction on "Duplicate Account#" to allow duplicates in order to group accounts. Fixed bug in Rollover logic to ensure all data entered in the rollover process gets copied to the new account. Statements of accounts with ROI Sub-accounts will now print properly, even if there are no transactions on the main account * Loans New "W" (Redraw) transaction. This is equivalent to a "Z" (Reversal) transaction but does not affect any paid special charges. It's purpose is to allow borrowers that have paid ahead on a loan to redraw some of the surplus funds that they have paid. When posting a "R" (Drawdown) transaction, if specified in Setup / Parameters, the system should take into account the current arrears balance when working out the new repayment amount. The Principal and Interest report now correctly handles special charge payments when producing a report based on historical data. New format for importing data from the Commonwealth Bank's BPAY data export. Receipt Allocation Report - Fixed bug which incorectly handled holdback amounts when you used the "Override Hold Subledger" facility. Completed Loans Report - fixed bug which incorrectly showed bad debts as ODI. If Special Charges don't generate entries in the repayment schedule, then Special Payments will not affect the schedule either. Experian Italy Export. The system will not include any active accounts that are held and have a value in the "General Purpose 2" column - this allows a simple way to exclude accounts from credit reports that are submitted to Experian for loans in Italy. Version 3.42 6 June 2008 ************************ * Subledgers Modified "#" (Proportion of interest) calculation to be more intuitive. A subledger rate of X% on a loan with an interest rate of Y% will calculate as X%/Y% of the the total interest charges for the month. * Principal Reduction Calculations (For use in user defined queries only) The GetPrincipalReduction function now has the option to select whether or not to use historical or scheduled repayment amounts. * Insert_FM_Clients (Program Interface) New @CreditLimit parameter to allow setting a credit limit for a client * INsert_FM_Loans (Program interface) New @CreditLimit parameter to allow setting a credit limit for a Loan. * New option to check credit limits. In Setup / Parameters there is a new flag which enforces credit limits. If you enable the "Check Credit Limits" flag, the system will warn you if you try to enter a debit on an account that causes that account to exceed its credit limit. An account exceeds its credit limit if: 1. The balance the account exceeds the credit limit of the account OR 2. There are no borrowers linked to that account where the borrowers credit limit exceeds the total balance outstanding of all accounts linked to that borrower. * Asset Disposals Fixed bug which prevented disposal of individual assets on finance based accounts that more than one related asset. * Drawdown Transactions Fixed bug which prevented updates to Residual Values on Interest Only loans when a drawdown was posted. Version 3.41 26 May 2008 ************************ * Experian Data Export (Italy) Minor alterations to comply with most current specifications from Experian * Loan Summary Report New ability to be able to select loans to appear on the report based on the aactual amount by which they are in arrears. * Assets New ability to split an existing asset on a lease into two assets, to allow for the partial disposal of assets. New ability to allocate an asset to a lease where no asset was previously allocated. * Delinquency Reporting New report layout (format 9). * Investment / Other Accounts Fix bug in transaction posting function caused by addition of ThreadID's. Added "Classification 3" to accounts, based on the Classification3 system table. Added a commission rate to accounts, to allow payment of commissions based on interest paid to an investor. The payee for the commission is defined in the Classification3 table. New facility in Setup / Parameters to change the prompts on some of the Investment Account fields. New "Replacement Account#" field for investments. New "Series" and "Issue" drop downs for investments to allow compliance with ASX / NSX. New "Issue Rate" column for investments for reporting purposes only. New constraints on Investment Business Codes to control the minimum account length and prefixes on new account#'s. * Subledgers Modified to allow periodic calculations based on the monthly interest charges of a loan. Interest is paid during the investment monthly interest run. * ODI Fix bug which altered the schedule incorrectly when charging ODI on Interest-Only loans. * Diary Reminders New facility in Setup / Parameters to change the prompts for some of the diary reminder fields as they appear on the loan form. Version 3.40 22 April 2008 ************************** * GL and Investment Transaciton Entry Fixed "Can not insert null" error when posting new batches. Version 3.39 18 April 2008 ************************** * Inertia. Modified the system so that if an account is set up to have inertia rentals, then a standard payment which reduces the balance to zero will not automatically complete the account. * GL Transaction Query When viewing the details of a specific transaction via the "transactions" button on the loans form you have the option to view "GL Transactions for this Loan / Batch". Fixed a bug on this option which didn't display GL transactions if you changed the Account# of the loan while it was active. * Borrower Names Fixed a "String or Binary Data Would be Truncated" error for accounts that had borrowers with very long (> 100 character) names. * Loan Summary Report New facility to select loans and display values for Classification fields 1, 2, 3 and 4. * Subledgers New column "Max Times To Charge" which lets you specify the maximum number of times that a subledger may be charged on a loan. * Receipt Allocation Report New facility to specify which subledger should be used as the "Holdback" subledger when producing the report. * Experian Italy Fixed bugs in the layout of the Experian Italy export file. * New transaction type "VOID" Instead of the "Z" reversal transaction, there is now a new "VOID" transaction. When applied against an account it prompts you to select which transaction you want to void. It then reverses that transaction and all associated GL and Creditor transactions, to ensure that a reversal is the exact mirror image of the thing it's trying to void. "Z" (Reversal) transactions are still available, but you should use the "V" (Void) transaction if you want to cancel a previously posted incorrect transaction. NOTE. VOID transactions can only be applied against transactions entered on or after you install this version NOTE. You may now DISABLE reversal transactions for normal users. To do this, go into: Development / Security / Security Forms and Controls / Select "frmHeldBatches" and click "CoNTROLS" Select "AllowReversalTransactions"and change the security object name to something higher than SO_USER, such as "SO_Administrator" or "SO_DBO". * Assets Fixed bug when reversing payouts. Previously, payout reversals did not reverse the disposal of assets which occurred as part of the payout process. * Investments Ledger - Form Letters Fixed multiple form letter option when trying to send a letter to all accounts that reinvested interest rather than received interest as a payment. Version 3.38 12 March 2008 ************************** * Periodic Debits New facility to periodically pay credits even when the associated subledger is not chargeable. Useful feature for paying trailing commissions at times other than during the end of month processing * Investments fix bug with investments accruing interest after the "to date" of the interest run when interest is paid to anniversary date. * TangoWeb New ability to edit borrowers address and phone number information. Version 3.37 25 Feb 2008 ************************ * Background Color. New facility to set the background color of the system. Go into Setup / Parameters / Color to set the new background color. * Delinquency System. New facility to change the title of the "First Payment Default Report". Go into Setup / Paramaters / "Custom Labels" to change the title of the report. * Loan Transactions You can now post zero value payments dated prior to the start date of a loan. This allows you to set the "Last Payment Date" of a loan to be a prior date, which is useful if the current loan account is a loss recovery account set up in place of a writeoff account that may have started on an earlier date. * Credit Card Data Export Minor changes to the layout of the St George Bank credit card export file to match new requirements from the bank. * Web collections Enhancements to screen layouts. Version 3.36 6 Feb 2008 *********************** * Investments New facility to specify the business code of a new account when rolling over an old account. Fix bug with duplicating business codes. Show payment method in the Account Summary and allow selection by that value. * Form Letters Added new form letter fields: AddressLine1 AddressLine2 TodaysDate Salutation * Loans Tighter validation of changes to account#'s The system will now display a warning before changing an Account# Version 3.35 24 January 2008 **************************** * Online collections system Improved the layout of screens. VERSION 3.34 9 January 2008 *************************** * Online collections system This version alows the use of the Expert 1 Online Collections system - a web-based collection system that allows collections staff to access delinquent accounts via the internet, and work through overdue accounts. It allows printing statements, payout quotes and form letters. There is a new "Process Web Requests" option on the Users menu in Tango. This process is necessary for the web site to be able to print statements and payout quotes. You must run this option if you're using the web based collections system. Please contact Expert 1 if you want to install this module. vERSION 3.33 2 January 2008 *************************** * Security Added new security / title / category fields to the "Security" tab on the Loans form. * Investments Fix minor rounding issue when projecting future balances of investiments that have linked ROI accounts. Fix interest calculation error which occurred when paying out accounts after they had been imported from IBS. * Loan Payments New facility to "Pay current amounts due" before paying special charges. Prior to this, you could pay arrears first, or amounts due in the current month, but you couldn't pay amounts due exactly on the transaction date before paying outstanding special charges. Go into Setup / Paramaters / Loan-1 to change this. Version 3.32 2 December 2007 **************************** * Periodic Debits New ability for Periodic Debits to generate creditor invoices or GL journals without having to debit a loan account. * Subledgers Currently you can specify that when automatically adding a subledger for a loan, it should be populated with the creditor ID specified in one of the Classification Codes for the loan. You can now also specify a CreditorID in the business code which can be copied into an automatically added subledger. * Subledgers New Calculation method '#' which works out the value based on how much interest has been charged in the previous month. New "Minimum Arrears Amount" and "Maximum Arrears Amount" which lets you control whether or not a subledger should be calculated based on the arrears balance of the account. New "Minimum Term" value which lets you specify at what period during the term of the loan the subledger should be calculated. Version 3.31 23 November 2007 ***************************** * Payout Quotes. New "Fixed Interest" payout method which works in conjunction with the "Fixed Interest" interest method. * Loan Summary Report. New option to include outstanding fees in any balances that appear on the report. * Wizard / SQL 2005 Fixed a problem with the wizard when entering loans on a SQL 2005 server. Prior to the fix the system would crash with an "Underlying recordset" error when you tried to add a new subledger while entering a new loan. Version 3.30 12 November 2007 ***************************** * Wizard Fix bug in simple interest calculation which was not taking into account the term of the loan * Form Letters Fix bug in selection criteria which caused wrong selections when selecting by credit rating. Version 3.29 7 November 2007 **************************** * Overdue interest Fix bug with ODI calculations on Interest Only loans where ODI is based on daily net balance. * Credit rating / Form Letters Modify form letters so that you can send multiple formletters to a group of accounts based on their credit rating. * Wizard New facility to prompt the user for the gross interest amount when entering loans that use the "Simple Interest" method. To enable this feature, go into Setup / Parameters / Interest and tick the box which says "Prompt for gross interest on simple interest loans" New facility to use a combo box (drop down) instead of a normal text box when capturing the General Purpose 2 field. To enable this feature, go into Setup / Parameters / General and tick the box which says "Prompt for General Purpose 2 as Combo" * Special charges. When entering special charge transactions the system will only overwrite the transaction amount if its zero or null. Version 3.28 2 November 2007 **************************** * Subledgers now have "Maximum Arrears Days" and "Minimum Arrears Days" field to filter out whether a subledger should calculate a value based on the number of days by which the account is in arrears. * When Interest Only Accounts are entered via the wizard the system will force the "Residual Value" field to be equal to the amount financed. Version 3.27 1 November 2007 **************************** * Added Branches to Templates. * Modified the "Copy Branch" facility to handle Templates. Version 3.26 18 October 2007 **************************** * Customer statements A new "Statement" button the client screen lets you print loan staements for ALL loans held by a client. * Payout Quotes A new "Payout Loading Amt" field lets you dynamically define how you want to describe the "Payout Loading" when giving a payout quote. * "Gross Balance Including Charges" Fix bug which showed a balance in this field when an account was complete. * NZ Payment Export Fixed alignment problems in exporting repayments in NZ MDS format. Version 3.25 5 October 2007 *************************** * Templates Changed system to ensure templates don't store any trailing blanks on the Template Code. * General Ledger New "Alias Account#" which lets you report and consolidate using a different accounting structure. * Other accounts / invesments "Other Business Codes" has an option to specify that when creating direct credits, the NARRATIVE of the transaction should be used as the lodgement reference instead of the batchnumber & account#. * General New "Hide report parameters" option in Setup / Parameters / General lets you control whether the report parameters appearing at the top of most reports should be hidden. * Subledgers New option "Does not depend on number of payments" prevents the system from adjusting any subledgers that are based on the repayment amount. If you don't set this flag, and a subledger is based on a flat amount per month, but there is more or less than one repayment per month, the system would adjust the monthly fee by "Term" divided by "Number of repayments". * BusinessCodes Modified to enforce stricter checks on the GL accounts that can be entered into a business code. New "Refund Interst" facility which lets you refund any interest charges on accounts that payout within a certain period. * Reports New "Detailed Aged Principal" report. (Reports / Loans / Detailed Aged Principal). Shows a breakdown of the principal reduction of a loan based on date ranges that you specify. * Programming Interface. Stored procedure "Insert_FM_Loans" has a new "@FinalRepayment" parameteter to let you specify a different final repayment from the other standard repayments. New function dbo.GetGrossBalance(@LoanAccountNumber, @AsAtDate, @IncludeCharges) returns the gross balance of a loan as at a specific date, with or without any gross charges applicable to the repayments * Direct debits New NZ "MDS" direct debit format for use with NZ banks. * GL Report Writer New commands: ALIAS=ON | OFF Specifies if the report writer should use the new GL Alias Account# when generating reports. MATCH=NNN If specified, tells the report writer to only look from position nnn onwards in the account# when grouping accounts together. "+" (Consolidate) If used, any Alias Accounts, or accounts modified by the MATCH=nnn command will be subtotalled and presented as one line on the report. Version 3.24 9 August 2007 ************************** * Investment System New option to modify interest calculations to treat all years as having 365 days - even leap years. * Importing Transactions New "PNG" import file type to import data from PNG banks. * Interest Calculations Improved the accuracy of calculations when changing interest rates on Hybrid loans (loans with both an interest only and a P&I portion). This allows you to vary the rate of hybrid loans mid-term. * Interest ONly Periods In hybrid loans, a new facility to specify an individual interest only period for a loan, even though the interest only period defined in the business code may be different. * Principal and Interest Report Modified Report so that if you elect to use the actual history of a loan when generating the report, you should not project any activity after the early completion date. * Subledgers Improved accuracy of subledger calculations for large multipliers (over $500K). * Direct Debits New option to consolidate direct debits by bank account for situations where one borrower might have several loans with repayments due on the same day. The system can now create one direct debit based on the borrowers bank account rather than separate debits based on each of their loans. This has ramifications if you need to import information about dishonored direct debits, because the lodgement reference contains the Tango Account#. If you're consolidating payments from several accounts, it's impossible to automatically track the dishonor back to each component loan. * Diary Reminders New option to prevent any changes to the "Date Entered" on the diary reminder screen. * Subledgers (Program Interface) Fix bug when adding a subledger via stored procedure Insert_FM_LoanSubledgers. There were inaccuracies if the subledger was supposed to be charged monthly and was supposed to affect the repayment amount of the loan. * ODI New ODI method "Daily Net Balance" which charges ODI based on the daily net balance of the account. Version 3.23 28 June 2007 ************************* * Processing News Loans Add new setting to Business Codes which allows you to zero out the gross interest of a loan when it is activated, if the gross interest falls below a certain threshold. New setting on a loan to specify if interest should be refunded if the loan pays out within a set number of months. Modified XML import routine to handle new loan columns. * Receipts / Deposits Listing Fixed bug which prevented report from displaying. * Loans When a loan has its repayment schedule automatically extended, the logic of the process was improved to use the most popular repayment amount for the loan as the basis for the new repayment amount. * Current / Non-Current analysis. Modified report to allow you to specify the ranges of dates used for each grouping when producing the report. * Investments Increased the number of detail lines that can be displayed on one page for a statement. Fixed bug which showed interest transactions on ROI Accounts, and accounts with sub-accounts. * Searching Modified Client / Search to enable search by UserField1 and UserField2 * Maturity Analysis Changed the logic of calculating the maturity date to ignore any entries in the repayment schedule which have a zero amount due. Version 3.22 4 June 2007 ************************ Fixed bug in repayment variation facility which prevented you from entering details of direct debit variations onto a loan. Version 3.21 31 May 2007 ************************ * Templates. Fixed bug in templates which caused the system to add spurious subledgers when creating a new loan from a template. * ODI. Modified system to use the Days of Grace value when calculating ODI that's based on the daily arrears balance * Days in arrears Modified arrears calculations to show a negative number of days in arrears for accounts that have paid in advance. * Gross Balance New enhancement so that the Gross Balance can optionally include any special charges that have been levied as at a future date. New facility to show Gross Balance including charges on the loan form, as a separate figure from the Gross Balance excluding charges. New facility on the loan summary report to specify that the gross balance should include charges. * Repair Schedule Modified to be able to properly handle a payment and reversal entered on the same day. Modified to record in the system log that the "Repair Schedule" has been run for a loan. * Wizard. New flag in Setup / Parameters to say whether or not you want to adjust the first payment date in the wizard when you change the repayment frequency of a new loan. * Payout Quotes Minor changes to the User1 payout quote calculations. * Form Letters Ensure the "Disbursements" field includes subledgers that have either the "Matches amount advanced" or "Matches amount financed" flags. * Interest in arrears New GetInterestInArrears() function for use in Ad-Hoc queries which shows how much of the arrears balance relates to interest charges. * Google Maps New "MAP" button on the client form to show the location of an address on Google Maps. * Arrears Calculations Fix "No Count" error which caused incorrect results in ad-hoc queries. * Cost Centres Increased length of Cost Centre descriptions to 55 chars. * Hybrid loans Improved repayment calculations when varying the interest rate on a loan that has both an interest only period and a "Principal and Interest" period. * Copy Branch Fixed bug which ommitted some columns on a business code or subledger when copying components from one branch to another. * Loan Form New "Show Security Log" button on the diary reminder tab to show all securty log entries relating to the loan. Version 3.20 27 April 2007 ************************** * Assets Increased the size of the following columns to allow for up to 200 characters: - Asset Description - Asset Location - Asset Make - Asset Model - Asset Serial Number New optional Utility "User1_UpdatePositions" which will calculate the Market and Internal positions of asset-based accounts where this information has not been entered. * Current Month Calls Report Modified to include action code (from Diary Reminder) on report. * Loan Activity Report New alternative format ("USer1") * Loan Entry New "Template" facility to streamline the entry of loans by prompting for specific values and splitting them into their compponent subledgers. For example splitting a gross asset cost into Net and GST for account purposes. Templates may be attached to Business Codes. If you do this it changes the way the Wizard prompts you when entering a new loan * Business Codes Fixed bug which omitted some columns when using the "Copy" button. * Subledgers New facility to copy a subledger to a new subledger. New facility to say that a group of subledgers on a loan, when added up, should match the "Total Financed" value of the loan. Useful when using Templates to capture details of assets financed by a loan. Fixed bug which occasionally swapped Debits and Credits on some journals when processing new loans with subledgers that had the "Use Credit" flag ticked. Subledgers with a charge method of "Periodic" which also have the "Charge with Repayment" box ticked will now affect the amount of the repayment when entering a new loan. Modified Subledger History tab on the loan to include details of non-direct debit fees charged when payments are entered against a loan. * Identification Methods. A new facility when defining an identification method, to specify that it must be prompted for when a loan is being entered via the wizard. * Special Charges A new facility in Setup / Parameters to specify that when allocating payments against special charges, to pay the oldest schedule entry first, regardless of whether the transaction being allocated is an "S" or "P". * Form Letters & Statements A new utility to automatically post any held batches generated as a result of charging fees for form letters or statements. * Client Form Fixed bug which showed "0" or "-1" on the Loan List when an account wasn't in arrears. * Security New facility in Setup / Parameters to allow users in the same "Company" to view details of loans that belong to a different branch in that company. New facility in Setup / Parameters to prevent users from posting transactions into a prior financial period. * Form Letters New fields: UnpaidEnforcementPlusODI30 UnpaidEnforcementFees New Stored PRocedure source for form letters: Select_FormLetters_User1 - which includes more complex payout calculations for Rental-based accounts. * GL Statements New facility to summarize by Reference and Narrative to assist with Bank reconcilliation. Version 3.19 4 April 2007 ************************* * Vista This version of Tango32 is compatible with Windows Vista. It does not require the XJPG20.OCX control, and works around the Vista restriction which prevents programs from using the Keyboard buffer to make selections. Previous versions of Tango would not run under Vista. * Form Letters New facility to specify that a form letter is used for payout quotes. If you do this, whenever the form letter is printed, the value of the payout quote is stored in the diary reminder. New fields to allow form letters to show a payout quote 21 days after the as at date. ODI21Days Interest21Days TotalPayout21Days TotalPayoutPlusETP21Days ODIPlusInterest21Days PayoutSubTotal21Days TotalPayoutBalanceDue21Days Fixed bug when adding a new form letter which threw an error when you clicked on the "Extract Fields" button. * New Refinancing option When you give a payout quote for an account, there is a new option to "Refinance" the account. If you tick this, the system will display a wizard showing the payout figure of the existing loan (which will be rolled into a new loan). You can also refinance any or all of the subledgers on that loan. This option requires some setting up. For each business code, on the "Payout" tab, there is now an option to specify what NEW business code to use when creating a refinanced loan from an existing loan. You can also specify which subledger to use when rolling the old amount financed into the new loan. For each subledger, on the "Links" tab, there is now an option to specify if the subledger should be included when refinancing a loan. for example, you might have an ongoing commission trail subledger on an existing loan, and want that amount to be carried forward onto any subsequent refinanced loan. To do this you should specify a "Refinance Subledger" in the links tab of the existing subledger. When the new loan is activated, it will automaticallt post a "Refinance / Payout" transaction to the old loan to complete it. It will also copy any existing assets from the old loan to the new loan. Therefore if any assets are disposed of in the process, you need to remove them from the new loan before activation. Links are displayed on the loan to let you quickly swap between views of the "Refinance From" and "Refinance To" accounts. * General Purpose Fields The size of General Purpose Fields 10, 11, 12, 13 and 14 have been extended to 100 characters. * Current Month Calls report Fix bug which excluded from the report any accounts that were in arrears by the same number of days as the minimum number of days on the prompt. E.g. if you specified that you wanted to list accounts that were at least 30 days in arrears, it used to ignore accounts 30 days in arrears and only show accounts that were 31 or more days in arrers. Report now shows both the number of days in arrears and the arrears balance. * Business Codes New facility to specify a default term and repayment frequency. Whenever you add a new loan with the wizard, the system will default the TERM and FREQUENCY to whatever you set on the business code. Fixed "Copy" button on the business code form to copy all columns when duplicating a business code. Fixed bug which prevented you from setting the payout method to "Rule of 78 #3". * Loans Fixed bug which changed repayment amount on a new loan when you displayed the details of a new loan, then clicked the "SAVE" button. * Subledgers New "Match Amount Financed" option on the subledger definition. You may have several subledgers on a loan whose totals must match up to the total amount advanced on a loan. If you set the "Match Amount Financed" option on the subledger definition, then whenever you're entering subledgers in the wizard, the system makes sure that all subledgers with this flag ticked will always add up to the "Amount Advanced" in the wizard. New "Copy" button on the subledger definition form to let you easily duplicate an existing subledger definition. New "Sliding Scale" facility on subledgers. The amount of the subledger calculated can be based on a table of values so you can specify that the value of the subledger is based on the lookup value in a table based on the value of the loan. E.g. Charge $10 for loan amounts up to $1,000 Charge $15 for loan amounts up to $2,000 Charge $20 for loan amounts over $3,000 New "Always Round Up" option. This lets you specify that when calculating the value of a subledger to always round UPWARDS rather than to the nearest rounding amount. * System Configuration New facility to specify a minimum number of ID points when entering a new client via the wizard. If this value is set, the system won't let you add a new person unless you have at least the minimum number of ID points. This restirction doesn't apply if the client is an organization instead of a person. * Delinquency System When using format "4" for delinquency reports, the Action Date will be displayed for a diary reminder if someone enters an Action Code or an Agreement Code. If an Action Code or Agreement Code is entered, but the "Date to Action" is blank the system will show the "Date Entered" on the report. * Investments Added new check to "Process New Investments" which will warn you if you try to add a new Investment that has a sub-account that has a different maturity date or start date from the main account. New "Copy" button on Investment Business Codes to make it easier for you to duplicate an existing investment business code. * Assets Increased the widths of the following fields to 200 characters: Description Location Make Model SerialNumber Version 3.18 21 March 2007 ************************** * Customer statements Fixed bug which incorrectly default to "true" the option to display interest rates on statements as monthly instead of annually. Version 3.17 21 March 2007 ************************** * Form Letters New fields: Classification1, Classification2, Classification3, Classification4, TotalChargesDue BankAddress, NumberOverduePayments, DailyInterestRate * Repayment Schedules New facility to "Repair" a repayment schedule. When there have been a multitude of repayments and reversals of various transactions on an account, the repayment schedule can look quite untidy. This facility "Repairs" the schedule by clearing all the amounts paid, and deleting all "CHG" entries, then recreating the information based on transactions that exist on the account. To use this facility, click on the new "Repair Schedule" button on the "Repayments" tab. * Loan Transactions Modified transaction processing logic so that "CHG" entries in the repayment schedule will only every be affected by special charge & special payment transactions. Other payment transactions will only affect the NON-"CHG" entries in the schedule * Data Import New format for importing data from ACT! (Added a "Funder" column to the existing format) * Entering New Loans. New facility to enter a "Pre-Payment" amount in the wizard. For example, when you receive a payment in advance from the borrower when the loan starts, this "prepayment" can be entered in the wizard. This saves you having to post the pre-payments separately after the loans have been activated. * Subledgers New option on a subledger to force totals to match amount financed. This is useful if you have a number of journals that need to be entered in the subledger screen, and you want to make sure that when the user enters these journals, the total matches the "amount financed" on the loan. Any subledgers with this flag option set will be totalled while the loan is being entered in the wizard. The system will either adjust existing lines, or add new lines on the subledgers screen to ensure that they reconcile with the amount financed. * "Current Month Calls" Report Enhanced report to show arrears balance on the report. * Delinquency Reports Modified the "Arrangement" code that appears on the format "4" delinquency reports. The arrangement code from the most recent diary reminder will be displayed. If that reminder has an action date, the arrangement code will be blanked out as soon as the action date is prior to the "as at date" of the report. * Form Letters New facility on a business code to stipulate whether or not you can charge the borrower for issuing a form letter. * Payout Quotes. New "Rule of 78" #3 method to match consumer credit requirements in the UK. * Direct Debits New facility to select direct debits based on a range of account numbers. Version 3.16 9 March 2007 ************************* * Importing Loans Fix error in Gross Interest when importing loans from a table of data. * Schedule of borrowings Added numerous statistical data to this report. * Loan Summary Report Allow sorting & grouping by AccountTypeID. * Rebuild Cross Reference Fixed "CursorFetch" error which occurs when rebuilding the search cross reference table. * Yield Rates New facility to calculate a Market and Non-Market yield rate for loans. * Payment Frequencies (Form Letters) Fixed bug which showed incorrect repayment frequencies for loans when printing form letters. * Form Letters Added numerous new fields to the Form Letters procedure. (See updated AllFields.RTF for info). * Repayment Calculations New facility to calculate monthly interest only payments paid in advance. * Borrowers of Loans Modification to ensure the order of the names of borrowers on a loan is consistent on all reports. * Creditor & Investment Transaction Batches. New facility to print unposted Investment and Transaction Batches. Version 3.15 23 Feb 2007 ************************ * Numerous reports and Form Letters Fixed bug which gave the message: "Cursorfetch: The number of variables declared in the INTO list must match that of selected columns" * Suibledgers New facility to specify that the GL accounts and Creditor info in the subledgers can be varied depending on the classification code that is selected when a loan is setup. Fixed bug which caused double posting of up front subledgers posted as special charges. New facility in subledgers to allow you to evenly split the amount of an income or expense subledger into even amounts that are accrued for each month of the loan. New facility to prompt you if its ok to add any related subledgers when entering a subledger against a loan that is linked to other subledgers. * Creditors System New facility to pay outstanding balances on creditors accounts. * GST New facility to ensure that if a special charge is subject to GST, any partial payments of that special charge will be apportioned correctly to ensure that the correct amount of GST is paid. * Form Letters New facility to charge a fee for a form letter when it is printed. New keyword in form letters "BuyBack Date" is three months after the loan start date. * General Purpose 1 New facility to restrict access to the payout quote function on a loan based on the "Object Name" value for the General Purpose 1 field. Version 3.14 15 Feb 2007 ************************ * Payment Import Modified import routine to allow for changes to data that is downloaded from Wespac NZ website. * Numerous reports and Form Letters Fixed bug which gave the message: "Cursorfetch: The number of variables declared in the INTO list must match that of selected columns" Version 3.13 13 Feb 2007 ************************ * Fix bug which caused error message "Operation not allowed when the object is closed" to appear when printing form letters. * New facility to import repayments from Westpac NZ. * Fixed bug in transaction entry which displayed "Error in AltDLookup of modSystemFunctions" when trying to enter an account that does not exist. * Fixed bug which said there were new loans waiting to be processed when those loans were held and would not be processed even if you answered "YES" to process any new loans. Version 3.12 12 Feb 2007 ************************ * Client Address Screen now shows the last date the address was changed. * Arrears Calculations Fixed bug with arrears calculations when the system was configured to include outstanding special charge and ODI payments in the arrears balance. * Delinquency System New facility to specify that the "Total Collected" amount which shows at the top of the delinquency reports should not exceed the total amount due for each account. (To prevent lump sum payments from distorting the collection figures) New "Arranegements" system. Arrangements types are defined via Setup / System Tables / System Tables. They may be entered against a diary reminder entry. When the delinquency report is printed, the most recent Arrangement for any account is shown on the report. To allow for the additional information, the business code description is still shown on the report, but the actual code itself is no longer shown. * Investments System Modified system so that when entering a new account the "First Interest Payment Due" date defaults to the last day of the current month. When an account is rolled over, the new Interest Payment Due date defaults to the last day of the month of the rollover. * Aged Borrowers Report Modified Report to show next due date on the report. * Loan Summary Report Fixed "Error in AltAltDcount of modsystemfunctions, Invalid object name #JobQueue". * Transaction Audit Report, Loan Summary Report, Ad Hoc Queries Fixed CSV problems when exporting text containing commas and quotes Version 3.11 12 January 2007 **************************** * Credit Card Export Fixed layout so expiry date of a credit card is YYMM instead of MMYY * Delinquency Fixed problem with Targets which caused the figure to include amounts due from branches that should not have been included in the deli report * Diary Reminders Modified Diary Reminder report to allow selection of reminders by date entered. The doman\user id of the user who entered the note will also appear on the report. Version 3.10 2 January 2007 *************************** * Subledgers. Fixed an intermittent problem for some clients where there was an incorrect constraint on the subledger table which prevented you from adding new subledhgers. * Form Letters Fixed the "Payment Frequency" keyword to ignore special charge payments when working out the average repayment frequency of a loan. * Investments Fix rounding errors when working out interest on linked "ROI" investment accounts. Fix "Out by one day" error when paying out accounts that have ROI sub accounts. * Credit Cards Increase the maximum size of the Merchant ID to 20 characters. New "CommWeb" credit card export format. * Special Charges Ensure that payments only affect NON-charge schedule entries, and "S" transactions only affect Chargeable schedule entries. * BSB Codes New facility to import more banking info from the "BSB Numbers In Australia" publication. * Loans Ability to add Replacement Account numbers when adding new loans, and to be able to search by those replacement account numbers. If you enter a "Replacement Account" number when searching for an existing loan, enter it in the "Loan#" field of the search screen. If it's the only loan with that replacement account# the system will automatically pull up the details of that loan. * Searching Reduced the minimum length of a search word from 3 letters to 2. * Delinquency System There is a new Setup / Delinquency / "Delinquency Parameters" form that lets you specify global parameters for the delinquency system. One new field is the "Target Column" which lets you specify which column on the deli report should be used to calculate the Target amount for your collectors. Version 3.09 8 December 2006 **************************** * Current / Non-Current Analysis fix problem with arrears in report. * Form Letters Fix problem with Lists of repayments and dates that were longer than about 30 repayments. * Transaciton Import. The "User 2" transaciton import format is now: "Date" (The date of the payment) "Account", (Ignored) "Period", (Ignored) "Journal_ID", (Payment reference) "Journal_Description", (Payment narrative) Amount, (Payment Amount) "Dep_Ref", (Account#) "Ref_2", (Alternative Payment Reference 1) "Ref3", (Alternative Payment Reference 2) "Ref4" (Alternative Payment Reference 3) * Investments System - Mothly Interest Processing Fixed SQL2005 bug which caused this process to crash when run for the first time on SQL2005 * Investments System Interest Calculations Fixed rounding errors when showing interest amounts in form letters * Transaction Processing New format to interface with the CommWeb Credit Card system from Commonwealth Bank * Classifications If you mark any "Classification3" category as "Urgent" a big red box conaining the classigfication description will appear on the first tab of the loan form. * Access 2003 Tango32 is now 100% compatible with Access 2003. If it detects that you are using Access 2003 it will attempt to make some changes to your registry to ensure you don't get security warnings when running tango. * CHM Help Files over the network Previously, If your Tango32 help files are located on a network share, they would not be viewable due to security restrictions in Windows XP SP2. Tango is now aware of these restrictions and will attempt to change your registry settings to allow you to access help files over your network. * Installation Error. Fixed the "Error in GetConnectionInfo of modConnection" error that pops up when you first install Tango Fixed the confusing windows Logon Dialog that pops up when you first install Tango prior to loggin in for the first time. * Paid in full Report. Modified to include "Refinance" and "Restructure" transactions. Version 3.08 24 November 2006 ***************************** * Interest Calculations Fixed an "out by one day" error when calculating interest on loans that had interest charged in frequencies other than monthly. * Form Letters Fixed TotalFinancedCafHold field. * "Current / Non-Current" Report Fix problem where some columns would not add up in some circumstances. * Payout Quotes Payout Quotes were enhanced so to take into account When accounts make interest payments in advance. The payout quote would then rebate a proportion of the interest paid in advance. This only applies to interest only loans where the payments are made in advance. * Payment import. Tango can now import a new CSV file format with the following columns: "Account", (Ignored) "Period", (Ignored) "Journal_ID", (Payment reference) "Journal_Description", (Payment narrative) Amount, (Payment Amount) "Dep_Ref", (Account#) "Ref_2", (Alternative Payment Reference 1) "Ref3", (Alternative Payment Reference 2) "Ref4" (Alternative Payment Reference 3) * Variable interest rates Fixed bug in interest rate variation logic when the rate on a loan was varied after its "Due to complete" date. * Customer Statements Logo New facility to add your own logo to customer statements. Upload the logo via Setup / Parameters / Logo * New Data Export facility New facility to export loan and transaction data from a group of loans and email it to a specified recipient. See Processing / "Export Data" for more info. * Payment of Special Charges New facility which can optionally schedule new special charges to be paid when the next repayment is due. This setting is controlled via Setup / Parameters / "Loan Other" but may be overridden via Setup / Business Codes / Edit / "ODI / Special Charges". * Subledgers New facility to force a subledger to be posted against an account as a special charge instead of a debit. This is useful for up-front payments (such as establishment fees) that need to be paid, but which you don't want to affect the yield or gross interest of the loan. New facility to specify that a subledger amount should REDUCE the effective yield of the loan. Previously you could only specify that a subledger amount would be added to the gross income of the loan increasing the effective yield of the loan. * Residual Positions. New facility to record both the Internal and Market residual positions of a lease. This lets you specify how much you plan to sell / salvage leased assets for once they reach the end of the lease. Residual positions don't affect the gross interest or scheduled repayment amounts of the loan, and are always EXCLUSIVE of any taxes. New facility on business codes to specify whether or not the Internal or Market positions should be taken into account when calculating the effective yield of a loan. * Some internal date functions were missing from some databases, so this version checks to ensure those functions exist. This missing functions were: GetDateAtMidnight, GetDateAtMonthEnd, GetDateAtMonthStart, GetNextInterestOrPaymentDate * Fixed some minor problems with the utility which describes how long ago the database was backed up. Version 3.07 13 October 2006 **************************** * New facility to charge fees for statements. To set this up, you must create a "Statement Fee" subledger. In this subledger you have the option of specifying the maximum times in any given month that it can be charged. You should then edit any business codes whose loans are subject to the fee. Go to to the "Odi / Specil chages" tab and specify the fee in the "Statement Fee Subledger" field. The system will ask you if you want to charge statement fees before producing statements for any accounts that are subject to the fee. * Diary reminders now have a non-editable "User ID" which corresponds to the system user ID of the person who added the reminder. You can prevent changes to diary reminders as follows: 1. Select Development / Security / "Security Forms & Controls". 2. Select the "frmDiaryReminders" form and click the "Controls" button. 3. Select the "txtAllowChangesToDiary" control. 4. Tick "Can Default" and "Remember Values". 5. Set the "Object Name" to "SO_DBO". This will only allow changes to diary reminders by system administrators, or by the person who added the diary reminder, provided they make the change on the same day the reminder was created. * Diary Reminders - New facility to add a longer description to Action Codes via the Setup / "System Tables" / "Action Codes" option. * GST on Tax-Based accounts Fixed bug which did not process monthly subledgers on Tax Based accounts. * Form Letters New field "TotalFinancedLessCafHold" which returns the amount financed less the value of any subledgers with codes of "CAF" or "HOLD". * Transactions New Transaction Types "REFINANCE" and "RESCHEDULE" which complete a loan and give it a new status of "REFINANCE" or "RESCHEDULE". Modified query screens to show these new loan status codes. * System Startup Whenever you log into Tango now, it will tell you how long it has been since your data was last backed up. This info appears on the "About" screen. You should monitor this information to make sure your data is being regularly backed up. Version 3.06 27 September 2006 ****************************** * Data interface: Insert_FM_Employers stored procedure. Fixed bug which caused a "String or binary data would be truncated" message when adding new clients to databases with an already large number of clients. * New Loan Wizard Fixed inaccuracies that occurred in repayment calculations when a repayment had associated charges that were flat fees as well as charges based on a percentage of the repayment. * Hybrid Loans (Part interest only, part P&I) Fixed bug which caused incorrect calculations of repayments for the interest-only portion of the loan. Version 3.05 15 September 2006 ****************************** * New option when importing transactions to specify that all transactions should be imported into the same batch rather than separating them out in to an error batch. * Special Charges. Fixed bug which occurred if you entered a special charge for a given day and there were more than one repayments due on that date. The bug was that all schedule entries for that day would be changed rather than just the first one. * Loan Summary Report - New facility tp select by either classification2 or classification3 * New XML interface. Please see http://expert1.net/tango32/downloads/tangoexport.xsd * Transaction Import - Fix bug which imported zero value account numbers when processing a westpac BRS file which did not have account numbers encoded properly. Version 3.04 12 September 2006 ****************************** * New facility to charge interest in frequencies other than monthly. For more details see this article (http://expert1.net/Tango32/Lists/Announcements/DispForm.aspx?ID=7) * fix problem with calculation of repayment amounts for non-monthly repayments that have a fixed monthly fee. * When holding interest charges, the generated diary reminders will have an action date as at the date of the interest run, and an action code of "HLDI" to make it easier to get a summary of those diary reminders via the diary reminder report. * Fixed bug when posting debits to variable rate loans which caused the system to hang for long periods. * When importing Westpac Direct Debits, the system looks for the account# in the right-hand side of the lodgement reference before looking in the lefthand side, to improve the accuracy of the data imported. * Loan Summary Report now has the facility to display Classification 2 & 3 on the right-hand side of the report. * Loan Summary Report - fixed bug which showed inaccurate weighted interest rate when backdating the report to a date prior to the current date. Version 3.03 22 August 2006 *************************** * New facility to hold interest charges on accounts that are more than a specific number of days in arrears. Set the number of days via Setup / Parameters. * Modified payment import procedure to quarrantine payments received for new (non-activated) accounts into a separate batch. Prior to this, the system would not import the batch. Version 3.02 2 August 2006 ************************** * Fix "OLE Error" when adding a loan that has both an interest-free and printipal & interest period * New "PreventZeroSubledgers" column in Setup Information Table which changes the behaviour of the "Insert_LoanSubledgers" sp so that if a subledger value is zero it is not added to a loan if the "PreventZeroSubledgers" flag is enabled. * Fix problem which caused a mistranslation of ACT data files as St George direct debit files. * Fix problem with Posting of Transactions which incorrectly paid ODI and special charges as soon as they were charged against an account. * Form Letters. New Cheque Cashing fields added. * Fix Bug with entering of Cheque Cashing accounts, and Invoice Discounting accounts Version 3.01 24 July 2006 ************************* * Variable Rate Loans. Improved accuracy when recalculating repayment amounts after a draw-down. * Principal and Interest Report. Improved calculations to be able to handle loans with drawdowns mid-term. * Investment System Formletters. New fields for Investor Form Letters: <> -- the name of the account holder <> -- interest paid during the previous financial year <> -- interest paid during the current financial year * External interface: "User_Insert_FM_Loans_From_Table". The borrowers full given name is imported from the interface data, rather than just the initials. * External interface: "Insert_FM_Loans". New facility to specify both the Term and the Number of Payments when creating a new loan. * Banking info. Increased the size of the "Branch Name" field to allow the inclusion of the address of the branch. * Login. The database names are now presented in Alphabetical Order in the dropdown list on the login screen when you first start up Tango. Version 3.00 20 July 2006 ************************* * New "Net 2" format for Customer Statements * Completed Loans Report now shows Settlement Date * When you log in, the list of databases is now presented in alphabetical order * Minor improvements to the appearance of the splash screen * Deli System - new facility to hide action dates if they occur prior to the as at date of the report. You set this flag via Setup / Parameters * "Auto Payout" facility. New flag in Setup / Parameters to prevent accounts from being automatically paid out unless the account has first reached its term. * Deli Report - Include Business Code description in the report * GL Report Writer - Fix reporting bugs which caused incorrect values for last years figures * Gl Statements - Ensure end of year appropriations appear on statements * Appropriation Accounts - fixed problem where some appropriations did not appear in the trial balance * When processing new loans, ensure that the new interest rate is added to the history table * Fix problems with incorrect repayment amounts when varying the interest rate on loans that were either interest only or had fees. * Fix bug which calculated incorrect adjustment when backdating interest calculations on the last dat of the month for loans that started on that day. * GL Report Writer - New facility to duplicate reports. Improved user interface of report editor. Version 2.99 7 July 2006 ************************ * Deli System - Include business code description on deli report (format 4) * GL Report Writer - Fix bugs which caused incorrect value for "Last Year End of Year" column, and any columns where the month was specified explicitly. * GL Statements - Fix bug which did not close of end of year balance on P & L accounts when displaying their statements. Fixed bug which did not show profit and loss appropriations in the retained earnings account when printing a statement. Version 2.98 4 July 2006 ************************ * Minor enhancements to the "Import from ACT!" facility. * Fixed bug in variable interest facility which prevented alterations to repayment amounts and interest rates when you varied accounts under some circumstances. * Modification to differentiate between payments due in the current month BEFORE the current date and payments due AFTER the current date when deciding whether or not to deduct special charges from a repayment. Version 2.97. 30 June 2006. *************************** * New facility to match reversals against oroginal repayments by exact amount to make it easier to reverse out old repayments with out having to reverse out later payments first. * Deli System - moified to be able to show outstanding fees on the report. * New "Instalment Date Offset" to adjust the instalment date of any loans added into the system from an external source. * Modified payout quote to ensure interest days penalty is based on net balance plus MTD interest. Previously the penalty did not include MTD interest. * NEw "AD Hoc Queries" feature which lets you enter SQL queries and view the results in a spreadsheet. Create the queries via the Development / AdHoc Queries menu. Run the queries via the Reports / Adhoc Queries menu item. * Form Letters. The <> keyword has been modified to have the same function as <> keyword. * Interest Rate Changes. Modified to resolve the issue which prevented modifications to new rates and repayments in the review screen. * Data Import Stricter checking on the length of data that is imported from ACT! Import from ACT! can now handle stamp duty and app fees. * Periodic Debits now include the subledger id when creating type '2' special charges. previously when creating special charges using periodic debits, all the new charges looked like ODI instead of special charges. Version 2.96.2 13 June 2006 * Aged borrowers report now has option to output to file. * DBO can change details of all data in the repayment schedule provided the option "Allow changes to paid schedule entries" is enabled. Version 2.96.1 1 June 2006 * Show arrears subtotal on arrears detail screen * Show loan start date on all statement formats Version 2.96 29 May 2006 * New facility to disable deducting charges for accounts that are in status: HELD (See Setup / PArameters / Loan-Other) * Enhanced form letter fees to be able to specify the maximum number of times per month that an account may be charged for a specific form letter. * MAV Import (Italy) - ability to import more MAV formats * Buybacks / Flat Cancels - modified to not deduct outstanding fees when a buyback or flat cancel is entered * ODI - fixed bug in calculation of ODI based on Daily Arrears Balance * Form Letters - new ability to send out bulk form letters based on due to complete date * Bank Interface - New St George Credit Card Export Format - New "Scarti" (Italian) Import format * Experian Interface - fixed problem with unmatched actives appearing on Experian data export * GL Budgets - Fixed problem with Report Writer which showed incorrect ytd budget balance on reports Version 2.95 27 Feb 2006 Version 2.94 7 December 2005 * Arrears Calculations Prevent "Overflow Error" when calculating arrears on some accounts with incorrect due dates in the repayment schedule * Current / Non-Current Report Fix sequencing grouping bug which showed incorrect subtotals when grouping by business code. Version 2.93 21 October 2005 * Transaction Batch Report - Fixed layout problem which did not display dates properly because the time (hh:mm:ss) was being incorrectly included with the date, which meant it could not fit in the allocated space on the report * "Other Loans This Client" Report - Fixed bug which caused the report to not include all clients with multiple loans. * Transaction Import - Fixed minor spelling mistake when importing some transactions Version 2.92 29 September 2005 * Fixed bug which prevented changes to the repayment schedule for active loans * Fixed bug which showed negative instead of positive values on reports generated by the GL Report Writer * Fixed bug which put incorrect term on loans which were added using the "Insert_FM_Loans" stored procedure when the loan was settled towards the end of the month and had deferred payments. * Modified system to log potential problems with Paying Interest in the Investments ledger. The system now checks to see if payments may be going to the incorrect bank accounts. Warnings are written to the system log. The direct credit listing also flags payments which may have a potential problem. Version 2.91 6 September 2005 * Security Log The security log now shows before and after images of any changed data. * Payout Quotes Fix bug which counted ODI twice when creating a payout quote for a loan which had a business code which specified that ODI and Special charges behaved like debits. Version 2.90 26 August 2005 * Loan Repayments Fix "Write Conflict" error that pops up when you try to change a repayment. Version 2.89 25 August 2005 * Security Log A new Security Log lets you review changes made to key loan information on loans on a user by user basis. To run the report, select Development / Security / Security Log Report This report is only available to the DBO. * Create New User This option now lets you change the password of an existing user. It also lets you add or remove users from the DBO role. * Data Import New facility to import loan and client data from a CSV file as generated by the ACT! CRM system. See Development / Import / Import Data for more details. Version 2.88 (24 July 2005) * Repayment calculations Fix bug which used incorrect repayment calculation method when the business code did not have a method specified but the system parameters did. * Interest adjustments Fix bug caused when ODI is configured to behave as a debit, which caused the system to generate an incorrect interest adjustment transaction for accounts that have ODI charged. Version 2.87 (4 July 2005) * Investments Fix journal errors when paying out accounts. Create new ROI sub account when paying out ROI accounts. * Data Import New facility to import loan information from ACT! * Data Export CAIS V2 adjustments * Loan Transactions Fix inaccuracy in calculation for "E" type subledgers. Version 2.86 (17 June 2005) * Investment Transactions Fixed error that occurs when system tried to incorrectly post GL Transactions with NULL transaction dates. * Form Letters Fixed problem with overdue payments list which incorrectly repeated the last repayment due in the list. * Italy / MAV import / export New MAV import / export formats. NEw option to exclude bank code when generating MAVs * Investment Payouts Fix problem which generated too much interest when paying out accounts that had manual interest adjustments in the final month. * Maturity Analysis Fixed inaccurate balance projections for ROI accounts. Modified to only project balances for ROI accounts, other accounts show the current balance only. * General Ledger Statements Modified to show statement even if there are no transactions on an account for a given date range. Version 2.85 (30 May 2005) * Interest Rate Variations Fix interest rate variation problem which caused system to crash while altering an interest rate. The problem was caused because of a "Primary Key Constraint Already Exists" error. * Change Repayment Schedule Modified to correctly identify which entry in the schedule is the residual value. When the RV in the schedule is changed, the RV on the contract will be changed also. Fixed bug which caused scheduled payments of special charges to be changed when altering the contractual repayments on a schedule. Also added a new option to "Repair a Loan" which may have had balances incorrectly set when varying it. See Development / Tools / Repair a Loan. * Italy / MAV banking New functions to import various electronic banking information for the italian MAV interface. * Investments Fix bug which caused incorrect interest calculations when completing an investment, causing a balance to be left on the account after completion. * Payouts New facility to specify a Form Letter as the method for quoting a payout. If you do this, when requesting a payout quote, the system will create a form letter showing the payout quote. * Transactions System now prevents entry of payout / flat cancel / writeoff transactions if there are transactions on the account dated AFTER the date of the transaction being entered. System now allows entry of duplicate writeoff / flat cancel / payout transactions for the same account, provided they are in separate batches. It will not allow entry of these transactions in the same batch. It will only allow you to post one of those batches. Version 2.84 * Variable Rate Loans Fix bug which caused incorrect repayment amount to be calculated if the loan had monthly account keeping fees. * Form Letters New "Draw Down Fee" field. * Investment System Modified Maturity Analysis and Form Letter programs to correctly project the future balance of an account assuming no deposits or withdrawals are made. ROI (Reinvestment of Interest) accounts default to not "pay interest when due" when you enter them via the wizard. * External Interface. Stored Procedure "Insert_FM_Loans" now has the following parameters: @Account# varchar(20), @ClientNumber1 int, @ClientNumber2 int, @GeneralPurpose1 varchar(30), @BusinessCode varchar(8), @SettlementDate datetime, @InstalmentDate datetime, @PurchasePrice money, @Term int, @InterestRate real, @RepaymentAmount money, @LoanAccountNumber int output, @ErrorDescription varchar(100) output, @DontCheckTotalPayments int=0, @OverrideRepaymentMethod varchar(1)=NULL, -- NULL / M=Monthly / F=Fortnightly / W=Weekly @RepaymentVariationStart datetime=NULL, -- Date variation starts @RepaymentVariationEnd datetime=NULL, -- Date variation ends @OverrideRepaymentAmount money=NULL, -- Amount to pay @DeferInterestUntil datetime=NULL, -- defer interest until this date @Description varchar(58)=NULL -- A description of the loan Version 2.83 * Interest Only / Hybrid loans Fix bug which caused the repayment schedule of interest only and hybrid loans to be affected by ODI charges. ODI charges would be included with interest for the month when working out what the repayment amount should be. The system now correctly ignores any ODI or special charges. * Investment Sytem New facility to specify "Minimum Investment Amount" that is allowed for a business code. New facility to specify "Minimum Term" that is allowed for a business code. New facility to specicy a "Reinvestment of Interest" (ROI) business code. When this is enabled for a business code, the system will create a ROI account at the same time as a normal investment account is set up. Any interest credited to the main account gets transferred to the ROI account instead. ROI accounts can have a different interest rate compared with the main account, which allows interest to compound at a lower rate than if it was merely added back in to the main account. Invesment Maturity Analysis Report now shows the balance AS AT any given date rather than just the current balance of an account. If dated as at a future date, the balance will include any interest that is expected to be earned on or before that date. Investment Form Letters now have the following additional fields: <> - the Account# of an ROI account (if any) <> - the Balance of an ROI account (if any) <> - The balance of the account as at the "As At Date" * Delinquency System New BuyBack Recourse Report - Delinquency system can now select records based on any value in the GeneralPurpose Fields on a loan. Version 2.82 * Investment system Fixed bug which posted wrong journal when receiving a payout amount which was not exactly equal to the expected payout value. * Loans Modified wizard to allow entry of hybrid loans which have an interest- only period followed by a principal and interest period. * Drawdowns Modified Setup / Parameters screen to allow you to specify whether or not a drawdown transaction (type 'R') will affect the value of any outstanding repayment amounts. If the flag is set, the system will recalculate outstanding repayment amounts if the outstanding balance is affected by a drawdown. * Periodic Debits New facility to specify the type of transaction to create when processing periodic subledgers * Italy / RID Import Modified import routine to be able to handle RID and MAV dishonour transactions. Modified import routine to be able to handle lines in the import file that contain blank / null values. Previously this crashed the import. * Transaction Import Show an error for dishonor transactions that do not match an existing repayment transaction. * Transaction Posting Modified system to allow posting of reversal transactions of any value when posted to accounts "WRITEOFF", "SUSPENSE", "COMPLETE". * ODI Fixed bug which showed negetive ODI amounts for accounts that were paid in advance. * Delinquency System Allow selection of accounts by the number of times that they have been a specific number of days in arrears. * Direct Debits Fixed bug which occurred when you specified to "Reduce the direct debit amount if it would overpay account". The calculations were not taking into account any outstanding ODI. * Investments New option in Setup / Parameters to force the entry of bank account details when entering an investment. * Repayment Schedule Modified to show all borrowers and print a copy for each borrower. Version 2.81 * Form17 Report Fixed bug which caused report to crash when selection "output to printer" option. Improved error handling. Fixed "Invalid use of NULL" error. * Investments System Fix bug in investment system to post correct payout adjustment to the GL. Previously it was posting the tax amount by mistake. New facility to summarize interest credits and debits for accounts that do not receive interest payments monthly. For example, if interest is paid quarterly and you set this flag, you will only see one pair of interest credit / payment transactions on the clients statement for the quarter. Currently you will see an interest credit / payment transaction for each month in the period, regardless of when the account is paid interest. To enable this option, go into Setup / Parameters / General and tick the box which says "Summarize IV Interest Credits and Payments". Modified logic of interest run so that when it generates an interest credit, it will only credit interest for accrual transactions dated AFTER the previous interest credit. Modified Investment Form Letters for new fields: LatestInterestCredit, LatestInterestCreditDate Enhanced Investments System to allow interest rate variations for a group of investments by just changing the rate on the business code. This functionality also works if you want to change the interest payment frequency for a business code. The system will identify all accounts that will be affected, will show you a list of proposed changes and let you select which (if any) accounts will be updated. New bulk form letter facility for the investment system. This facility is available via Reports / Other Accounts / Create Multiple FormLetters * Delinquency System Fixed problem with missing identity column for the DE_Sequences table on some systems. Version 2.80 (24 February 2005) * Delinquency System fix problem with deli system not calculating all fields on reports for formats 5 thru 7 Report format 6 will only include action codes that have the "Include on report" flag ticked in Setup / System Tables / Action Codes. Action codes have a separate form to maintain them instead of via the System Tables general form * Posting Transactions Fix "commit transaction without begin transaction" bug * Investments fix interest accrual problems on investments that have a future first interest payment date * External Interface fix problem with "#" chars getting left in the Employers table when an attempt was made to insert invalid data Fix gross interest problem when inserting chargeable subledgers Version 2.79 (16 February 2005) * Delinquency System Fix "problem accessing a property or method of the OLE object" error messgae. Version 2.78 (15 February 2005) * Loan summary report Fix problem with loan summary report where account was completed, and had positive arrears balance after completion which should have been set to zero. * Form Letters Add "review date" to form letters - 6 months after settlement date. * Delinquency System Add the ability to specify 1 of 6 different report layouts that may be used when producing a delinquency report. Allow sorting / splitting by: Days since latest action date. Action Code General Purpose 2 Allow for a summary report to be produced at the end of report format 6. * Direct Debits New facility to specify lodgement reference to be used when producing a direct debit file. * Diary Reminders When entering a diary reminder you now have the ability to specify a a selection from a list of suggested ACTION CODES. You can add to the list of suggested action codes via Setup / System Tables / System Tables / Action Codes. * Loans When specifying a value for the General Purpose 2 field, you can now specify a selection from a list of suggested GENERAL PURPOSE 2 values. You can add to the list of suggested values via Setup / System Tables / General Purpose 2. * Transactions. Any loans which have a General Purpose 2 value that has the "Clear After Payment" flag set will have the general purpose 2 value cleared once a payment has been posted to the loan. * Overdue Interest New facility to specify: - The minimum Number of Days in arrears that an account can be in before ODI is charged. Previously this was set globally for the entire database via the "Days of grace" value in Setup / Parameters, but now it can be specified per business code. - The Maximum number of days in arrears that an account can be in before ODI ceases to be charged. This lets you "turn off" ODI for accounts that are excessively in arrears. - The maximum number of repayments in arrears that an account can be in before ODI ceases to be charged. This lets you "turn off" ODI for accounts that are excessively in arrears. - The Maximum ODI charge to be applied to an account. New ODI Method "A" which is a fixed fee per day. The amount of the fee is entered in the ODI RATE field of the business code. Version 2.77 (17 January 2005) * Investments Minor adjustments to the interest summary statement at the bottom of the investor statement, plus the new facility to be able to specify the range of dates that the interest summary should cover. * Direct Debits Modification to ensure transactions appear in the correct sequence when a loan has more than one borrower. * Italian Banking Interface New facility to import MAV numbers from a spreadsheet. Available via Transactions / "Import MAV" * System Management New facility to list all users and their associated Roles. Available via Development / Tools / "Role Members". Version 2.76 (16 December 2004) * Changing Schedule Fixed bug when you click on the "Change Schedule" button in the repayment schedule. The bug caused incorrect term and final payment calculations when altering the repayment amount of a loan. * Clients address Fixed bug which caused the cursor to skip over the postal town when tabbing through a customers address. * Entering Transactions Fixed bug with "DUP" button which crashed while trying to duplicate transactions with quotes in the reference or the narrative. Fix bug which prevented the entry of reversal transactions on a lease when only one repayment had been received. * Delinquency System A new report format is available which shows the "General Purpose 2" field instead of the phone number. Fixed bug which prevented deli system from listing accounts that were complete even if the report criteria specifically requested completed accounts. * System functions Fixed problems with WinXP when trying to register OCX controls. Prior to this the system would not install properly, and continually try to register the XJPG20.OCX file. The system will now force all objects in the database to be owned by DBO when upgrading. This fixes problems where some users were logged in with an Admin account that was not part of the db_owner role, which created objects owned by them and not DBO. * Loan Summary Report Fixed bug in arrears calculations for accounts in advance with arrears adjustments. Version 2.75 (2 December 2004) * Transactions The system will now prevent you from entering more than one payout or reversal per account per batch. This prevents the situation where you could enter more than one payout, or more than one reversal for the same account in the same batch, which caused processing errors. * Loans Fixed bug which prevented you from deleting a loan that had delinquency system targets associated with it. * Delinquency New format of delinquency report to show General Purpose #2 field. Fixed bug which showed incorrect delinquency percentages in some circumstances. Fixed bug which showed incorrect Net Balance + Arrears figure in some circumstances. Version 2.74 (4 November 2004) * Form Letters Fix "String or Binary Data would be truncated" error when trying to print form letters for accounts with long bank account names. * Transaction Posting Prevent posting of more than one payout, reversal, flat cancel, or buy back to the same account in the same batch. * New Client Wizard Fixed bug which did not select all the matching accounts when you entered a surname but no given names for a client when using the new client wizard * Loan Summary Report New facility to group and subtotal by General Purpose 2 column * Investment System New facility allows DBO to change the business code on active investments. Version 2.73 (28 October 2004) * Asset Register Fix bug which showed incorrect amounts when an asset was sold at a loss or for NIL consideration * Investments New facility to allow rolling over of maturing investments into a new account rather than back into the same account. New View that may be useful for printing form letters for investments if you want to connect directly from the MS-Word mail merge facility. Use view IV_FormLetterView * Italian MAV formats Allow selection by either settlement date, account# or both. Fix bug when trying to select by settlement date only, or by Account# only. * Loan Transactions The system will now prevent you from entering or posting a reversal transaction where the value of the reversal exceeds the total value of payments received to date on the loan and the loan is active. Version 2.72 (14 October 2004) * Delinquency System Ensure "LoanStatus2" column can be used in the selection logic of Delinquenct Reports. * Investments Fix problem with interest calculations on investments. Interest will always be calculated up to the maturity date of an investment when paying it out, and up to the rollover date of an investment when rolling it over. * MAV Export Fix authority error when someone other than DBO tried to create a MAV. Modify export program to be able to select by account number range as well as date range Modify export program to be able to select only those accounts that have "MAV" ticked on the client banking details. Modify the Client banking form to allow you to specify whether or not a clients loans should be paid by MAV. * Clients / Loans / Investments New facility on Setup / Parameters / General to allow you to specify the minimum width of an account number or a client number. Account and client numbers will be padded on the left with zeroes to ensure they are at least as long as the width specified in the minimum width field. * Client Wizard. Fixed bug which would prevent entry if you had enabled the facility to ensure a bank account name was entered. Version 2.71 (12 October 2004) * MAV Export Fix big "OututTo Command is not available" which occurs in some situations when trying to export a MAV file to an Excel spreadsheet * Investment System Fixed bug which charged interest up to the date of the payout instead of the day before when paying out an investment. * Investment Payout Screen Fixed minor formatting issue which did not format the payout date properly. Version 2.70 (6 October 2004) * Italian Banking The ability to create, export and import MAV files for Italian banks via the Transactions / Export MAV file function There is a new tab on the Setup / Bankaccounts screen to let you set up the data for the MAV file. * ODI calculations A new type of ODI calculation (Type 'N') allows you to calculate ODI based on the daily arrears balance of the loan using a rate based on the NET Effective Interest rate PLUS the margin entered in the "ODI Rate" Field of the business code. * Fixed Assets Fixed a bug with future Disposal dates and Disposal amounts on asset register. E.g. when producing the asset register as at a prior date when an asset had been disposed of after that date. * Loan Summary Report Fix loan summary report to not include arrears adjustments twice. Adjustments were already taken into account in internal arrears calculations, so there was no need for the report to also take them into account. * Form Letters Modified to allow printing of payout quotes as at 7 days from the as at date of the form letter. * Direct debit run Fix lockout problem with direct debit run which made the system unavailable to other users when the direct debits were being created. * Add bank account validation functions: Add a flag in Setup / Parameters to specify whether or not the system will confirm if the bank account name is different from the loan account name. Add a flag in Setup / Parameters to specify whether or not to Enforce entry of Customer's bank account name if customer has direct debits enabled. Extend size of Customer's bank account name to 100 Characters. Add a flag in Setup / Parameters to specify whether or not to ensure Customer's address as a minimum contains at least : Town, County and Post code Add a flag in Setup / Parameters to specify whether or not to ensure entry of TFN in tango. Add an option in Setup / Parameters to specify an Edit picture for the TFN. New facility to record the updates and the person that updated the bank information in the diary notes. * Transaction Entry Removed type "X" transaction which is not processed by Tango * Client Selection Fixed bug which prevented you from scrolling to the end of a long list of clients when viewing lots of clients with similar names. This usually happened when using lower screen resolutions. * Customer Statements New flag to exclude accounts that have zero balances when producing statements for multiple accounts. * External User Interface. New stored procedure for adding new transactions prior to posting them: CREATE PROCEDURE [dbo].[Insert_FM_HeldBatches] ( -- The primary key of the loan (may be omitted if you supply @Account#) -- If omitted, system will use the primary key of the loan -- with the Account# you specified @LoanAccountNumber INT=NULL, -- The Account# of the loan (may be omitted if you supply @LoanAccountNumber) -- If omitted, system will use the Account# of the loan -- with the LoanAccountNumber you specified @Account# VARCHAR(20)=NULL, -- The value of the transaction (Mandatory) @TransactionAmount MONEY, -- The date of the transaction (Mandatory) @TransactionDate DATETIME, -- A short description of the purpose of the transaction, which will be displayed -- on the customers statement. @Narrative VARCHAR(100), -- A reference code for the transaction, which will be displayed on the customer -- statement. @Reference VARCHAR(20), -- The type of the transaction. (Mandatory) -- Valid types are: -- 'P' Loan Repayment -- 'F' Flat Cancellation -- 'B' Buy Back -- 'Z' Reversal of repayment (Note, transaction amount must still be positive) -- 'O' Payout -- 'L' Write-Off (Note, transaction amoutn should contain the actual amount of -- cash received with this transaction, NOT the amoutn written off) -- 'D' Sundry Debit -- 'C' Sundry Credit @TransactionType CHAR(1), -- The batch number to be assigned to the group of transactions you're inserting. -- If you leave this null (recommended) it will be updated to contain the next -- available batch number. You should then use this batch number for all subsequent -- transactions that are inserted as part of this group. @BatchNumber INT=NULL OUTPUT, -- The GL Account to be debited as a result of this transaction -- May be omitted, in which case the system will work out the account to use -- based on the loan's business code @GLDebit INT=NULL, -- The GL Account to be credited as a result of this transaction -- May be omitted, in which case the system will work out the account to use -- based on the loan's business code @GLCredit INT=NULL ) Version 2.69 (17 September 2004) * Import Repayments New facility to import italian MAV files New Facility to alter the date of transactions after they have been imported * Asset Register Fix bug with depreciation values on assets that were disposed of after the asat date of the report. Version 2.68 (15 September 2004) Direct Debits. * If you TICK the box to extend direct debits for accounts that are past their maturity date but still in arrears, AND also TICK the box to reduce direct debits on transactions which would over pay a loan when paying out, then the system will NOT adjust the value of a direct debit when extending it on a loan past its maturity date. * Import Repayments New facility to import Italian RID files. * General Ledger Fixed problem on some databases where the "Reference" column on the GL TRansactions table was only 8 characters wide instead of 20 characters wide Version 2.67 (3 September 2004) Investment System * modify investment system to be able to include interest for the day of the payout * fix error in investment payout logic when account paid out and had outstanding accrued interest * fix payout investment payout quote which incorrectly included accrued interest already paid when doing a payout quote * Additionl logic to ensure that all investments have an associated bank account for direct credits where possible * Fix totalling errors in ABA file for Investments Loans Systemn * modify arrears calculations to optionally show an amount as being in arrears on the day it is due, rather than on the day after. This is controlled by a flag in the System Setup screen * Enhance external interface to allow insertion of loan subledgers with a calculation method other than '$' General * Fix bug with copy_database stored procedure that lets you duplicate databases * New "GetGLAccount#" function to make queries easier Version 2.66 (16 August 2004) * Setup / Parameters On the Setup / Parameters screen there is a new prompt on the "General" tab asks "Number of characters to prefix on all new client numbers based on the first few letters of the client name (0 for none)" This allows you to get the system to create client numbers that are prefixed with the an alpha code based on the client name. For example, if the next client number available was 10001, and the new client was John Smith, the new client number generated by the system would be SMI10001. The number of alpha characters at the start of the client number is dependent on the value you put in the "Number of characters to prefix" prompt in the Setup screen New facility to change the next client number and next account number of a new loan. Objects: frmSystemSetup, frmClients, modClients, modNewClientWizard * Investments Modification to the Investments form to specify whether or not users are allowed to change the interest rate on a deposit. There is a new hidden control called "txtCanChangeInterest" on the Investments form (frmIVAccounts). If a users role is authorized to this control (via the Security System) then they will be allowed to change interest rates on active deposits. Otherwise, they will only be able to change interest rates on new deposits that have not been activated yet. Objects: modIVAccounts, frmIVAccounts * Banking If you try to change the banking details of a client, and that client has other loans or deposits that have overridden banking details that also refer to the same account, the system will ask if you want to automatically update those accounts. Objects: frmClientsBankingSubform * Investments If you type an investment account number into the "Other accounts" prompt on the search screen, the system will display the details of that account. Prior versions had a bug which cause the system to not display the account name, or let you change the banking details of the deposit. Objectts: frmCLSelect * New Client Wizard / Loans Form Fixed a bug which caused an error screen to pop up whenever you tried to view the repayment schedule of a loan. * Italian direct debits Fixed bug in layout of RID export file * Delinquency System Fixed problem which caused incorrect numbers of accounts per split when splitting portfolios in Name sequence. * Arrears System On the "Main" tab the Setup / Parameters screen there are new prompts which ask: "Arrears Balance does not change when account reaches maturity date" and "Number of days in arrears does not change when account reaches maturity date" This allows you to specify that when an account reaches its maturity date, the arrears calculations will proceed as they did prior to the maturity date. If you don't tick these options, the arrears balance will be set to be equal to the NET BALANCE of the loan after maturity, and the number of days in arrears will be set to the number of days since the account matured. * Maturity Date When calculating the maturity date of a loan, the system will ignore any special charges that may have been levied on the account since it matured. Prior to this, entering a special charge on a loan that was past its maturity date would cause the maturity date to be reset to the date of the new special charge. * Investment System Fixed rounding errors when calculating interest on deposits / investments. Fixed bug when calculating interest on deposits / investments which caused the system to ignore any new accounts that settled on the last day of the month. * ODI Calculations Fixed bug when calculating ODI on accounts that had no repayment schedule. Version 2.65 (30 July 2004) * Current / Non-Current Report Fix bug with totals on detailed report. Fix bug which showed non-summarized report even when you requested a summarized report. * Interest Only Functionality ** New flag in Setup Information says: "Interest Only Loans may have repayment frequencies other than monthly" This ensures that if you want the system to update the repayment amount of an interest only loan each month to match the interest that was charged on the loan, the system will be able to handle the case where a loan pays quarterly, six-monthly, annually, etc. Prior to this, an annual payment on an interest only loan was forced to be equal to the interest charged on a monthly basis, which was incorrect. ** New field in Setup Information says: "Offset Days" This allows some flexibility when the payment for an interest only loan may fall on the 28th, 29th, 30th or 31st of the month, or even on the 1st or 2nd of the following month. The "Offset Days" value ensures that any repayments due before the "Offset Day" of a month will be deemed to be payments of interest charged in the prior month. ** New Interest Only fields in the Business Code form: "Enable Interest Only Functions" should be ticked if you want to provide any sort of interest-only functionality for the business code. When ticked, you will see the following fields: "Interest Only Loans should have their repayments automatically updated to match the actual interest that has been charged" ONLY tick this field if you want the system to change the repayment amounts in your interest only loans to match the actual amount of interest that was charged. DON'T TICK this field, if you want the system to change the amount of INTEREST charged to an interest only loan so that it matches the repayment amount due during that month (or before the offset day in the following month). "Loan will be interest only until it matures" Tick this box if the loan is interest only until it matures. DON'T TICK this field if you would like the loan to revert to Principal and Interest after a set period of time. If you don't tick this box, the following field is displayed: "Number of months that a loan should run as an Interest Only loan before reverting back to a normal principal and interest loan" Enter the number of months that the loan should be interest only. After this number of months, the loan will have principal and interest payments. As a result of this change, any interest only loan now has a new flag in the repayment schedule which lets you specify whether a specific repayment in the term of the loan is actually a principal repayment even though repayments before and after it may be interest only. For example you might want a loan to make $1,000 interest payments each month for 10 years, but make $10,000 principal payments in the 3rd, 6th and 10th years. * Banking interface A new facility in the "Direct Debit Override" screen lets you specify an alternative bank account or credit card from which monthly repayments may be made. This can be different from the banking details on the Client's screen, which means that a client can have several loans, each of which may be paid out of a different bank account each month. If you specify an override, a message will appear at the bottom of the repayments tab of the loan to warn you that the banking information has been overridden. * Form Letters New "ThisYearPaymentsDue" field lets you output on the form letter the total value of payments that were due to be paid this financial year. * Schedule Of Borrowings Now refers to the General Ledger when calculating the interest earned for the year. * Other Loans This Client Report now runs faster. Report can now be run for all business codes. Report is sorted by Client# * Daliy Interest Earned Report Fixed bug which caused report to crash when running it over a period of time prior to which a loan in the report had not yet started. * Arrears Summary on Loans Screen Fixed bug which showed outstanding arrears even after the loan had completed. * Credit Rating The Loans Tab on the Clients Form now shows a credit rating, which is a 3 character code denoting the creditworthiness of the client. It is calculated as follows: The first character is a letter from "A" to "G". "A" means the customer has been no more than 30 days in arrears for all loans that they have ever had "B" means the customer has been no more than 60 days in arrears for all loans that they have ever had "C" means no more than 90 days "D" .. 120 days "E" .. 150 days "F" .. 180 days "G" .. more than 180 days. The two digits after the letter denote the total number of times that the customer has been in arrears. A11 means they have been in arrears 11 times but have never been more than 30 days in arrears at any one time. D20 means they have been in arrears 20 times but have been up to 120 days in arrears at any one time. * Delinquency System A "C" or "D" will appear on the rightmost column of the report to denote whether or not the client pays by direct debit or credit card. The readability of the report is improved by using alternating shading on each line. * Transaction Audit Report Process New Loans Report Changed size of the totals fields at the bottom of the report because they were too small for larger totals. Version 2.64 (23 July 2004) * Investment System New Maturity Analysis Report Fix "String or Binary Data would be truncated" error when processing new investments. Fix problem with Null opening balances when processing new Investments. Fix incorrect calculations when working out how much accrued interest was still unpaid on an account. Improved layout of Statements Change narrative of adjustment transaction to "adjustment" instead of "writeoff". New Form Letter Facility for Investments New Select_IVFormLetters SP which can be used as a datasource for form letters. New "InvestmentTerm" keyword for form letters. New facility to put a message at the bottom of statements. * Direct Debits Fix data formatting problems with Italian RID direct debits. * Payout Quotes Fix problem with residual not showing as part of the payments due. Fix inaccuracies with Discounted Present Value rebates. * Form Letters Fixed inaccuracies when calculating the gross amount of ODI that had been charged on an account. Some older accounts from IBS did not record ODI transactions but still had and ODI balance. * Delinquency Reporting New "Exclude Current Month Arrears" flag in Development / Delinquency / Reports. When set, an account will be excluded from the report if the arrears balance LESS payments due for the current month fall below the arrears threshold * ODI Fees If you charge an ODI fee, it will not be applied if the amount of arrears is less than the arrears threshold or the number of days in arrears is less than the days of grace. * Partial Banking Details Facility to Export this display to Excel. Version 2.63 (6 July 2004) * Loan Activity Report - Enhanced Shading to improve readability * Arrears calculations Fix problem with arrears showing as gross balance when account past maturity Fix problem where account showing as in arrears when due today * Delinquency Fix 'Cannot insert NULL in DE_Targets' error * Balance calculations Fixed problem that generated errors when calculating balances on accounts with transactions that had null amounts. * External interface - Employers Fix problem which generated duplicate employer codes when trying to add employers without supplying an employer code while using the external interface. * Investments Fix problem with Investment Payouts where SUSPENSE transaction type is not defined Fix problem with doubled up interest credits when paying out an account * Direct Debits (Italy Format) - Use Account# instead of UserField4 for "Code of your customer (98-113) in "10" row when generating RID data. - Fixed error in footer record that output an 'ER' string instead of an 'EF' string to denote the end of the export file. * Form Letters Add insurance info to form letters. Allow exclusion of accounts from form letters based on arrears balance. * External Interface - Loans. Added new "DeferInterestUntil" parameter to the "Insert_FM_Loans" stored procedure, whose calling convention is as follows: ALTER PROCEDURE dbo.Insert_FM_Loans /* Add a new loan */ ( @Account# varchar(20), @ClientNumber1 int, @ClientNumber2 int, @GeneralPurpose1 varchar(30), @BusinessCode varchar(8), @SettlementDate datetime, @InstalmentDate datetime, @PurchasePrice money, @Term int, @InterestRate real, @RepaymentAmount money, @LoanAccountNumber int output, @ErrorDescription varchar(100) output, @DontCheckTotalPayments int=0, @OverrideRepaymentMethod varchar(1)=NULL, -- NULL / M=Monthly / F=Fortnightly / W=Weekly @RepaymentVariationStart datetime=NULL, -- Date variation starts @RepaymentVariationEnd datetime=NULL, -- Date variation ends @OverrideRepaymentAmount money=NULL, -- Amount to pay @DeferInterestUntil datetime=NULL -- defer interest until this date ) * ODI (Flat Fee) If you charge a flat fee ODI amount when accounts fall into arrears, the system will now take into account the number of days of grace before charging ODI. An account that is not in arrears by at least the [Days of Grace] number of days will not be charged the flat fee. * Investment Payouts Fix bug in investment system that would not permit a payout on an account which had a payment dated after the maturity date * Delinquency System Improve performance of Delinquency system when using type-3 formatted reports which incorporating balance info from last month when working out delinquency percentages * Investment System Added form letter capacity to the Investment system. * External Interface - Creating Business Codes New facility to duplicate an existing business code in order to create a new one. Calling convention is as follows: CREATE PROCEDURE Duplicate_BusinessCode /* Allows duplication of existing business code into a new business code */ ( @NewBusinessCode varchar(8), -- business code to create @NewDescription varchar(40), -- description of new business code @OldBusinessCode varchar(8) -- business code to duplicate from ) * Investment System Tidied up the Accruals and Payments history screens. Tidied up the "Other Accounts" search screen. Version 2.62 (1 June 2004) * Writeoffs Fixed error when clicking on the "Report" button in Process / Writeoffs * Introducer Reports New facility to analyze data based on any of the Business Code, General Purpose or Classification fields. This means you can analyze introducer / dealer performance regardless of whether you store the introducer / dealer code in the "GeneralPurposex", "Business Code" or "Classification" columns * Direct Debits - Ireland EMTS facility Direct Debits - Italy RID facility Fixed minor formatting problems with export file. * Investment System Interest Run Fixed inaccuracy in calculations which ignored interest accruals in some situations * Loan Summary Report Now Shows Comparison / Yeidl Rate on report when you select the "Simple Format". * Australian Post Codes Fixed problem with NT post codes which were leaving out the leading zero. * Form Letters Fixed "Zero Divide Error" which occurred when printing form letters for accounts with residuals where the date of the form letter was prior to the first or second payment due date. * GL Report Writer New "Consolidate" command. If you have data in several databases, and want to consolidate totals for all databases, use the Consolidate command in the report writer to specify which databases should be included in the consolidation. Version 2.61 (24 May 2004) * Writeoffs New flag in Setup / Parameters to specify whether or not to apply early payout fees when writing off a loan. * Posting Transactions Fixed bug which generated the wrong amount of backdated interest when an account has a "Defer Interest Until Date". Modified to ensure you can't enter a payout or a payout reversal in a batch that has other transactions for the same account. This prevents incorrect entries being generated when you post payout transactions. Fixed bug which posted incorrect GL journals when reversing ODI payments. * Experian Interface Fix bug which was selecting loans incorrectly when generating data for export. * Payouts Fixed bug which left non-zero balance on paid out accounts in some circumstances. * Current / Non-Current Analysis Fixed bug with calcualtions of figures when using the 5 year expanded format of the report. * External SP Interface "Insert_FM_Loans" Fixed problem with incorrect term on deferred payment loans. Modified to allow specification of new parameters: @OverrideRepaymentMethod varchar(1)=NULL, -- NULL / M=Monthly / F=Fortnightly / W=Weekly @RepaymentVariationStart datetime=NULL, -- Date variation starts @RepaymentVariationEnd datetime=NULL, -- Date variation ends @OverrideRepaymentAmount money=NULL -- Amount to pay * Processing Subledgers Fixed bug which duplicated GL journals in some sicrumstances. * External SP Interface "Insert_FM_LoanSubledgers" A new interface that lets you add a subledger to a new loan. Called as follows: EXEC Insert_FM_LoanSubledgers @LoanAccountNumber int, @SubledgerCode varchar(5), @SubledgerValue money * ODI calculations Fixed bug which generated incorrect loan balance when posting ODI and special charge payments during a payout. NOTE. This upgrade will also fix the balances of any loans that were adversely affected by this bug. In otherwords if you have loans that have incorrect balances due to ODI / Special Charge transactions, upgrading to this version will change the balance on those loans to what it should be. * Import from IBS Fixed bug which generated incorrect Gross Balance when importing loans from IBS. * Banking Interface Increased the maximum size of the TFN, BSB and Bank Account columns to accomodate banking information for Italian and Irish bank accounts. New Italian "RID" format for Direct Debits. New Irish "EMTS" format for Direct Debits. * External SP Interface "Insert_FM_Clients" Modified to handle larger banking columns. Modified to allow entry of new parameters: @UserField2 varchar(30) = null, @UserField4 varchar(40) = null, @UserField5 varchar(40) = null, @UserField6 varchar(40) = null, @TFN varchar(20) = null * GL Journals Fixed problem with some clients where the GL Journal Reference was 8 characters instead of 20 characters max. * Investment Account Summary Fixed bug which excluded accounts from report when they had no interest credits. * Investment Payout Quote Fixed bug to not count interest accruals twice when calculation payout amount. * Loan History Table Add "DateEntered" timestamp column to determine when a history row was added. * Client Search Screen Subledger Search Screen Business Code Search Screen GL Account Search Screen Fixed bug which caused search screen to grey out when you logged into a different database. * Investment Statements Fixed "ODBC" error when trying to display Investment Statements. * Interest adjustments Fixed "Out by one day" error when entering an interest adjustment for an account that had an interest free period on it. * Loan History Table Add date / timestamp to table. * Client Form Now shows the total amount written off for any client loans. * Banking Import Changed ANZ transaction import routine to use the dishonor date of a transaction rather than the file date when importing details of dishonored payments. * Heartbeat Monitor Changed refresh rate to 3 minutes instead of 5 seconds to reduce server bandwidth usage. Version 2.59 (8 March 2004) * ODI Calculations - New facility to calculate ODI based on the arrears position of the account during the previous month rather than the month during which the interest run is done. * Business Codes - New facility to specify whether or not a direct debit variation should be added to loans which are past their maturity date but still in arrears * Import / Export - Modify Insert_FM_Clients SP to fix bug with adding Employers Modify Insert_FM_Employers SP to fix bug with adding Employers Modify Select_TransactionSummary_User01 SP to include extra business codes Modify Inser_FM_Clients sp to allow specification of UserField1 column * Bad Debts Fix GL posting error when reversing bad debt transactions * Form Letters Modify Form Letters to show monthly and fortnightly repayment amounts Modify Form Letters to show direct debit fees * Payout Quotes Fix payout quote to count correct number of months when deciding if to charge Early Payout Penalty * Backdating Interest Fix Posting inaccuracies with backdating interest * Mortgages New facility to print Qld Treasury Form 17 form for housing co-op loans * Interest Charges Fix bug which ignored transactions of the same amount that occurred on the same day. Version 2.58 (19 February 2004) * Payouts Modified posting program to handle early payout penalties correctly. Previously the penalty was applied one month too early. Modified to handle reversal of payouts when a fee is charged on overpayments. * Form Letters Modified to handle early payout fee correctly. Modified to stop blank form letters from printing instead of valid form letters. (Affects consumer credit payout quote) * Receipt Allocation Report Modified to show correct amount of interest allocated when accounts that were in arrears in previous months eventually made a payment. * Interest Calculations Fixed inaccuracies in interest calculations when: - Interest calculations spanned more than one month - Special charges behaved like debits and existed in the range of the calculation - Transactions were backdated do a date other than the last day of the month * Creating new users Improved routine to handle domain users as well as SQL users Improved branch users routine to make it easier to add branch users. * GST / Stamp Duty calculations Improved accuracy of calculations when GST and Stamp Duty both applied to a repayment. * Inertia calculations Fixed problem which caused accounts to go into inertia one month earlier than they should have. * Multiple form letters Allow selection by payment method * General Purpose User Stored Procedure: Select_TransactionSummary_User01 Modified to include business code in the result set * External Program Interface New Stored Procedure Insert_FM_LoanSubledgers ( @LoanAccountNumber int, @SubledgerCode varchar(5), @SubledgerValue money ) Allows adding of subledgers to new loans via a program interface. Existing Stored Procedure Insert_FM_Loans. New parameter list: ( @Account# varchar(20), @ClientNumber1 int, @ClientNumber2 int, @GeneralPurpose1 varchar(30), @BusinessCode varchar(8), @SettlementDate datetime, @InstalmentDate datetime, @PurchasePrice money, @Term int, @InterestRate real, @RepaymentAmount money, @LoanAccountNumber int output, @ErrorDescription varchar(100) output, @DontCheckTotalPayments int=0, @OverrideRepaymentMethod varchar(1)=NULL, -- NULL / M=Monthly / F=Fortnightly / W=Weekly @RepaymentVariationStart datetime=NULL, -- Date variation starts @RepaymentVariationEnd datetime=NULL, -- Date variation ends @OverrideRepaymentAmount money=NULL -- Amount to pay ) * Direct Debits New facility to extend direct debits beyond the maturity date of a loan if the loan is in arrears when it reaches maturity. New flag on business code to allow this. The actual processing for this logic occurs during the monthly interest run * Delinquency System Fixed bug which excluded accounts that were not in arrears when the report definition specified not to. * Invoice Discounting New facility to list unfunded invoices on the purchase report Version 2.57 (30 Januaey 2004) * Interest Charges Fixed low level problem which caused unpredictable errors to occur when doing: - Payout Quotes - Payouts - Interest Run - Form Letters * New Client Wizard Fixed problem which caused wizard to skip a page when entering new investments. Version 2.56 (29 January 2004) ****************************** ****************************** ** ** ** IMPORTANT!!! ** ** ** ****************************** This version REQUIRES SQL Server version 2000. If you're running SQL Server version 7, DO NOT INSTALL THIS VERSION * Current / Non-Current Report Modified to split balances into current, 1-5 years and > 5 years. * Form Letters Fixed bug which prevented form letters from being printed if the database was up to date, but users were running older versions of Tango. * Transactions Fixed bug which caused GL journal to be posted the wrong way around when entering a backdated transaction that generated backdated interest transactions. Fixed bug which incorrectly paid out accounts with small balances outstanding when the account had outstanding special charges. Fixed bug which ignored special charges when calculating the net balance on accounts where ODI and special charges should affect the net balance. * Interest charges Fixed bug in interest calculations when working out the remaining interest on a loan where the payout date was more than one month after the last interest run date, * Loan Summary Report Now shows the "General Purpose #2" column New option to only show accounts that have a non-blank "General Purpose #2" column Version 2.55 (21 January 2004) ****************************** * Transactions Modified to ensure that fractions of cents can not be added to transaction amounts, and all transaction amounts will be rounded to the nearest cent. Fixed bug with backdated transactions which caused the wrong sign to be applied when payment reversals were backdated. * Subledgers New calculation method ("E") to allow subledger values to be based on the Net Repayment amount, as opposed to the "R" calculation method based on the Gross Repayment amount. * CARDFAST credit card interface Fixed bug with layout of the CardFast export file. * Non-Direct Debit Fees There is an option "Non Direct Debit Fee" which can be levied on any transaction not received via direct debits. The system has been modified to make sure this fee is not charged on payouts. * Direct Debit Processing Fix bug with dd's not being selected if several were due on the same day and one had already been paid. * Form Letters New "InterestToPriorDay" and "ODIToPriorDay" keywords which are useful for printing payout quotes where interest is charged up to the day prior to the day of the payout quote. New facility to specify that only one form letter should be printed per account. New ability to detect if MS-Word 2003 is installed, and use it. * Payouts New fee to debit accounts that over pay their balance when paying out their accounts. The "Small Balance Admin Fee" is charged when an account pays out and the amount recieved is greater than the payout quote for the account. Early Payout Fees now have the option to not be charged on interest free loans or on interest deferred loans that are still in their interest free period. * Loan Summary Report Modified to include negative arrears balances where appropriate. * Repayment Calculations New flag on business codes to specify whether or not the residual value should be paid on the same day as the last rental, or one month after that date. Modified repayment calculations to take into account how the residual value is paid. Fixed bug which calculated incorrect repayment amounts when both stamp duty and GST were payable on repayments. * Customer Statements New option to show payout quote at the bottom of a customer statement where the balance on that statement is negative, but there are still outstanding fees payable on the account which prevent it from being paid out. Version 2.54 (12 December 2003) ******************************* * Cheque Cashing. Built in new safety mechanism to ensure Cheque Cashing contracts don't get selected for direct debits even if they don't have valid Cheque details. * IBS to Tango Conversion Fix import problems with loans that had no repayments but just one residual payment. * BPAY Import Modified system to get effective transaction date from postition 98 of the import file. * Subledgers New "E" (% of Net Repayment) subledger type to assist with leases where Stamp Duty and GST are both levied on the net repayment but not on each other. * Form Letters Put "Total Arrears" keyword back into Form Letter system New "WriteoffAmount" keyword. * Payouts New facility to prevent early payout fee on loans where the loan has a defer interest until date, and the loan is still in its interest free period. Added a new check box to the Business Code screen to allow you to specify whether or not to use this option. New facility to prevent early payout fee on any interest free loans. Added a new check box to the Business Code screen to allow you to specify whether or not to use this option. * Backdated Transactions If you enter a backdated interest transaction to an account, the system will only calculate resultant interest adjustments for future periods from the day AFTER the original adjustment. Also, the system will generate adjustments dated as at the end of EACH MONTH after the original adjustment. NOTE that this only applies to backdated INTEREST transactions. Any other sort of bacjdated transaction will only generate one interest adjustment as at the date of the last interest run. * Loan Activity Report New facility to select by account range. * Times in arrears report Fixed bug when running the report while being logged into only some of the available branches. * Subledger History Report Modification to allow selection of only holdback accrual subledgers * Insurance Premium Renewals Fixed "Invalid Use of Null" error. Version 2.53 (4 December 2003) ****************************** * Welcome Calls ------------- Change sequence of report when printed in format #2. * Investment System ----------------- Final pre-release modifications. The investment system is now ready for use. Please contact Tango Financial Soutions Pty Ltd on 07 3245 8030 if you are interested in using Tango32 to pay interest on Depositors accounts. Special thanks to Jacqui Ault for her tireless efforts on this project. * Construct Past History Fixed bug which caused history generation process to crash with a "numeric overflow" error. * Import BPAY payments Modified to correctly import transaction date of BPAY transaction instead of Posting Date. * CardFast credit card export Modified format of CSV export file to put quotes around credit card number to prevent Excel from showing an incorrect card number in scientific exponential notation. * Backdated Payments New facility to calculate an interest adjustment on transactions posted to an account prior to the last interest run date of the loan. For example, if you have already calculated interest on an account for November, and want to post a payment or debit to the account for October, the system can calculate an interest adjustment on the account and date it as at the date of the last interest run. To turn this feature on, Go into Setup / Parameters / Interest Charges and check the box which says: "Create Interest Adjustment when a backdated transaction is entered". * Loan Summary Report Fixed bug which caused an "Invalid column name 'ArrearsAdjustment'" error. * Version Upgrade Routines Enhanced system to speed up the time it takes to install new versions when applying Database Upgrade scripts. * Direct Debit Creation Fixed bug which caused various SQL errors to occur when entering more than one or two selection criteria. (Tech Explaination: Fixed SQL string truncation error). * Subledgers Fixed (Autonumber) error which popped up when trying to add a new subledger Version 2.52 (27 November 2003) ******************************* * Investments ----------- Extensive new investment functions for the management of depositors accounts * IBS to Tango Import ------------------- More logic to be able to handle customer names in the form: GivenNames Surname Previously, it could only handle names in the form: Surname, GivenName Or Surname1, GivenName1; Surname2, GivenName2 Or Surname, GivenName1 and GivenName2 * Other Loans this Client ----------------------- New report to show all loans belonging to a client. * Arrears Calculation ------------------- Fixed problem which showed incorrect arrears on Loan Summary report when a loan had a positive arrears adjustment * Import Repayments ----------------- New import format which allows importing from a CSV file with the following format: Colum Heading Meaning ------------- ------- company_id (Spare) employee_id = Reference line_no (Spare) component_id (Spare) cost_id (Spare) quantity = TransactionAmount rate (Spare) ref = Account# payrun_id (Spare) pay_no (Spare) pay_group_id (Spare) pay_freq (Spare) currency_id (Spare) exch_rate (Spare) pay_date = TransactionDate pay_method (Spare) component_type (Spare) component_name (Spare) dcif_flag (Spare) paycash_flag (Spare) emp_fname = narrative emp_lname = narrative comments (Spare) branch_id (Spare) dept_id (Spare) cost_id (Spare) division_id (Spare) * Transaction List ---------------- Fixed error which occurred when you double-clicked on an account in the list, or tried to export the list. * Reports ------- Fixed problem which caused reports to default to Letter instead of A4 format. Version 2.51 (20 November 2003) ******************************* * Arrears Adjustments ------------------- Fixed problem where arrears adjustments incorrectly affected the arrears balance of a loan as it was displayed on the loan summary report * Loan History ------------ Normal users are not permitted to delete loans that have history records. The system will only allow this to be done by administrators, but tje system will display a warning about how deleting old records could cause the balance on backdated reports to change and affect reconcilliations. * Registry Settings ----------------- The security / registry settings option now allows up to 250 characters for a registry setting (increased from 50 characters) * Times in Arrears Report ----------------------- New report to show the number of times that an account has been in arrears. * Defaults -------- Fixed bug which caused the system to stop remembering values typed into fields on report prompts. For example, the delinquency system "Exclude arrears less than" prompt kept defaulting to $25.00 even though it is a remembered field, and is configured to remember the last value that you typed into it. Version 2.50 (18 November 2003) ******************************* * Loan Summary Report ------------------- Fixed bug which did not properly select accounts by the number of days in arrears. * Delinquency System ------------------ Fixed bug which prevented Delinquency Report from displaying on the screen. * Form Letters ------------ Fixed bug which prevented form letters displaying the Account# when printing one form letter per Account, if you used the "AccountNum" merge field. Version 2.49 (14 November 2003) ******************************* * Multi-currency -------------- You can specify different currencies per database by entering a new currency symbol via Setup / Parameters / General / Currency Symbol * History Transfer function ------------------------- Fixed minor bugs with selection logic. * GL Report Writer ---------------- Fixed problems with log GL Account Descriptions (over 40 characters) which caused report writer to crash. * Form Letters ------------ New option to be able to print one form letter per loan New Processing Fee and Loan Maintenance Fee keywords. * Portfolio Report ---------------- New facility to produce summary only report New facility to group by Introducer / GP#1 field. * Loan Summary Report ------------------- Fixed bug which selected incorrect accounts when you specifed selection by number of days in arrears * Arrears Calculations -------------------- Fixed minor inaccuracies in arrears calculations under some circumstances * Loan History System ------------------- Added missing primary key to table. * Delinquency System ------------------ Enhanced to allow restriction of accounts based on branches you select. * Loan Activity Report -------------------- Fixed problem with duplicate accounts appearing on the report * Budget Lease Cost Report ------------------------ Fixed "Cursor is not open" error. * Introducer Analysis ------------------- Added Option to Sort by Activity (total net balance) or Alphabetic by introducer Added option to exclude all inactive introducers. That is no new settlement for the past 12 months. Version 2.48 (31 October 2003) ****************************** * History Table ------------- There is a new "History Table" in the system which is used by some analysis reports to record month by month balances of all loans. This table helps to speed up these reports because it removes the need to recalculate old balances every time the report is run. The only catch is that it needs to be generated from scratch the very first time this version is installed. The system is designed to do this automatically during the first interest run after this version is installed. You can manually start this process off by selecting Development / Tools / Generate History * Clients ------- New "Phone Number 5" and "Phone Number 6" fields. The prompts for these fields can be dynamically changed in the Setup / Parameters / Custom Labels screen. * Loans ----- New General Purpose 15, 16 and 17 fields. The prompts for these fields can be dynamically changed in the Setup / Parameters / Custom Labels screen. The prompt for the "Cheque Number" field can be dynamically chaned in the setup / parameters / custom labels screen. * Payouts ------- Fixed bug with payouts where the amount received was less than the total amount of fees payable on the loan at the time of the payout. The bug caused the customer statement to show a positive balance even though the account had been completed. The way to fix accounts that may have been incorrectly paid out by this bug is to reverse the payout amount (Z transaction) and re-enter it. * Delinquency ----------- Optional new format for Delinquency reporting. * Introducer Analysis Report, Introducer Analysis Performance Report, Introducers Top Report Modified to take advantage of History Table * Loan Activity Report -------------------- Modified to allow selection of "New Clients" - clients that were added into the system between a range of dates. * Interest Calculations --------------------- Fixed bug with calculation of "Monthly Nominal" interest. * Transactions ------------ Modified transaction entry to allow option of turning off the non-direct debit fee when entering a reversal (Z transaction). Version 2.47.1 (24 October 2003) ******************************** * When you click on the "Transactions" button in the Loans form, there is now and "Export" function which will display all the transactions for the loan in a form that can be exported to either Excel, Word, or Notepad via the Report / Options menu * Modified Transaction Audit Report to show "Date Entered" on right hand side of report. * Fixed formatting of some reports that split over two pages instead of one. Version 2.47 (23 October 2003) * Fixed "Error 2743 Contact Support" error message * Fixed Writeoff Processing "2743" error. * Fixed error when trying to sort Transaction Audit report and "Print Summary" was selected * Fixed page formatting problem with Subledger History report. Version 2.46 ************ * Configuration Improved error checking to ensure that system OCX files are properly installed before the system starts. * Security Fixed problem which showed incorrect user name when using NT Authentication. Also, when using NT Authentication, fixed problem for logins with the db_owner privilege. Previously they would appear as "DBO" when they logged in, but will now be shown with their correct login credentials for security purposes. * Transaction Processing New option when entering payouts for loans than have early payout penalties, to disable the payout penalty where necessary. There is a new checkbox which appears on transactions which allows you to specify that the payout penalty should not be applied * Writeoff Processing Modification to the writeoff processing system. Employees can now have a "PIN" number which allows them to enter writeoff approvals. * Payouts Fixed problem which caused an "Invalid use of NULL" error when trying to payout loans that had rebateable subledger charges that had to be credited to an accounts payable account. * Form Letters Fixed bug which removed "Term Charges" field from form letters * Invoice Discounting Fixed bug which charged excessive interest when paying out a discounted invoice where interest had already been calculated for the month. * Partial Address Details New facility to dynamically specify the accounts you want to appear in the list by ticking check boxes. * Diary Reminders New facility to optionally lock the contents of a diary reminder as soon as they have been added so that users can only ADD or VIEW diary reminders, but only the DBO can edit or delete them. * Repayment Schedule New facility detects whether a due date has been changed by a number of months or a number of days. If you move a repayment to the same day in a different month, the system will prompt to move all existing (later) dates due by the same number of months. Previously, if you moved a due date by one month, the system would move future dates by 31 days (say) which would mean that some future dates due would no longer fall on the same anniversary date * Direct Debit Variations If you try to vary a loan that is past its term, the system will ask if you want the UNTIL date of the variation to be one year from the current date, rather than defaulting to the previously expired completion date of the loan. * Delinquency System Modified report to show action date, even if action code is not entered. Version 2.45 (15 October 2003) * Borrower names Modified system so that the primary borrower gets listed before secondary borrower or guarantor. * IBS / Tango Comparison Report Modified to produce report in Account# sequence instead of Client#. * Welcome Calls New optional "Format #2" format for welcome calls. * Transaction Batch Report Fixed bug which showed transactions "shaded" (about to be charged non-direct debit fee) even though the transaction would not be charged the fee. * Partial Address Details New option to only show clients with active accounts, that have not had credit stopped. * Completed Loans Report New option to select only Buy-Back accounts. * client Wizard Modification to put a reasonableness check on the client date of birth when entering a new client. * New Loans wizard Modified loan details screen to prompt for more classification and general purpose information Version 2.44 (7 October 2003) * Loans New flag in Setup / Parameters which allows you to specify that the schedules on any loans can be altered, even if they have already been paid. * Rollover report Modified to be able to take into account the branches a user is authorized to. * Interface with Contract Tracker Modified to replace the postal address with residential address if no postal address is supplied * Daily Interest Report Added to Invoice Discounting Menu Renamed to "Daily Interest and Fees Report" New option to include any up-front fees in the report in a separate column * Principal and interest report Fixed inaccuracies in interest calculations caused by rounding errors. * Startup screen Modified to allow you to select the branches you want to log in to without having to go to a separate screen in order to speed up the login process. Version 2.43 (2 October 2003) * Subledger Report New system report to list available subledgers. * Writeoff Report, Writeoff Analysis, Current Month Calls, Introducer Analysis, Introducer Performance, Top Introducers, Portfolio Report, Welcome Calls, Modified reports to restrict output to whatever branches you are logged into * Current / Non Current Report Modified to fix problem with written off accounts that had no interest charges prior to the TO date of the report. Version 2.42 (25 September 2003) * Access Restrictions New option on Development / Security Menu to restrict access so that only members of the DBO role can log in during critical times. * Interface with Contact Tracker Modified address import routine to cater for changes to address logic in Contact Tracker * Yield rate calculations Fixed numeric overflow problem for loans with large numbers of repayments * Overdue Interest Method (IMPORTANT CHANGE) The existing STANDARD ODI calculation method calculates ODI based on the arrears balance at the end of the month. If an account is in arrears at the start of the month, but pays halfway through the month, it is not picked up for ODI charges. There is a new DAILY ARREARS BALANCE ODI method which looks at the arrears balance for each day of the month, and calculates ODI based on the daily arrears balance. To enable this method, go into the Business Code, and change the ODI METHOD to DAILY ARREARS BALANCE. * Current Month Calls New delinquency reporting facility. * Transaction Processing Minor modifications to the Barclays UK BIDDS export facility. * IBS to Tango Conversion Report New report which allows you to compare the differences that occurs after data is imported from IBS into Tango. * Form Letters Minor changes to some of the administration fee fields that appear in letters / contracts. * Loan Summary Report New facility to show GROSS special charges instead of NET special charges. In other words the ability to show total special charges debited to an account regardless of whether or not it has been paid. * System Upgrade Routine There is a bug in MDAC version 2.8 which prevented Tango from updating Stored Procedures or Triggers that contained more than about 32K characters. This caused the following error to be displayed: "An invalid argument was passed to the datashaping service". This problem has been fixed by using a different connection provider. Version 2.41 (16 September 2003) * Portfolio Status Report New Report * Budget Templates Fixed "Invalid Use of Null" error * Business Codes Fixed problem which did not show any GL accounts available in the combo box that let you enter Tax Based GL accounts for the business code. * Foregin Currency Symbols Fixed problem which displayed incorrect foreign currency symbols on some reports * Security Fixed annoying popup messages which appeared whenever you entered a form for the first time. Security Note: New forms are authorized to all users by default and must be explicitly secured if necessary * Screen Formatting Tidied up some of the formatting logic on forms to make them appear more consistent. * --- Known Bug --- Windows 2003 Server & SQL Server 2000 causes the following message to appear when upgrading to a new version of Tango: "The Datashaping Service was passed an invalid argument" This error will be addressed in a future version. If it appears, please contact support. Version 2.40 (15 September 2003) ******************************** ************************ * Major version change * ************************ * Menus. All the menus in Tango have been simplified. The menu items you have been using will probably appear on different menus - especially reports. To make it easier for you to find menu items, there is a new "Menu Map" item on the help menu. Try using this feature if you need help finding new items. In brief: 1. The reports menu has been structured with a series of sub menus. 2. the "Delinquency" menu has disappeared. Maintenance functions for it have gone into the Setup / Delinquency menu. Reports have gone to the Reports / Delinquency menu. 3. The "Other Accounts" menu has disappeared. Search functions have gone to Clients / "Other Accounts". Transaction entry has gone to "Transactions" / "Other Accounts", reports have gone to Reports / Other Accounts. * Operating Leases There is a new operating lease subsystem which allows you to: - Perform Tax-based accounting on leases - Enter maintenance budgets for assets that are leased out - Enter maintenance costs for assets under lease. - Use Accrual-Based accounting for GST. * Clients Fixed problem that occurred when an address was entered which was too long. Would cause a "string or binary data would be trunctated" message. * Banking Interface Minor adjustments to the UK Barclays BIDDS interface. * Form Letters Minor adjustments to form letters used with Monthly Account Keeping fees. * Transaction Entry Fixed bug that would allow you to enter transactions into a previously posted batch if you clicked on "EDIT" instead of "ADD" when no transaction batches were selected. * Help New "Menu Map" function to show overview of menu structure. Version 2.39 (11 September 2003) ******************************** * Payout Quotes Minor changes to layout for Consumer Credit Payouts * Client Scoring The Relative Risk Index is now stored with the Client Scores if you are using the Scoring / Baycorp interface in Tango * Form Letters New facility to define Form Letter Attachments and Form Letter Stationery in Setup / System Tables. * Welcome Calls New facility for Client Welcome Calls on the processing menu, lets you keep track of initial contacts with clients that have recently started new loans. * Form Letters New fields on form letters * Importing from external systems The Insert_FM_Clients, Insert_FM_Employers, Insert_FM_ClientIdentification stored procedures allow you to write programs to put info into Tango from external sources. * New Top Introducer report * New introducer analysis performance report. * New introducer analysis report. * New Rollover report. * New banking interface to allow exporting to the Barclays UK BIDDS interface * New system-wide alteration to allow you to key arithmetic formulas into any numeric fields in the system. For example, if you're entering a transaction for a loan, you can enter 120+150+370+220 and the system will calculate it on the spot You can enter 1100i where the i denotes that the amount is inclusive of GST, and the GST component should be removed. The system will convert 1100i to 1000. Version 2.38 (30 August 2003) ***************************** * Customer statements For loans with a negative balance, there is a new option on customer statements: "Show fee summary for accounts with negative net balances". This is on the "User 2 of 2" tab. When the option is checked, the customer statement will show details of all outstanding fees on the account * Subledgers New "C" type subledger which is activated when a loan completes. Fixed bug which did not post transactions generated by subledgers which were linked to creditors. * Writeoffs New "Writeoff Analysis" report * Deferments Fixed bug which incorrectly set the deferment status for all loans Version 2.37 (29 August 2003) ***************************** * System Change to "References" section of program to ensure that the system uses the MDAC 2.7 controls instead of earlier versions. * Loan Summary Report Fixed minor problem with left justification of the rightmost column on the report Fixed problem with special charge balance on report. * Repayment Calculations Fixed problem with rounding errors on loans with monthly fees. * Credit Card Processing New CardFAST (NAB) facility for credit card processing. * Subledgers New facility to specify that a rebateable subledger should be ignored when processing writeoff transactions * Writeoff Processing New "Writeoff" button in the arrears tab of a loan lets you flag a loan so that it may be reviewed for eligibility for being written off. New "Writeoff processing" option on the "Processing" menu lets you manage all accounts that have been nominated to be written off. * Direct Debits Fixed problem with "Type Mismatch Error" when trying to display the direct debit screen. Version 2.36 (27 August 2003) ***************************** * Loan Summary Report New "Simple format" option Added "Location1" field to standard report which will be shown when you don't select any subledgers to appear on the report. * System Tables New format to system tables management to simplify the maintenance of data in system tables * Overdue Interest Fix posting errors when reversing payments of Overdue Interest * Holdback Income Fix GL Journal which waS generated by the system when writing off an account that had unearned holdback income. * Form Letters Additional fields available on form letters. * Loan Repayments Fixed repayment calculations on loans with deferred interest and deferred repayments, where the first repayment falls due on the last day of a short month (less than 31 days). * Direct Debits Allow exclusion of accounts based on classification codes. Version 2.35 (21 August 2003) ***************************** * System Fixed OCx / DLL reference problems which caused "#Name?" to appear on some reports when you didn't have MS-Word installed. Fixed the appearance of some screens in the system to make them tidier. * Writeoff Report Fixed problem with duplicate entries on the report for the same account. * Payout Quote. Fixed minor formatting / spelling problems on the report. Version 2.34 (21 August 2003) ***************************** * Delinquency System change the report order if the splits are locked If the report is locked into alphabetical groups for each employee the accounts will appear in Next Due order within each employee, while still keeping the alphabetical groupings (A-F, G-O, P-Z) * Loan Transactions The system will now allow you to post special charges to a completed account. The system will now show WHO entered a batch when it appears on the list of held batches awaiting posting. * BPAY Import Includes customer account number in the narrative of the transaction, even if the account number is invalid, to make it easier to reconcile incorrect entries. * Writeoff Report New report that allows you to print / manage the details of written off accounts. * Paid in Full Report Modified to show interest charges applied to flat cancelled loans. * Default accounts New facility to print a form letter for mercantile agent collections when the default flag is turned on. To do this, you must create a specific form letter, and edit the "Field Call Letter" section on the General Tab of the Business Codes form. You can have different Field Call letters for different business codes. * Payout Quotes. New Consumer Credit Code compliant payout quote facility. To enable this manually, select the "Consumer Credit" payout method when doing a payout quote. To enable this automatically, edit the "Payout Method" section of the "Payout" tab on the business code form, and set it to "Consumer Credit". * Form Letters Version 2.33 (15 August 2003) ***************************** * Loan Repayments If you have specified that scheduled payments should be moved to the first day of the next month when their anniversary day does not exist in a month with less than 30 days, then the system will assume that on a loan with first payment due on the first of the month (where the prior month had less than 31 days, and the settlement date was on the last day of the month), subsequent payments will be scheduled to fall due on the last day of the month whenever possible. For example, You have ticked the box in Setup / Parameters which specifies: "Move due date to first of next month if day doesn't exist in this month" And a loan settles on the 31st of the month, And you enter the first payment date as 1 March. The system assumes that the 1 March payment was really the February payment due on the 31st of the month, but moved to the first of the following month. It therefore assumes that future payments should be made on the last day of the month - 30 April, 31 May, 30 June, 31 July etc... Except that where a month only has 30 days, the payment will be moved to the first of the following month. * Transaction Importing There is now a new BPAY import format. * Deleting Clients Fixed bug which prevented deletion of clients when the client had associated cost centres. Fixed bug which caused errors when pressing the BACK button in the wizard when you were entering a new client. * Principal and Interest Report Fixed bug which showed incorrect results when using the existing history of a loan in the report, and the loan had a repayment entered against it with a date prior to the settlement date of the loan. * Form Letters Fixed bug which occurred when trying to print a form letter that was set up to allow you to edit it before printing. Fixed bug which occurred when trying to print a form letter which did not exist. Modifid system so that if you only have Word Viewer installed, and you try to print a letter flagged to allow editing before printing, the letter will just be printed without editing. Previously it wouln't let you print the letter, and showed numerous errors. * Business Code First Payment Default Report Modified to include business code description in group header. Version 2.32 (13 August 2003) ***************************** * This version requires MDAC 2.7 or higher. If you don't have this version installed already, Tango will automatically download and install it If you don't have an internet connection you should ask your system administrator to install MDAC 2.7 or higher from http://microsoft.com/data * Completed Loans Report ** Fixed bug which prevented some completed loans from appearing on the report. ** Include outstanding special charges on report * Loan Summary Report ** Fixed bug which incorrectly included accounts not in arrears when requesing accounts in arrears ** New facilty to show outstanding special charges on the report. If you tick the "Show Special Charges" box, the total amount of outstanding special charges will be shown on the report. If you also specify a subledger, only special outstanding charges associated with that subledger will be shown. ** Fixed bug which showed incorrect deferment status on the report. * Business Codes New option to specify that Special Charges and ODI Charges should be treated like debits in that they should increase the net balance of the loan for the purposes of interest calculations. Similarly payment of these charges would be treated like other payments in that they would reduce the net balance. To enable this, tick the new box entitled "ODI And Special Charges behave like Debits" which is in the ODI page of the Business Code form. * Clients New option to automatically add Cost Centres to clients to make it easier for you to add assets to loans. * Paid in Full / Completed Loans ** Fixed bug which excluded some accounts from the report, especially those that had been imported from IBS ** New facility to show outstanding special charges on the report * Loan Repayments System shows more intelligence when working out the dates of repayments in the schedule when the first loan repayment is due on the last day of a month with less than 31 days. * Customer Statements Enhanced Performance when printing CONSOLIDATED statements. * Form Letters ** New facility to allow the system to display a form letter before printing it so you can edit it. You must have MS-Word (2000 or later) installed to be able to do this. ** Fixed bug which printed out multiple form letters for a loan when the loan had more than one borrower attached. ** Modification so that when you create multiple form letters, it updates the diary reminders similar to when you print one form letter for a loan manually. * Monthly Interest Run ** Performance Enhancements to make it run quicker. ** New facilty to add a monthly account keeping fee which debits the customer account monthly. Loan Repayment Calculations are improved to be able to take the fee into account when working out what the repayments should be. The fee subledger must be marked as charged monthly, and chargeable to the borrower. * Pricipal & Interest Report ** New facility to output the report for multiple accounts with the option to send the data to a CSV file. ** Fixed bug which doubled up repayments when including historical payments in the schedule. * ODI & Special Charges ** New facility to specify that ODI and Special Charges should behave like debits when calculating the net balance of a loan for the purposes of interest charges. To enable this, go into the Business Code form in the ODI tab and tick the box which says "ODI and Special Charges behave like debits". If you change this value, the system will ask if you want to automatically recalculate the net balance of all loans within the business code. If you do this, you should create a manual GL journal to update the receivables balance. ** New facility to specify that ODI and Special Charges affect the GL when charged. You can also specify accrual accounts for ODI charges and Special Charges. When a special charge debits the account it will debit the receivables account in the GL, and credit the accrual account. When it's paid, the system will debit the accrual account and credit the relevant income account. ** Removed the facility to specify Payout Penalties and Non Direct Debit fees as debits, as this was superceded by the above modifications. Version 2.31 (5 August 2003) **************************** * Asset Register Report - adjusts the depreciation per month in the case where the asset has been added or disposed of in the current month. * New option on a business code to specify that the final direct debit on a loan should be reduced so that it does not overpay the account. * New Delinquency Report: Business Code first Payment Default report. * Principal and Interest Report - can now produce a projection based on the existing history of a loan rather than just the scheduled history. - can now be run for multiple accounts - can now produce a "Raw Data" format for exporting to external systems. * Loan Summary Report - Fixed bug which prevented negative arrears from showing on report. If you want only accounts with negative arrears to be selected, enter a FROM arrears days of -999 and a TO arrears days of -1. * Receipt Allocation Report - Now shows net and gross balance on report. * Form Letters - New facility to print form letters for accounts whose credit card details have expired. Version 2.30 (24 July 2003) *************************** * Receipt allocation Report This report now shows a breakdown of Holdback Income and Interest Income. Any unpaid interest income or holdback income from prior periods will be allocated before principal in the current period * Transaction Reversals When you reverse a payment which had a non-direct debit fee, the system will now also reverse the non-direct debit fee. Fixed problems with GL journals when non-direct debit fees were specified as Debits instead of special charges. * Holdback Calculation Fixed bug which reported holdback income for accounts even when no holdback subledgers were specified. * Form Letters Fix year end interest on interest in advance loans. New facility for Variation Dates New facility to include borrower 1 & 2 on the same form letter New facility to charge a fee for issuing a form letter using the queue. * Delinquency System New facility to disable an employee from appearing on reports. * Asset Register Fixed problems with calculations of some columns on report. A special "thank you" to Mr Eric Hartge from the Bradstreet Group for his assistance with these issues. * Yield rates Fixed problem with numeric overflow on some calcualtions. Yield rates now have an upper/lower limit of 1300 percent. * IBS Import Fixed problem creating repayment schedule for accounts that had reversals early in their term. * Loan Summary Report New facility to print extra ageing information on the report * Loans form New facility to display an arrears summary by ageing period. * Subledgers / Charges New facility to specify a "Maximum Term" for a subledger. Whan a loan goes beyond this period of time, the subledger will no longer activate. To disable this facility, specify a maximum term of zero. * Loan Activity Report New facility to exclude New Loans, Completed & Writeoffs from the report. Version 2.29.1 (21 July 2003) ***************************** * Fixed problem which prevented up-front charges from displaying on statements for accounts that had no transaction history to display. Version 2.29 (17 July 2003) *************************** * When you define Payout Penalties on a business code, you can now allocate a subledger to them to assist in specifying how the income should be accounted for in the GL. You must specify the penalty amount in the subledger. Any penalty amounts in the actual business code will be deleted. * Payout Quotes can now take into account payout penalties. * Transaction Posting. EXTENSIVE MODIFICATIONS If there are any fees associated with a payout such as ODI, payout penalties, non-direct debit fees, etc, the system will now create special charges for these amounts before completing the accounts. Previously, the system just increased the sundry income transaction but didn't split up the actual charges so they could be accounted for separately in the GL. These modifications also apply to payout and writeoff reversals which will generate all the correct reversal of charges and GL journals. * Holdback Income Fixed bug which generated incorrect holdback income amounts when there was more than one holdback subledger on an account. * Transaction Log Backups (System Related) Replaced NON-Logged operations which prevented the server from doing transaction log backups on some databases. * Customer Statements New "Consumer" format statement to comply with the Consumer Credit Code. New facility to optionally show all up-front charges (e.g. Stamp Duty) rather than combining them all as part of the opening balance on a statement. * Loan Summary Report Now shows the "Deferment Status" on the right hand side of the report if you have this facility enabled. HINT: You can enable prompting for the Deferment Status by checking the relevant box in the "Loans" tab of the System / Parameters form Allows selection of accounts by Deferment Status. * Receipt Allocation Report Now splits receipts against holdback income as well as interest income. Version 2.28 (15 July 2003) *************************** * Repayment Schedules / Direct Debits New facility to specify how to handle repayments in months that don't have 31 days. In Setup / Parameters you can specify whether or not to: "Move due date to first of next month if day doesn't exist in this month". In a month with only 30 days, with a repayment usually due on the 31st, this will force the repayment to fall due on the 1st of the following month. If not checked the repayment will fall due on the last day of the current month, even if there are only 30 days in the month. * Payout Penalties New facility when setting up buisiness codes. You now have the option to select a payout penalty method of "Percentage of Term" or "Number of months". If you leave it as "Percentage of Term" the system will allow you to define payout penalties based on how far through the term a loan has progressed when you calculate a payout quote. If you specify "Number of months", the system allows you to specify a flat payout penalty amount to charge if the loan pays out with a minimum number of months of the term remaining. * Payouts / Reversing Payouts Fixed bug which generated incorrect GL journals when paying out accounts in some situations. * Variations If you enter a direct debit variation, the system will give a brief summary of the variation on the repayment schedule screen of the loan form. Version 2.27 (10 July 2003) *************************** * Loan Subledgers. When you change the multiplier / amount of a subledger in the wizard, the total value of the subledger will be recalculated. * The length of the Australia Post Billpay Code was reduced to 4 characters to comply with Australia Post requirements * When entering a new loan, the day of the month that each repayment falls due will be adjusted when the repayment falls due in the last few days of the month. If the first repayment falls due on the last day of the month, all other monthly repayments will fall due on the last day of the month regardless of the length of the month. IF the first repayment falls due on a day late in the month, subsequent payments will fall due on either (a) the last day of the month or (b) the same day of the month as the first repayment (if that day exists in the month) * User import loans from file. Minor change to prevent locking of the database. * Form Letters New fields for: "Defer Interest Until" date Australia Post BPAY code. Total Drawdown fee. * Bureau Processing. Fixed "Overflow" error when importing bureau responses. * Customer Statements. Fixed "Unable to drop table" error that sometimes appeared. Version 2.26 (9 July 2003) ************************** * Loan Summary Report - Allows selection of accounts that have received a repayment during a given range of dates. * New option in System Setup to always show the current branch name in the application title bar, even if you have set the system to use the main company address on correspondence instead of the branch address. * New option in System Setup to always allow flat cancellations, even if the loan in question has had prior repayments on it. * Fixed bug in User Import routine which did not properly import data from an external source if the BSB code was blank / null * Schedule of Borrowings - Now excludes non-active accounts from the arrears section, and backdates the arrears balance to the ASAT date of the report. * Posting Transactions - Ensure the Net instead of the Gross transaction value gets posted to the receivables account when posting to accounts with outstanding special charges. * Posting Transactions - Fix bug which posted reversals of payments to the GL with the journals the wrong way round. * Deferred Payment Loans - Fixed minor inaccuracies in calculation of repayment amounts when the deferred payment period was longer than one month. * Deferred Interest Loans - Fixed inaccuracies in calculation of repayment amounts when you clicked on the "Recalc" button. Version 2.25 (5 July 2003) ************************** * New "Non Direct Debit" charge that can optionally apply to all repayments that are received by any other means than direct debit. To set this up you must configure the business code and specify which subledger will be used to generate the fee. You can also specify whether this fee should be applied as a debit to the account or as a special charge. * You can now enter new Classification Codes against a loan. These are driven by drop down boxes, that you can set up via the Setup / System Tables / Classification section. You can enter classification codes when entering a new loan, or when viewing the details of an existing loan. * Fixed bug which used the gross payment account when working out the GL journals for a transaction that had special charges deducted from it. This meant that if a payment of $100 had a $5 fee dedcuted from it, the system would post $105 to the bank account instead of $100. This has been fixed. * New "Rebateable Subledger" facility. If a subledger has a "Rebate Method" on it, the system will generate journals for a rebate of the subledger when the loan completes. For holdback subledgers this means that any unearned holdback outstanding on the account will be taken to account as income when the account is paid out. Write-off transactions will reverse out any outstanding holdback income. * Holdback Summary Report - Fix "Cannot group by bit column" error which occurred when running on SQL Server version 7.0 * Wizard. Fixed bug which showed incorrect loan term when entering a loan with deferred repayments. For example, if the first payment of the loan is due 6 months after it starts, and there are 30 repayemnts, the term should be shown as 36, not 30. This bug did not affect any calculations, but was confusing. Fixed bug which calculated incorrect repayment amounts when you entered a new loan with an initial interest free period, and deferred repayments. * Loans Form - Shows "Number of repayments" as well as the loan Term. * Loan Activity Report - Shows "Number of repayments" as well as the loan Term. * Import Repayments - Fixed bug which showed repayments imported from a data file as direct debits. * All views will be recreated by this version. When you upgrade your database the process may take longer than normal. Version 2.24 (4 July 2003) ************************** * Direct Debits. New option to select repayments for processing by direct debit even if the account is paid in advance. * Overdue interest. New option to charge a flat ODI fee to an account that is in arrears at the time the interest run is processed. NOTE. To charge a flat fee ONLY, set the ODI Method of the business code to "NONE" and enter a flat "ODI Fee". To charge an ODI rate AND a flat fee, set the ODI method of the business code to "Standard". Enter a RATE and enter a FEE. Version 2.23 (2 July 2003) ************************** * Form Letters - Fixed problem with disappearing BPAY and Australia Post BillPay codes. * Transaction Import - New import formats: EzyPay Australia Post ECS * Yield / Comparison rates - fix problems with calculations on loans of less than one month. * Holdback Summary Report - Fix minor inaccuracies in report * Other Accounts - New Statement Option. * Loans Form - Variation Details are now entered on the "Contract" tab. Version 2.22 (30 June 2003) *************************** * COMPARISON RATES (or Yield Rates) Tango now calculates an effective yield rate or comparison rate. Any charges built in to the amount financed, plus any non-chargeable amounts marked as "Include in yield", plus any Gross Holdback amounts are included in the Gross Income of the loan when calculating the yield rate. * Delinquency Processing New facilities to let you specify targets and penetration targets for debt collection staff. New "Management Reportables" report for delinquent accounts. New facility to enter public holidays to be taken into account when producing delinquency reports. * Loan Summary Report Allows grouping / sorting by GeneralPurpose1 field * Subledger History Report (New Report) lists all transactions generated as a result of a subledger being processed. * Holdback Summary Report (New Report) lists the status of all loans with a holdback component. Version 2.21 (29 June 2003) *************************** * Invoice Discounting - The Invoice number of a discounted invoice is recorded in the General Purpose 1 field of a loan to make it easier to track down the invoice. * New BPayCode and Bill Pay Codes available in form letters * "%" Type subledgers allows amortization of Holdback income over the lifetime of a loan. * GL Account Desriptions may be up to 100 characters in length. * New flags in subledger definitions to allow you to specify if a subledger should: * Stop calculating once a loan has reached its term * Be included in any yield rate calculations * Be related From / To another subledger for the purposes of holdback income calculations * Modify Principal / Interest report to take into account if a loan has interest charges deferred until a future date. * Flat Cancel calculations will now reverse any subledger journals that occurred when the loan was activated. * New Cashflow Projection report. * Variable Rate Loans now allow you to enter an interest rate schedule which can pre-program when interest rates will change on a loan. * Asset Register - Fixed problems with calculation of written down value on loans that do not have multiple assets defined. * New System Table - Form Letter Attachments. Lets you specify on a form letter if any attachments should be added to a form letter when printing via a bureau. * New System Table - Form Letter Stationery. Lets you specify on a form letter what sort of stationery should be used when printing first and subsequent pages. * Client Wizard - will guess the Gender of a new person and work out whether or not that person should have a title of "Mr" or "Ms" based on the titles of other people with the same surname in the system. * "Other Accounts" now have default GL Debit and Credit accounts. * Client form shows age of client as at last birthday. Version 2.20 (6 June 2003) ************************** * Security - The BRanch Security System now allows you to let role members join a branch, so you can allocate a set of users to a group, then allocate that group to a branch. * Invoice Discounting now puts the Invoice number in the Location1 field so you can search by invoice number. * Loans / Form Letters - In addition to proposing a variation in days, you can now propose a variation in months. This will affect calculations on form letters when sending a variation proposal to a client. * Form Letters - Added various fields to form letters * Delinquency - A new facility to either INCLUDE or EXCLUDE accounts from a deli report even if the account is not in arrears. * Experian - "Join Account" indicator which tracks the number of accounts that a borrower has with the lender. * Asset Register - Fixed problems when loans did not have multiple associated assets. - Option to exclude accounts that don't have depreciation rates * Daily Interest Report - New report to calculate the actual interest accrual on an account by account basis. * Wizard - fixed bug which caused a crash if you left the residual or the General Purpose #1 field blank while entering a new loan. Version 2.19 (22 May 2003) ************************** * Business Code Changes Report Fixed bug which showed duplicate entries for the same accounts on the report * Form Letters Added new fields: - BranchName - The contact details of the currently selected branch - BranchAddress1 - BranchAddress2 - BranchTown - BranchState - BranchPostCode - BranchACN - BRanchABN - DiscountedInvoiceNumber - Details of Discounted Invoice purchased on this account - DiscountedInvoiceAmount - DiscountedNetPercent - DiscountedInvoiceDate - DiscountedInvoiceDebtor - CompletionDate - Date loan was completed (if completed) - RefundAmount - Adjustment amount generated as a result of paying out the account - ObscuredCreditCardNumber - Credit card number with parts missing for security use in letters * Email When emailing, the system will ignore accounts that don't have an email address. * Creditors / Accounts Payable New conversion routines to enhance the import process from IBS. * Process New Loans New option to delay processing loans so that if the settlementdate entered has not yet occurred, the system will not activate the loan. NOTE. To enable this option, you have to go into the setup parameters, and tick the box entitled "Delay Processing Based on Settlement Date". * Invoice Discounting New option to specify that an invoice is "Paid in full" while being entered. This is useful for invoice payments that were received in error on invoices that were not purchased. * New Loan Wizard Option to disable the pages which display the Photo page and the Identification Information. To disable, go into Setup / Parameters and check the boxes entitled "Skip Photo Page in Wizard" and "Skip Identification Page in Wizard" * Internationalization Fixed bug which showed incorrect currency symbols when Tango was used in locations which used symbols other than "$" for currency. New facilities to change the prompts for "BSB Number" as well as the input format used to enter BSB numbers. New facilities to change the prompts for "Suburb" and "State". To change these prompts, go into Setup / Parameters / Custom Labels, and alter the prompts for BSB, Input Mask, Suburb and State. * New "Account Summary Report" for Creditor Accounts. * New facility to pay direct credits into people's bank accounts via the "Other Accounts" menu. * Import Transactions Fix bug in "Import transactions" which ignored subledgers that didn't have both GL accounts specified * Loan Activity Report Fix bug which truncated phone numbers on report. * Direct Debits Fixed bug which did not correctly sort by Client Name. * Experian Export Modifications to the layout of the experian export data. * Interest Calculations New facility to specify a "Stop Interest After" date so that a loan will only accrue interest for a limited period of time, then revert to interest free. * Client Addresses Extended the size of the PostCode and State fields to 25 characters. Forced postcode to upper case if it contains letters (as in UK). * Views All views will be rebuilt when this version is installed. * Asset Register Allow exclusion of accounts with no depreciation rate * Diary Reminders Allow Sort / Selection by "ACtion Code". Version 2.18 (28 April 2003) **************************** MARJOR VERSION UPGRADE. Please backup before installing. * Creditors / Investments / Accounts Payable We are currently creating a payables system which will be able to handle interest bearing deposits, creditors, etc. Although the full functionality of this module is not yet available in Tango, the database objects are now in place. Former IBS users will notices that their Creditors are now accessible via the client / search option like any other contact in Tango. The "Clients" table will be the central repository of all information about any contact, whether they are borrowers, lenders, creditors, debtors, etc. We expect the full functionality of a Creditors Ledger / Interest Bearing Deposits to be available by the end of May. * Transactions This version replaces any null transaction values with zero. The system does not allow null transaction amounts to be entered, but there were some installations with null transaction amounts left over from prior versions. * Responsibilities. You can now define your own responsibilities between clients and loans. Previously, you only had "Borrower" and "Guarantor" available, but now you can add as many other respobsibilities as you like. "Borrower" and "Guarantor" are system-defined entries and must not be deleted from the table. Select Setup / System Tables / Responsibilities for more details. * Experian Positive Credit Reporting UK users can now export data in a format which is usable by the Experian Credit Reporting system. Select Development / Export / "Export data for Experian" for more details. * Direct Debits New option to allow the system to create separate direct debits on the same day for the same customer. The default is to add up all direct debits for the same customer on the same day and create just one direct debit. Please contact us if you would like us to enable this option for you. * Tango Import Stored Procedure "User_Insert_FM_Loans_From_Table" New facility to import banking information for new clients. * Gross Interest Fixed bug which ignored the impact of Drawdowns and Debits when calculating Gross Interest * Form Letters New fields: -- LatestDrawdown : The value of the most recent draw down. -- LatestDrawDownDate : The date the latest drawdown was advanced. -- LatestDrawDownFee : The fee charged on the most recent drawdown. -- GSTInFull : GST Charged on the amount financed of a loan. -- GSTMonthly : GST Charged on the monthly repayments of a loan. -- StampDutyInFull : Stamp Duty Charged on the amount financed of a loan. -- StampDutyMonthly : Dtamp Duty charged on the monthly repayments of a loan. -- NetResidual : Residual Value EX-GST. -- Residual Charges : GST Charged on Residual Payments * Client Address New facility to record the details of address changes for Exporting to Experian. New facility to mark an address as "Internal" so it is not reported to Experian. Version 2.17 (7 April 2003) ************ MAJOR VERSION UPGRADE. Please backup before installing. * Form Letters - Email functionality. You can now email form letters to clients as well as posting printed form letters. RTF form letters will be sent out as attachments to the email. HTML form letters (see below) are sent out as formatted emails, rather than attachments. - HTML form letters. Tango can now handle HTML format (as well as RTF and DOC) format for form letters. HTML form letters can be printed out by your web browser, which removes the need for WordViewer or MS-Word. - SPECIAL NOTE #1. You can convert RTF and DOC form letters to HTML format as follows: 1. Open the form letter with MS-Word. 2. Click on File / "Save As" and change the document type to "HTML". 3. Save the new HTML document. - SPECIAL NOTE #2. The email functionality is achieved through a small utility (BLAT.EXE) which will be included in the download package that you download when installing this version. The emails are not sent out using your email program, so you won't have any way to stop the email once you send it. It gets sent as soon as you click on the "Email Now" button. - You can send bulk emails to a number of different people using the Report / "Form Letters" / "Create Multiple Form Letters" option. - You can send form letters to people whose insurance premiums have fallen due for renewal. * Delinquency System - New faclility to "Lock Splits" on a report. This lets you specify that a certain range of accounts will always be allocated to the same employee. * Client Information - New data "Gross Income" and "Net Assets" may be collected about a client. * Business Codes - New classification data for a business code "Account Type" lets you classify your loan types into different categories. This is to enable data exchange with the Experien "CAIS" positive credit reporting system. NOTE: Due to government legislation, positive credit reporting is not available in Australia. * Arrears Calculation - New facility to show negative arrears (paid ahead) accounts. * Business Code Changes - Added extra identification fields (name, phone number, etc) to report. * Personal Salutations - Added "Mr & Mrs" salutation. * Receipt Allocation Report - New facility to print in Account# sequence * Importing Repayments from Electronic Bank Statement - Fixed problem with importing from Westpac Bank which caused system to be confused by leading zeroes in the "lodgement reference" field. * New "Schedule of Borrowings" report. * Gross Interest - Fixed bug which did not calculate Gross Interest or Gross Balance on loans which did not have a repayment schedule * New user interface to allow importing multiple new loans from an external application processing system. Create Procedure User_Insert_FM_Loans_From_Table ( -- See below for a description of how to handle parameters @Database nvarchar(50), -- the name of the Contacts database @InputTable varchar(20) output, -- The name of the table from which to import @Result int output -- Code describing result of this SP. ) As -- If @InputTable is blank or null, make up a name for the input table, create it, -- and return a result of -1. -- If @InputTable does not exist, create it, and return a result of -2. -- If @InputTable exists, process it. -- if there are errors while processing the input table, return a result of -3. -- Result set will return a description of the errors. -- if there are no errors while processing the input table, return a result of 1. Version 2.16 (18 March 2003) ************ * Loan Repayments Fixed bug which prevented changes to the repayment schedule. * Form Letters New form letter fields: "CurrentODI" - the amount of ODI chargeable on the current arrears balance "Addressee" - If the client is a company, the name of the company, otherwise it's the title, givennames and surname of the client. * Receipt Allocation Report Includes total interest accrued as well as interest paid on report. Version 2.15 (16 March 2003) ************ * "Deferment Status" - New facility to prompt for a "Deferment Status" when you change the due date of a repayment on a loan. Based on the number of days that you defer a repayment by, the system will prompt you for a "Deferment Status" which appears at the top of the loan form. To enable this facility, you must set the SetupInformation.PromptForDefermentStatus column to 1. Version 2.16 will allow you to group the Loan Summary Report by deferment status. * New General Purpose fields The loans form has 5 new general purpose fields: GeneralPurpose10, GeneralPurpose11, GeneralPurpose12, GeneralPurpose13 and GeneralPurpose14. You can define the prompts for these fields in Setup / Parameters. * Arrears Calculations. Fix bug which caused errors in Statements, Reports and anything relying on arrears calculations when an account was paid ahead. * New fields available to appear on form letters: ListSubledgerValue1 - a list of subledger charges for each payment due. ListSubledgerValue2 - a list of subledger charges for each payment due. ListSubledgerValueOther - a list of subledger charges for each payment due. ListChargesDue - a list of total subledger charges for each payment due. SubledgerDescription1 - description of the first subledger charged on a repayment SubledgerDescription2 - description of the second subledger charged on a repayment ListNetRepaymentAmounts - a list of net repayment amounts ScheduleNotes - Notes which describe any months during the schedule for which there are no repayments The above fields are only available if you use Select_DetailedFormLetters instead of Select_FormLetters as the recordsource of a formletter. * Direct Debits. Facility to sort direct debits in different sequences when generating them. * New Report "Missing Revs Report" which allows you to list out all accounts that do not have values in the "GeneralPurpose3" field. * GST Fix calucations on payouts where GST was payable on the residual but not on repayments. Previously GST was calculated at 10% of the gross payout instead of 10% of the net. * Maturity Analysis Report New version works 10 times faster than old version. Report now shows total outstanding repayemnts for each maturing account. * Delinquency - New "Delinquency Summary Report" to show Deli figures for each day of the month. * Loan Transactions Fixed bug which caused incorrect accounting if a transaction was posted with a null (blanked out) repayment amount. Version 2.14 ************ * The Delinquency System records totals for each branch to allow calculation of percentages in the totals on reports. These totals are updated during the monthly interest run. * The clients form has 3 new general purpose fields that you can put whatever you like in. * Form Letters. Fix problem with printing form letters in some cases where transactions on the account had null values. * Search Screen. Removed duplicate entries which appeared on the search results screen. Include Name, Given Names and Surname for all clients when showing search results. Previously if a client was not allocated to a loan, the search screen would not locate it properly. * When a direct debit is varied, the result is now saved as a diary note. * The Loan Activity Report now shows Work and Mobile phone numbers. * Direct Debits. Fixed bug on accounts with more than one borrower where both borrowers had bank accounts registered. If one borrower was not selected for direct debits, but the other borrower WAS selected for direct debits, the bug sometimes used the bank account details from the unselected borrower when creating direct debits. * Arrears Adjustments. Fixed bug which caused incorrect results when importing from IBS. Fixed bug which caused incorrect arrears calculations when an account had an arrears adjustment. * Cheque Cashing. New facility to print a form letter / contract from the last page of the cheque cashing wizard. Version 2.13 ************ * Fixed problem with Maturity Date calculations on Loans that had residuals. Previosuly the maturity date would be incorrect by one month if a loan had a residual * New facility to set the due date of the residual to be in line with the repayment frequency of the other payments in a loan. For example, if the repayments are weekly, and the loan has a residual, normally, the due date of the residual would be one month after the due date of the last entry in the schedule. If you set the ResidualMatchesScheduleFrequency flag in the SetupInformation table to TRUE, the due date of the residual will fit in with the frequency of the rest of the schedule. In the example above, it would be one week after the due date of the last entry in the schedule. * Form Letters. Fixed "Repayment Period" keyword in cases where a loan had a residual. New keywords: "NetRepaymentAmount" and "GST". * Log on / Log off The system now completely logs you off one database before trying to log you in to another database. If the log on fails, and you cancel, the system will log you back on to the first database. * Payout quotes Fixed problem with "Minimum Amount" not being charged if Sundry% was zero. Fixed problem with "Loading Amount" bir being charged. * Loan Summary Report New facility to select new (unprocessed) accounts. * Fee Summary Report Fixed problem which counted loans more than once if those loans had more than one associated borrower. Version 2.12 28 January 2002 **************************** * New. Fee Summary Report Shows a summary of new loans written for a given period of time, with total fees, and total interest charges. * Form Letters New Early Termination Penalty Keyword: "EarlyTerminationPenalty". * Repayment Calculations Fix problems with gross interest amount on loans with repayment based subledgers. The problem occurred with loans where GST was payable on the repayment amount, but the loan didn't have a residual or baloon payment. The system would incorrectly calculate the repayment amount in these circumstances. * Asset Register Fix bugs in WDV calcs for diminishing value. Loans with Assets whose depreciation was calculating according to the Diminishing Value (Accelerated) method were showing incorrect written down values. * Sample Scoring New facility to generate a data file for Baycorp to enable them to create scorecards based on your acceptance / rejection history. Version 2.11 10 January 2002 **************************** * Early Termination Penalty You can specify in the business code details that if a loan pays out within a set percentage of the contracted term, a penalty of so many monthly repayments will be applied. This penalty will appear on payout quotes, and is available via the EarlyTerminationPenalty and TotalPayoutPlusETP keywords on form letters. * General Ledger Modified the posting program to ensure any transactions posted to loans generate GL journals that include the complete loan account number in the reference column. * Loan Summary Report You can specify a subledger code to include on the report. If a loan has this subledger code the total value of the subledger is shown in a separate column on the report. * Completed Loans / Paid In Full Report This report will now show a list of all subledgers associated with each loan that appears on the report. Version 2.10 24 December 2002 ***************************** Transactions * Fixed bug which truncated reference numbers longer than 8 characters. Completed Loans Report * Fixed bug which ommited reversals of Payouts from the report. Version 2.09 17 December 2002 ***************************** Inertia * Fix problems with dates when checking for inertia. Special Charges * option to move payments due for special charges to the end of the repayment schedule, so they don't get collected until the last month of the loan. This option can be enabled at a system wide level, or at a business code level. (FM_BusinessCodes.ScheduleSpecialChargesAtEnd, SetupInformation.ScheduleSpecialChargesAtEnd * New option to suppress the creation of schedule entries for special charges at the business code level: (FM_BusinessCodes.SuppressSpecialChargeScheduleEntries) * New option to suppress the deduction of special charges from repayments at the business code level: (FM_BusinessCodes.SuppressSpecialChargeDeductions) Payouts * Option to introduce a payout penalty (months worth of repayments) if the loan pays out before a time limit (in months) Completed Loans Report * Option to sort by either transaction date or business code. Clients * New ability to customize the labels on some of the user defined fields in the clients "Extra Info" form. Form Letters * New ability to select / exclude multiple form letters based on values in the UserField#1 field on the clients form. GL Statements * Fix decimal alignment problem which caused part of the balance column to be printed on a separate page. Database Backup * New utility to create a copy of a database. Due to security considerations, this feature is not available via the front end software. Please contact info@tango32.com if you need instructions about using this feature. GST * GST on residual payments is based on the actual payout value rather than the original residual amount on the contract. Version 2.08 18 November 2002 ***************************** Interest Calculations * There is a new interest calculation method "Simple Interest" (Type 'S') which calculates a fixed amount of interest per month based on the Gross Interest of the loan divided by the Term of the loan. So (for example) if the gross interest on a simple interest loan is $360, and the term is 36 months, then $10 interest will be charged per month. Inertia Loans * There is a new "Inertia" feature which automatically extends the term of the loan by one month or one repayment cycle (which ever is the longer), when a loan reaches it's maturity date. This happens during the interest run prior to the date that a loan is due to mature. You need to check the "Allow Inertia" box on the Business Code to enable this. Maturity Analysis * Now uses the repayment schedule if it exists, when working out maturity dates. Prior to this, the report only used the Term of the loan and the Settlement Date, which meant if you varied the loan schedule, it would not be recognized by the report. Schedule Adjustments * Previously, Tango would alter the schedule of a loan if it saw that the total payments outstanding in the schedule would not payout the net balance of the loan. This facility may be disabled by setting the "DisableAdjustSchedule" column in SetupInformation to 1. "Client Types" * When you add a new client, the system now remembers whether or not it is a person or an organization. If you change the surname or given names on a "Person" client, the name of the client will be automatically updated. On the other hand, if you change the the surname or given names of an "organization" client, the name is unchanged, but the contact name will be automatically updated. Version 2.07 13 November 2002 ***************************** NOTE. If your database is updated, any clients not on the most recent version will not be able to enter or print GL Journals until they upgrade. * Improved GL Journal Entry interface. You can now enter debits and credits as part of the same transaction line You can skip backwards and forwards through a batch of GL Transactions * GL Statements - All transactions on a statement for the same day will be sorted first by batch number and then by reference. * GL Transaction Audit - All transactions for the same day will be sorted first by batch number and then by reference. * Form letters - New fields: OldScheduleDate - The original date of the last scheduled payment that was changed NewScheduleDate - The new date of the last scheduled payment that was changed NewScheduleAmount - The amount due of the last scheduled payment that was changed DateScheduleChanged - The actual date that the last scheduled payment was changed * Asset Register Fixed problem which showed incorrect opening balance for depreciation when not using multiple assets per loan. Fixed totalling problems on Asset Register Report. Version 2.06 7 November 2002 **************************** * New "F" type subledger to allow calculation by percentage of the original amount financed net of any charges. * Form Letters - Now allow for the following new keywords: LegalFee (total legal fees) TotalDebits TotalCredits CreditCardDescription CreditCardExpiryDate * General Ledger - The size of the REFERENCE field in GL Transactions has been increased from 8 to 20 characters. * Finance Management - The size of the REFERENCE field in FM Transactions has been increased from 8 to 20 characters. * New Expired Credit Cards report. Version 2.05 1 November 2002 **************************** * BPAY / RECal Imports Fixed problem importing data for loan accounts where the account numbers had different lengths. Previously, the import routine would only handle importing data for loan accounts where the account numbers were all the same length. * New Creditors form and view. (Setup / Creditors). The Creditors system is not operational yet, but this is one of the changes necessary prior to having a functional Creditors system. * MOnthly Interest Run Fixed bug which included periodic, GST and Stamp Duty subledgers when processing monthly subledgers. * "Arrears Snapshot" Arrears must be calculated each time you need to view it, but now there is a new stored procedure "Create_Arrears_Snapshot" which will create a table "FM_Arrears_Snapshot" containing arrears information about every account. If you want to use this information regularly, you should consider running this procedure as an "SQL Agent Job" regularly. * Subledger Sequences Ensure that subledgers appear in the correct predefined sequence when entering a new loan or looking at an existing loan. * Direct Debits Fixed problem selecting accounts with repayment variations for direct debit processing when the variation date was due on day 31 of the month. For example, at the end of September (no day 31 in September) if an account had been varied on 31 August to be debited monthly, the system would not automatically select it when you produced direct debits for the last day of September. The system will now check if you're running direct debits for the last day of the month, and if so, will ensure that it selects any accounts with anniversary days greater than the last day of the current month. * Locking Repayment Schedules Fixed bug which popped up an error message if the repayment schedules were locked down and a user attempted to alter them. The error message was causing the entire batch to be rolled back. Now, if the schedule is locked down, the system will undo any attempted changes to it, but will continue processing. * System Internals Enusre the NEXT DUE DATE gets updated whenever a transaction is posted to an account. * Paid In Full / Completed Loans report. If an account is paid out using a ZERO value payout transactions, the system will include the most recent payment transaction plus any subsequent reversal transactions when quoting the payout amount on the report. * Insurance Premium Renewals New report to select accounts that have insurance premiums that are due to be paid. * Repayment Schedules Fixed bug to ensure that repayment schedules do not get spuriously altered when posting transactions to accounts. * Form Letters New fields "TotalDebits" and "TotalCredits" Version 2.04 18 October 2002 **************************** General ------- * Fixed the annoying problem when entering ranges of dates. For example, if the TO DATE was 30/9/02 and you wanted to enter a new FROM DATE of 1/10/02, the system wouldn't let you enter the FROM DATE until you entered a new TO DATE. This check is now done when you click on the the button to produce the report. * Fixed incorrect TAB sequences on some forms. Payout Quotes ------------- * Fixed "Type Mismatch" bug. * Fixed "Discounted Present Value" payout method. Form Letters ------------ New fields: LegalFee - Legal Fee charges TermCharges - Any charges based on the term of the loan ScheduleCharges - Any charges based on the number of entries in the schedule ListRepaymentAmounts - A list of all repayments due ListRepaymentDates - A list of the dates of all repayments due ListRepaymentNumbers - A list numbering each repayment schedule entry TotalFeesLessInterest - All charges on the loan excluding interest charges Subledgers ---------- * New Calculation Methods: 'T' - A charge based on the term of the loan. The subledger value is multiplied by the term of the loan. 'S' - A charge based on the number of entries in the repayment schedule. The subledger value is multiplied by the number of entries in the repayment schedule. * Fixed bug which did not re-calculate entires correctly when you added or changed a subledger on an existing loan Version 2.03 15 Octber 2002 *************************** Creditors --------- * Added "Cost Centre" column to Creditors table. Loan Activity Report -------------------- * Fix address formatting problems. Periodic Debits --------------- * New facility to debit accounts on an ad-hoc basis based on the value in "P" (Periodic) type subledgers (as opposed to "M" - Monthly and "I" - In-full). Current/Non-Current Report -------------------------- * Fix totalling errors. Form Letters ------------ * Fix calculations in LastDishonoredPaymentAmount field * New fields: NextPaymentDate NextPaymentAmount System ------ * "IgnoreNewControls" column in SetupInformation allows you to disable the facility which prompts for security information when there are new controls on a form. Clients Form ------------ * The loans tab shows a summary of all loans, repayments, net and gross balance info for the client. Asset Register -------------- * Fixed problem which would generate an error message about "Create Table Permission" when producing report. Payout Quotes ------------- * New payout quote format * New payout method - "V" - Discounted Present Value of outstanding repayments Login ----- * Fixed bug which displayed additional "User id / Password" screen when you entered incorrect login details. Search Screen ------------- * You can now search by repayment amount and "General Purpose 8" column. Version 2.01 4 October 2002 *************************** Form Letters ------------ Bulk form letters are now printed in Account# sequence Loan Summary Report ------------------- New option to list report in Account# sequence Repayment Schedule ------------------ Modified system to allow adding new entries to the repayment schedule. Receipt Allocation Report ------------------------- Massive performance improvement - the report runs much faster. Direct Debit ------------ Fix "String or binary data would be truncated" error for accounts with long account numbers Deli System ----------- Reports can now be restricted by Branch Number. Deleting Loans -------------- Fixed error which occurred when trying to delete a loan that had changes to it's business code. Version 2.00 17 September 2002 ****************************** Form Letters ------------ New mail merge fields to assist in printing payout quotes. New ability to send a form letter to a group of borrowers using the form letter queue . Diary Notes ----------- New ability to mark some Diary Reminder notes as "High Priority" so that they always appear at the top of the notes section. System ------ New (optional) facility to prevent changes being made to the Repayment Schedule of a loan after it has been activated. Subledgers ---------- New ability to specify a null debit and credit account on a subledger which will force the system to use the GL accounts associated with the business code. This enables you to use the same subledger accross multiple business codes. Version 1.99 7 September 2002 ***************************** GST. --- If GST is payable on the Residual Value of the lease, the system will charge the full amount of the GST on the Residual, even if the payout value was less than the residual value. Principal / Interest Report --------------------------- Minor modifications to the format of the report. Form Letters ------------ New Mailmerge fields to use in letters: ApplicationFee, - various fees charged when starting up a loan DocumentFee, - " " " " " EstablishmentFee, - " " " " " StampDuty, - " " " " " TotalFees, - " " " " " GrossInterest, - " " " " " BillOfSaleFee, - " " " " " LienFee, - " " " " " CreditEnquiryFee, - " " " " " REVSFee, - " " " " " NumberOfWeeks, - the number of weeks that the loan will run for UserName, - the name of the user printing the letter RepaymentPeriod, - the frequency of payments, e.g. "weekly", "fortnightly", etc Location1, - The Location1 field on the Loans Form. Location2, - The Location2 field on the Loans Form. GeneralPurpose4, - The GeneralPurpose4 field on the Loans Form. GeneralPurpose5, - The GeneralPurpose5 field on the Loans Form. GeneralPurpose6, - The GeneralPurpose6 field on the Loans Form. Description - The Description field on the Loans Form. Bureau Processing ----------------- New facility for Type "A3" service type "Individual Risk - Value Added". Form Letters ------------ Fixed bug which removed one or two digits from the cents portion of an amount that appeared on a form- letter. E.g. $123.10 would appear as $123.1 (missing the zero). Loans / Clients --------------- Fixed the keyboard shortcuts for some of the buttons on the screen such as "Save" (Alt-S) and "Cancel" (Alt-C). General Ledger -------------- Added Business Codes and Subledgers to the General Ledger menu. Version 1.98 3 September 2002 ***************************** Loans ----- * Fixed inaccuracies in the repayment calculation routines which caused the repayment amounts to vary slightly whenever you saved a new loan in which you had altered the repayment schedule This would only happen if the repayments were subject to Stamp Duty or GST. * Increased the size of the GeneralPurpose4 and GeneralPurpose5 columns to 20 characters. * You can now change the residual value on an active loan if it is a VARIABLE RATE loan. Subledgers ---------- * A new "U" type subledger allows GST to be charged on the residual value of a lease (and not repayments). Transactions ------------ * A new "1" type transaction allows you to reduce the Gross Balance of a loan without affecting the net balance. * Changed the transaction entry program to enter the correct GL Accounts for DEBIT and CREDIT transactions. Previously, these accounts were the wrong way around. Version 1.97 29 August 2002 *************************** Loans ----- Fixed minor discrepancy in the repayment amount for monthly loans that pay one month in arrears when the interest calculation method for the system was set to the KPMG "Australia" or "New Zealand" methods. This rounding discrepancy was due to the KPMG method being slightly less accurate than the method that Tango was using. Fixed "Invalid use of NULL" message that occurred when you tried to change the subledgers while entering a new loan via the wizard. Changed the length of the "General Purpose 4" field to 20 characters. Changed the "Loans" tab of the "Clients" form to allow for longer account numbers. Previously it would only show the first 9 characters of the account number. General ------- The Upgrade.EXE file that gets downloaded when you upgrade to a new version has been compressed with a more up to date version of WinRAR which means that it will have slightly better compression and will download slightly faster. Version 1.96 23 August 2002 *************************** Form Letters ------------ Fixed bug which caused Wordview error to occur when printing some form letters that were formatted in a specific way. Receipt Allocation Report ------------------------- Ignores accounts that do not receive a payment during the period specified. Client Wizard ------------- Fixed "Error in CalculateSubledger" message which appeared when trying to enter or change a subledger while inputting a new loan. Loans ----- Fixed bug which caused the system to ignore the GST component of the Residual Repayment in the repayment schedule of a lease. Principal / Interest Report --------------------------- This is a new report which shows a projection of principal and interest for any loan. You get this report by clicking on the "Prin / Int Report" button in the "Repayments" tab on the "Loans" form. Transactions ------------ Fixed bug which caused a "Zero divide" error when posting Writeoff transactiosn to an account Version 1.95 18 August 2002 *************************** Process New Loans ----------------- Update internal repayment amount & charges amount in the FM_Loans table when activating a new loan that has a repayment schedule. Process Monthly Interest ------------------------ Update internal repayment amount & charges amount in the FM_Loans table when processing interest on loans with a repayment schedule. Lease Processing ---------------- - Repayments subject to Stamp Duty / GST will have those charges taken out when they are posted. - Fix inaccuracies with the charging of Stamp Duty & GST on Lease Payments. - Fixed bug which charged non-GST subledgers on the residual entry of the schedule. Banking ------- New facility to Import Dishonors from ANZ. Statements ---------- There is a new internal flag in the SetupInformation table which lets you control whether or not to consolidate special charge payments with other payments. The flag name is ConsolidateSpecialChargePayments If it is 0, Special charge payments will be treated separately from other payments. If it is NOT 0, Special charge payments will be treated TOGETHER with other payments. Current / Non-Current Analysis Report ------------------------------------- New report to split the current and non-current portions of Interest, Principal and Gross Receivable. Version 1.94 9 August 2002 ************************** Form Letters ------------ Fixed bug in Form Letters which caused Mail Merge fields to appear in a different font on the form letter compared to the actual text of the letter. Leasing ------- Fixed bug in calculation of Gross Interest for accounts with residuals Fixed bug in calculation of repayment amounts for accounts with GST. General ------- New repayment frequencies of quarterly, 6-monthly and annually. Changing Schedules ------------------ Fixed bug which caused this error message to pop up when you tried to change the repayment schedule on an active loan: "Error in Form_Open. Column 'FM_Loans.ResidualValue' is invald in the select list because it is not contained in either an aggregate function or the GROUP BY clause." Version 1.93 7 August 2002 ************************** MAJOR VERSION UPGRADE. Ensure you have a good backup before installing. Branch Grouping --------------- Branches may now belong to Companies which allows you to prevent users from one branch looking at loans or clients from another branch if those two branches do not belong to the same company. If you don't specify it, all Branches will belong to the "Default Company". Leasing ------- * You can now enter residual values on loans. * Residual values and lease repayments may now be subject to GST if you specify a GST subledger for the lease. General Ledger -------------- Profit / Loss balances for a prior financial year will automaticallY appear in the profit / loss appropriation account (Retained Earnings) as at the following year. There is no need for an "End of year rollon". It's all done automatically. Importing Dishonors ------------------- Fixed bug which caused dishonor transactions imported from a file from the bank to debit and credit the wrong accounts in the GL. Loan Summary Report ------------------- * This report now runs much quicker. * New option to sort by account name instead of by business codes. Form Letters ------------ New fields available for form letters: LastDishonoredPaymentDate LastDishonoredPaymentAmount Security -------- New security object SO_Assets allows you to control access to asset-related features specific to leasing. New role Tango_Asset_User to help you control access to asset-related features specific to leasing. Update facility --------------- A new "Manual Version Upgrade" option on the "Users" menu to let you manually download a new version if your local internet setup / proxy server doesn't allow tango to automatically download a new version for you. Version 1.92 30 July 2002 ************************* Refundable Subledgers --------------------- You can now specify whether or not a subledger is refundable in the event of a flat cancellation. For example, QLD Stamp Duty is refundable if an account flat cancels. Refundable subledgers will be shown on the completed loans report. Form Letters ------------ New fields on form letters: ThisYearInterest: The amount of interest charged on this loan for the current financial year. LastYearInterest: The amount of interest charged on this loan for the previous financial year. Payout Reversals ---------------- When you reverse a payout, the system now clears out the payout date. Completed Loans Report ---------------------- Modified to only show the ODI component of payouts. Modified to only show refundable subledgers. Import from IBS --------------- Modified to not incorporate direct debit overrides as part of the repayment schedule. Modified to include the residual value when generating a repayment schedule. New credit card facility - CARDLINK ----------------------------------- See http://www.cardlink.com.au Tango can create files in a format which can be processed by CardLink for processing credit card deductions. Direct Debits ------------- Fixed bug with direct debits procedure which would not select direct debits properly if: 1. A direct debit variation was in place and you tried to run the direct debits for only one day. 2. You did not set the "Cancel Prior Direct Debits" option (which ensures a direct debit variation cancels an existing direct debit schedule, even if the variation occurs after the original direct debit was due). Direct Debit Variations ----------------------- Modified to ensure that when you specify a date for a variation, it does not contain a time component. E.g. The variation starts on 1 July 2002, not 1 July 2002 at 9.00am. Version 1.91 16 July 2002 ************************* Transaction Audit Report ------------------------ Fixed error which occurred when trying to select manual debits and manual credits. Business Code Changes --------------------- Fixed error which occurred when trying to print business code changes. Transaction Import ------------------ Added facility to strip out leading zeros from data imported from Australia Post. The import routine will not try to remove check digits from Australia Post data because the check digits have already been removed. Completed Loans Report ---------------------- Fixed bug which showed the ODI component of paid-in-full loans as negative bad debts. Version 1.90 15 July 2002 ************************* Completed Loans Report ---------------------- Shows a transactional summary of Flat Cancellations, Buy Backs, Payouts and Writeoffs. Diary Reminders --------------- If you print the diary reminders for one loan, they will be sorted in "Date Entered" sequence. Form Letters ------------ New form letter fields for the Select_FormLetter sP: BorrowersOfLoan - The borrowers of the loan BusinessCodeDescription - The description of the loan's business code PayoutComment - The first diary reminder that has an action code of "COM". Version 1.89 11 July 2002 ************************* General Ledger -------------- Fixed bug which caused strange error messages to appear whenever you tried to add a new GL account Client / Loan Search -------------------- The Business Code and "General Purpose 1" field will be displayed when searching for a loan by account number or keyword. The "General Purpose 1" field is also displayed in the loan header area of the loans form as well as the "Repayments" tab. Loan Activity Report -------------------- Now shows weighted interest rate. Loan Summary Report ------------------- Now shows weighted interest rate. Subledgers ---------- If a subledger has a rebate method, you can enter a cancellation date. Go to the subledgers tab on the loans form, double click on a subledger entry, and enter a cancellation date. The form will turn RED to make it easier for you to see that it has been cancelled. Next Due Dates / Delinquency ---------------------------- Fixed bug in the calculation of the Next Due Date which was affecting some delinquency reports. Interface --------- New procedure "Insert_FM_Loans" to allow external systems to add loans into Tango. Version 1.88 9 July 2002 ************************ MDAC ---- Help / About will now show which version of MDAC you are running. Delinquency ----------- If you use the Delinquency System to create diary reminders, any reminders with action dates AFTER the as-at date of the delinquency reports will be excluded. Version 1.87 19 June 2002 ************************* #NAME? Errors ------------- Fixed bug which caused #NAME? to appear on some reports and forms instead of valid data. This bug was caused because your machine was running version 2.5 of Microsoft Data Access Components (MDAC 2.5) and the prior version of Tango was writtin using MDAC 2.6. We have re-released Tango to use MDAC2.5 but for long-term compatibility you should consider upgrading your MDAC software to version 2.6 SP1 or later. To install the latest version of MDAC on your machine, please visit http://microsoft.com/data. Future versions of Tango will check your version of MDAC and upgrade your software automatically if needed. Version 1.86 19 June 2002 ************************* Receipts Deposits Listing ------------------------- * Shows company address at the top right of the report. Version 1.85 19 June 2002 ************************* Loan Summary Report ------------------- * You can now produce a report that will select only those accounts that have negative arrears. Just enter: From Arrears Days -9999 To Arrears Days -1 Payday Advance Consumer Credit Code Form Letters ------------------------------------------------ * The PDA form letter fields now have the correct number of decimal places. Interest Only Loans ------------------- * If a loan has an interest only business code, the residual value will always be updated to be equal to the net balance, whenever the net balance changes. * Drawdowns force residual to be equal to net balance on interest only loans * Interest on Interest-Only loans updates payments due in repayment schedule Special Charges --------------- * Fix problem which caused special charge payments to incorrectly alter the repayment schedule of a loan. Direct Debits ------------- * Fixed SQL error which caused Direct Debits to occasionally not get selected. IBS Conversion -------------- * Sometimes when converting data from IBS Finance into Tango, the system generated strange arrears balances. Problem fixed. Reversal Transactions --------------------- * Fixed bug which caused Reversals to show the wrong sign in the GL. Receipts Deposits Listing ------------------------- * New report to assist with banking - lists details of all receipts received for either a range of batches or a range of dates. Transaction Audit Report ------------------------ * New modifications make this report run much quicker. Diary Reminders --------------- * When used in conjunction with the Delinquency Report, the Diary Reminders show diary reminders with the most recent Date Entered, sorted by Action Date. Version 1.84 1 June 2002 ************************ special Charges --------------- Fixed a bug with special charges: if special charges were automatically deducted from a repayment, the replaymentn value was not correspondingly reduced. Form Letters ------------ Added new fields to formletters: NumberOfDays : Number of days that the loan is for PDAFee : Establishment fee of loan ApplicationFee: Application fee of loan TotalFees : Total fees payable on loan NumberOfRepayments: Number of repayments that will be made RepaymentAmounts: A list of the different repayments to be made RepaymentDates: A list of the dates when repayments wil be made DueToComplete : The date the loan is due to complete TotalFinanced : Total amount financed for loan Loan Summary Report ------------------- If you enter a "From Arrears" of -9999 and a "To Arrears" of -1 the system will list out all loans with a negative arrears balance. Negative arrears balances will now show correctly on report if required. Bureau Processing ----------------- Most features of the Credit Bureau Processing system are now complete. Variable Rate Loans ------------------- You can now set up variable rate loans. New functionality has been added to change the interest rates and repayments on all loans in a business code. The GROSS BALANCE on a variable rate loan is meaningless. Any reports which show a Gross Balance for a variable rate loan will show the net balance instead. Flat Cancellations ------------------ If a loan is Flat Cancelled, "Flat Cancel" will appear in the loan status field. Replacement Account Numbers --------------------------- You can now specify a replacement account number to be used when importing transactions from the bank. A customer may show up as using a different account number if you issue a new deposit book or repayment card to them. Enter replacement account numbers in the "General Tab" on the Loans Form. Delinquency ----------- A new option to show the most recent diary reminder for each account that appears on the delinquency report, split according to which collections employee is managing the account. Version 1.83 20 May 2002 ************************ Buy Backs --------- A new transaction type "B" (Buy Back) can complete a loan. It will mark the loan with a status of "Buy Back" and will behave in the same way as a flat cancellation. Bureau Enquiries ---------------- Additional enhancements to allow Bureau Enquiries to be submitted. Process New Loans ----------------- Fix "Data would be truncated" error. Interest Calculations --------------------- Fix "Null Data" problem for zero interest loans. Loans Form ---------- Tidied up screen. Version 1.82 19 April 2002 ************************** Flat Cancellations ------------------ Reverals of flat cancellation transactions should be entered as "Z" (Payment Reversal) transactions. The system will flag these transactions so that they are also flagged as negative value Flat Cancellations for reporting purposes. Flat Cancellation Transactions do not generate any interest or ODI transactions when they are posted or reversed. Form Letters ------------ You should get all form letters to use the stored procedure "Select_FormLetters" rather than directly accessing a view such as "FM_Clients_By_Loan" or "FM_Loans_By_Client". Added new merge fields to this feature for: Gross Balance Maturity Date Anniversary Day Number of Payments Remaining We have written a new utility "FixRTF.MDB" which will try to fix any problems with RTF files that you want to use as form letters. There is a bug in Microsoft Word which incorrectly formats MailMerge RTF files. Our utility attempts to work around this bug. The utility is available at http://tango32.com/downloads/fixrtf.mdb and requires Access 2000 for you to run it. Delinquency ----------- Fixed bug which prevented the following from happeing: The system shows a comparison percentage for "Total Receivables" and "Total Number of Accounts" against the same figures for the previous month. This data is updated during the month end / monthly interest run process. Scoring ------- The Format Fields table now allows up to 512 characters for the data source name. There is a new stored procedure which automates the transfer of applicant details from the "AmaSys" loan application system into Tango. The specs are: Create Procedure User_ImportClient_01 ( @KeyValue int, -- external key from Amasys system @ApplicantNumber int, -- 1 for applicant #1, otherwise 2 @ClientNumber int output -- return ID of client created ) Logon ----- In certain unusual circumstances you might find that the list of valid database names in the logon screen contains invalid names which makes it almost impossible to log in. We added an "Options" button to the logon screen so that you can change the values that appear in the list of valid database names. Version 1.81 27 March 2002 ************************** Help Text --------- Special thanks to Helen Smith for our new Help files! When you download and install the latest version, it will ask you if you want to get the latest help files. You should answer "YES" to this question so that Tango can download the help files from our web page. The Help Files are in a more easy to read CHM format that you may be used to with other Windows programs. Form Letters ------------ If you make the recordsource of a form letter the SP "Select_Formletters" you will be able to show the Gross Balance of a loan in the form letter. Delinquency ----------- Now has the ability to ignore small arrears balances when working out whether or not an account should appear on "Reportable" or "Potential" reports. You can control this by setting the "DelinquencyThreshold" in the SetupInformation table. The system now shows a comparison percentage for "Total Receivables" and "Total Number of Accounts" against the same figures for the previous month. This data is updated during the month end / monthly interest run process. Arrears Calculations -------------------- Modified to optionally ignore balances that are less than the "Delinquency Threshold" (see above). Clients ------- Added a "Gender" column to the "Titles" table to help when preparing enquiries for the ratings bureau. Created a "Street Type" table for validation purposes to help when preparing enquiries for the ratings bureau. Loans ----- New facility to DEFER INTEREST until a future date. Interest or ODI will not be charged until the Deferment date. Transactions ------------ Modifications to the Import procedure to correctly handle a variable number of check digits when importing from BPAY / RECALL (WBC) formats. Modifications to more intelligently match up account numbers imported from from external files. For example, if the bank statement shows account 12345 and you only have an account 1234502, it will match up because the accounts have the same starting digits, and will warn you that it made the change. Scoring ------- Increase comment size in SC_FormatFields to 256. Version 1.80 19 March 2002 ************************** MAJOR VERSION RELEASE. PLEASE BACKUP YOUR DATABASES BEFORE INSTALLATION Scorecards ---------- The scorecard system is now fully operational. You can design your own scorecards, and use them to rate potential clients. Importing from external system ------------------------------ The import facility is now fully operational. You can use this to pull in data about clients from an external system such as an application processing system. Arrears ------- Fixed these bug: in arrears calculations: A payout on an account which was subsequently reversed used to inflate the arrears balance. The total arrears figure that appeared on the Loan Summary Report and in other places in the system did not always add up to the sum of the 30/60/90 day columns Delinquency ----------- Modifications to the layout of the delinquency report. Fixed bugs which failed to select accounts which were in arrears under certain circumstances Form Letters ------------ Stripped the TIME component of the date that was used to record repayment variation details. Transactions ------------ The "Auto Complete" feature will not complete an account if it is HELD. "Flat Cancellations" do not generate Interest or ODI transactions on a loan. Loans ----- If authorised to, a user may change the account# of an active account. If the account# is changed, the system records this in the diary notes. If authorised to, a user may change the business code of an active account. If the business code is changed, the system records this in the diary notes. There is a new report to list the history of changes to business codes. Version 1.79 27 February 2002 ***************************** Loan Summary Report ------------------- Modified calculations to include a delinquency threshold. Arrears Processing ------------------ Option to ignore special charges when calculating arrears Loans Form ---------- Option to allow / disallow changing business codes on active loans Scorecards ---------- Options to allow the easier importing of data from external systems. RECALL direct debit formatting ------------------------------ Fixed problems with long account numbers Form Letters ------------ Modification to print form letters from the output of a stored procedure, not just tables and views. Views ----- This version rebuilds all views. You should only instal it if other people aren't using the system, or they may experience some errors. Version 1.78 13 February 2002 ***************************** Next Due Date ------------- Fixed bugs in calculation of Next Due date for accounts with a repayment schedule Security -------- Prevent changes to repayment schedule if an account is active and the user is not authorised to make changes to it. NOTE. Users can change the repayment schedule of any loans that are yet to be activated. New Loans --------- When creating a new loan via the wizard, if you print a form letter from the wizard, the details of the letter are added to the diary reminders of the loan. Thanks to Trang Le of AMA Finance Corporation for this suggestion. Clients ------- When altering the client bank details, if you de-select the "Direct Debit" or "Credit Card" check boxes, the system will warn you if you have existing bank account or credit card details. Previously it displayed an error message which prevented you from leaving bank account or credit card details in accounts that were not currently paying by direct debit. Thanks to Craig Dufficy of International Acceptance for this suggestion. Version 1.77 8 February 2002 **************************** Loan Transactions ----------------- * New "Flat Cancel" transaction is similar to a "Payout" transaction except that it flags the transaction differently so that it can be reported differently. * Fixed bug which was not correctly posting to the Bad Debt account for loans which underpaid the payout amount. GL Statements ------------- Fixed bug which did not export either the debit or the credit column when exporting the statement to MS-Excel Payouts ------- When paying out an account, interest may be optionally calculated up to the day of the payout instead of the day before. Please contact us if you want to know how to enable this feature in your system Deliquency ---------- A new optional format for the delinquency reports. Please contact us if you would like to use a different format for your delinquency reports. Scorecards ---------- * Fixed problems which occurred when trying to enter scorecards for clients. * INcreased scorecard descriptions to 150 characters. Invoicing --------- Tango Invoices can now use the Payment Schedule as a basis for invoicing. Version 1.76 10 January 2002 **************************** Scorecard System ---------------- Modifications to underlying table structures Loan Activity Report -------------------- Fixed bug which showed incorrect first payment due date. Delinquency System ------------------ You can now stipulate that special charges do not affect the next payment due date, even though they may generate a an extra payment in the schedule. To enable this, go to Setup / Parameters / Loan Information and check the field called "Next Due Ignores Special Charges". Transaction Processing ---------------------- When the system schedules extra repayment entries for special charges, it flags them so that they are not treated the same as normal contractual payments. Loan Summary Report ------------------- You can now select entries on this report by their net balance. Delinquency System ------------------ Fixed bug which was not excluding accounts with below the specified threshold. Version 1.75 7 January 2002 *************************** Delinquency System ------------------ * Fix problem which wouldn't allow reports to print in NextDue sequence. * New Employee Target figures are included on the reports, with total collections for the month. Loans ----- If you change the business code of an active loan, the system will update the interest rate of the loan as well, provided that you alter the new flag in the system parameters screen to say this is what you want to happen. Version 1.74 2 January 2002 *************************** Loan Summary Report ------------------- Shows "Next Due Date" on report. Direct Debits ------------- You can configure the system to ignore any standard repayments if a repayment variation is entered on an account. To enable this feature, go into Setup / Parameters / Loan-Other and enable the flag: "Variations Stop Standard Repayments". Fixed "Out by one" error which caused Direct Debit program to select weekly and fortnightly accounts one day late. Scoring ------- Added basic components of credit scoring system to Client Form. Also added Scorecard setup forms in Setup / Scoring menu. Payout Reversals ---------------- Fixed problem which would not allow reversals of payouts on some accounts (partial cents error) Repayment Calculations ---------------------- New repayment calculation method to comply with actuarial calculations supplied by KPMG accounting company. To enable this go into Setup / Parameters / Interest Charges and alter the "Repayment Calculations" section. Interfaces ---------- New system to allow creation of clients from an external program. See new procedure Insert_FM_Clients New feature to allow you to import client data from an external source. See Development / Import / "Import Client SQL". Version 1.73 12 December 2001 ***************************** Loan Summary Report ------------------- Fixed problems with aged arrears Delinquency System ------------------ Fixed problem which showed accounts in report that weren't in arrears Wizard ------ The system will warn you if you enter a new loan for an client that already has an active loan, and will give you the chance to view the details of the loan. Statements ---------- "NET BALANCE" format statements no longer show "REBATE" transactions. Arrears ------- Accounts which are completed on or before the "as at" date of an arrears calculation will show as having a zero arrears balance. Payouts ------- Fixed bug with reversal of payouts which caused account to have incorrect net balance and therefore made subsequent payouts inaccurate. Version 1.72 9 December 2001 **************************** Scorecards ---------- Create initial objects for use in Scorecard system which will soon be released in a new version. Loan Summary Report ------------------- Fix ageing problem which showed 1-30 day arrears in the 60 day column. Delinquency System ------------------ Fixed tables to ensure ID numbers were automatically assigned to new entries. Drastic performance enhancement for delinquency processing. Fixed bug which showed multiple entries on the delinquency report if an account had more than one borrower. Loans ----- A new administrator function which allows you to change the account number on an active loan. A new function to prevent unauthorized users from changing the repayment schedule on active loans. Direct Debits ------------- Fix "ambiguos column name: repaymentvariationstart" error when processing vanilla accounts (accounts with no schedule) with variations Version 1.71 26 November 2001 ***************************** Loan Summary Report ------------------- If you specify that you only want active accounts, and you have accounts in the system that completed ON OR AFTER the as at date of the report, they were being excluded in error. The system correctly includes them in the report now. Loan Activity Report -------------------- Now includes Phone Number, Address and First Payment Date information System Log ---------- The dbo now has a new function which displays a history of all logins into the system including user name, workstation id and Tango version. This helps in keeping track of who is accessing your system and what version of Tango they're running. Registry Settings ----------------- The dbo now has a registry settings table which allows you to specify Tango registry settings which should be applied for all users. This is useful if you want to enforce the User Preferences for your system to all refer to the same help files, form letters, word processor version, etc. Clients / Loans --------------- Fixed bug which caused system to crash if you had data that was imported from IBS Finance and at least one of your accounts had a "." character in it. Version 1.70 21 November 2001 ***************************** Direct Debits (IMPORTANT) ------------------------- There is now a "Direct Debit Variation" button on the repayment schedule screen. This is another way of overriding the standard repayments of a loan for direct debits. Direct Debit Variations take precedence over the repayment schedule. So if the "Direct Debit Variation" says one thing, and the repayment schedule says another, the direct debit program will use the "Direct Debit Variation" information instead. Clients ------- You can now enter an Email address on a clients record. If you double click on the email address, you can send an email to the client. Searches -------- The searches by client name are now much faster. You can now search on the "General Purpose 2" and "General Purpose 4" fields on a loan. Version 1.69 19 November 2001 ***************************** Maintenance Release - fixes problems upgrading databases which contain transactions dated prior to 1/1/2000. Version 1.68 16 November 2001 ***************************** This version will take a backup of your database before installing itself. The backup will be stored in the root directory of the drive on which your database resides. Process New Loans ----------------- Fixed bug which was posting wrong journals to Unearned Income and Loans Receivable. The system will automatically correct any incorrect journals that may have been generated. Payout Quotes ------------- You can now do a payout quote for a loan, even if it hasn't been activated yet. GL Account Search ----------------- The search fields now get cleared when the form is first displayed. Wizard ------ Fixed incorrect captions which appeared at the top of the form when entering a new loan. Fixed navigation logic which showed the wrong screen when you pressed "BACK" from the first screen of the wizard GL Transactions --------------- Fixed a bug in the database which was incorrectly recording the date entered of GL journals. Form Controls ------------- Fixed bug which caused system to run incredibly slow when logged in as DBO and using the loans form. When you install this version, the system will remove any duplicates from the Form Controls Table. Development Menu ---------------- Rearranged the items on the "Development" menu to make it more readable. Version 1.67 13 November 2001 ***************************** MAJOR VERSION RELEASE When you upgrade to this version, the system will apply several important fixes to Journals in your General Ledger as described below. We STRONGLY recommend you back up your databases before installing this version. Process New Loans ----------------- Fixed bug which did not create journals for unearned income when new loans were activated. When you upgrade to this version, the system will create these journals for ALL interest bearing loans in the system that have gross interest recorded against them Monthly Interest Run -------------------- Fixed bug which posted the interest income and unearned income journals round the wrong way. The system will automatically fix any journals that were created the wrong way round,when you upgrade Adding Clients -------------- Fixed error which occurred when you use the Client / Search / Add sequence to add a new client. Statements ---------- Fixed the annoying error messages which popped up whenever you tried to change the date range on the prompt screen for statements Wizard ------ Fixed bug which updated loans with the wrong amount of gross interest when you added new interest bearing loans and altered the repayment amounts. Loan Form --------- Fixed bug which altered the repayment amounts back to old values after you had changed them for a new loan. General Ledger -------------- The system will now ignore (not post) any zero value transactions into the ledger. Any existing zero value transactions will be deleted. Version 1.66 9 November 2001 **************************** Process New Loans ----------------- Fixed OLE Error which occurred if you tried to process loans that had non-internal subledgers. (Due to truncation error in SP) Fixed error which prevented the system from reporting the correct error message when the Process New Loans function failed. Fixed potential error in posting subledgers on new loans when they belonged to Tax-Based business codes. Version 1.65 8 November 2001 **************************** Delinquency Reporting --------------------- The Delinquency Reporting System now allows you to specify your own selection criteria for reports. Next Due Date ------------- Fixed bug in the calculation of the "Next Due" date Reversing Payouts ----------------- Fixed bug which caused incorrect net balance in accounts after a payout had been reversed Loan Summary Report ------------------- Add Gross Balance, Term and Business Code Description to report Loan Activity Report -------------------- Add Business Code Description to report Repayment Schedule ------------------ Fixed bug in "Change Repayment Schedule" screen which casued the system to create an incorrect gross balance when varying repayments on accounts. Loans Form ---------- When editing a new loan, the system no longer recalculates the repayment amount. If you want to do this you have to press the "RECALC" button. Version 1.64 5 November 2001 **************************** Repayment Schedule Report ------------------------- Changed layout so that the address information appears in the address window of an envelope Transactions ------------ Fixed bug in Loan Transaction Entry which prevented the entry, importing, or exporting of batches that contained loan account numbers longer than 8 characters. The maximum loan account number size is 20 characters. BPAY ---- You can now import repayments from a BPAY "RECALL" format file. Importing Dishonors / Direct Debits ----------------------------------- You can now import dishonors and direct debits from the NAB for more than one bank account. Previously you had to do the import for each bank account separately. Creating Direct Debits ---------------------- * Fixed problem with "Redoing" direct debits. * You can now "Redo" a direct debit for an account when that account was paid out by the last direct debit. Importing from IBS ------------------ Importing loans from IBS will now take into account any repayment variations that were in effect for the account. Note: In Tango, repayment variations affect the arrears balance. Rescheduling Payments --------------------- Fixed bug which altered Gross Balance of loan when altering the repayment schedule on a loan that had outstanding special charges. NOTE. This upgrade will force the GROSS INTEREST balance to zero for ALL loans that have a zero interest rate. User Stored Procedure --------------------- Added "Completion Date" to "Select_TransactionSummary_User01". Invoicing --------- Tango can now print Invoices for accounts that have assets. Performance ----------- Added extra indexes to the FM_Loans table to improve performance. Indexes on Settlement Date and Instalment Date. Loan Activity Report -------------------- Added new "Loan Activity Report" which shows all new or completed loans which were processed for a particular range of dates. Transaction Batch Summary ------------------------- If you select the "Summary Only" option of the "Transaction Audit Report" the system will print a report showing the totals for each batch entered during the from / to dat range that you enter. Version 1.63 20 October 2001 **************************** Fixed bugs with the 'Redo' option for direct debits Version 1.62 16 October 2001 **************************** Cheque Cashing -------------- Cashed Cheques now properly show as "complete" once they have been processed. Cheque Cashing Report --------------------- The report now selects by date of entry rather than cheque date. Receipts -------- The receipt now shows the transaction date. Direct Debits ------------- The direct debits now work correctly when you select the 'Redo' option. Transaction Entry ----------------- The system will now automatically payout an account when you enter a 'P' transaction that reduces the net balance below the threshold amount. Version 1.61 11 October 2001 **************************** Cheque Cashing -------------- * Prints a receipt * Fixed bug which caused an error if the cheque date was different from the start date * Cheques to ensure that cheque date is not after start date. Transaction Entry ----------------- 'Z' Dishonor transactions show up colored red Daily Activity -------------- Fixed bug when printing report rather than previewing it, and when printing by Branch rather than Branch / User. Version 1.60 10 October 2001 **************************** Rechedule Payments ------------------ When you change the repayment schedule the system will include outstanding special charges and ODI in the scheduled repayments. Autopayout ---------- The system will add any outstanding special charges and ODI to the net balance before checking to see if the balance has fallen below the threshold for which accounts should be automatically paid out. Cheque Cashing -------------- A new cheque cashing facility has been added which allows you to advance cash based on a cheque presented by a client. The system will record the details of the Bearer and the Drawer, and will print a "Cashed Cheques Report". Make sure you have at least one business code with the "Cheque Cashing" flag enabled. Make sure that business code has a subledger for recording the Cheque Cashing fee. When you process a cashed cheque, the system creates a Loan Account with one payment receipted to it. The Loan Account will appear to be paid out, and will only every be active if the cheque is dishonored. The Loan Account related to a cashed cheque will have a button on the "Contract" tab which will allow you to display the details of the cheque. Daily Activity Report --------------------- A new option "Daily Activity - This User" allows you to print a report only for the user running this report. In other words "Show all activity that I have done today". Form Letters ------------ Fixed bug in form letters which was incorrectly printing large numbers of letters sent to the form letters queue. Cash Receipts ------------- When you enter a transaction, there is now a new button which lets you print a receipt for the transaction. Branch Addresses ---------------- When you print a customer statement, the name and address of your branch will be printed at the top of the statement if you don't use letter head stationery. Searching --------- Improved the performance of the Client Search screen. Lockups ------- Fixed bug in "Process New Loans" option which would cause the entire database to lock up if you entered a loan which had repayments due before the settlement date. The system no longer allows repayments to be scheduled before the settlement date of a loan. Transaction Entry ----------------- The system will now record the user id of the person who enters a transaction into the system. Previously it only recorded the user id of the person who POSTED the transaction. Reversals --------- Fixed roudning errors which caused the system to occasionally reject repayment reversals ('Z' transactions) when they were entered against a loan. Version 1.58 11 September 2001 ****************************** Form Letters ------------ Fixed minor bugs in the form letters system when printing via WordView for loans with more than one borrower. Clients ------- Added a "Work Phone" field. Transaction Audit Report ------------------------ Fixed bug which caused double-ups of transactions on the report when a loan had more than one borrower. Daily Activity Report --------------------- Fixed bug which caused errors when running in a database where there are no branches. Transaction Entry ----------------- Fixed bug which caused entry problems when trying to post transactions into a database where there are no branches. Modified system to not ask "There are unprocessed loans, do you want to process new loans?" before entering Loan Transaction Entry, if the user isn't authorised to process new loans anyway. Version 1.57 8 September 2001 ***************************** Form Letters ------------ Fixed minor bugs in the form letters system. Added a new form letter "AllFields.RTF" which you can use as the basis for other form letter. Added a new option to import RTF form letters into Tango, to save you having to manually set up the details from within Tango. Select "Setup" / "FormLetters" / "Import" Improved the user interface for form letters. Changed the Form Letter Queue screen to refresh after printing queued form letters. If you use the Print Form Letter option while viewing a loan, the details of the action will be recorded in the diary reminders of the loan. Version 1.56 5 September 2001 ***************************** Form Letters ------------ Fixed bug with form letters that would not print letters when there was more than one client associated with a loan. Added new columns to the FM_Clients_By_Loan view to make it easier to write a form letter. These extra columns are: Arrears30Balance Arrears60Balance Arrears90Balance Arrears90PlusBalance ArrearsTotal ArrearsDays RepaymentAmount FirstPaymentDate NOTE. The arrears balances are for reporting purposes only, and are updated during a monthly interest run or whenever a payment is posted against the account. Added new button in the form letter screen to allow you to preview a form letter. Loans ----- You can see the business code and status of a loan when doing a search for clients. The most recent loan and it's status will appear in the title bar of the client form when you view the details of a client. Direct Debits ------------- Fixed the problem with rounding errors when producing a Direct Debit export file in ABA format. Column Sizes ------------ Both the Client# and Account# columns have been expanded to allow up to 20 characters. ODI --- Fixed minor bug in Overdue Interest calculations Version 1.53 28 August 2001 *************************** New facility to add new users to the system and grant them various roles. Version 1.52 27 August 2001 *************************** You can search on partial account number details by keying the first few digits (at least 3) of the account number into the SEARCH BY KEYWORD field of the client search form The system records the end of month arrears balance of the loan against each account so you can use the figures in form letters. Importing from IBS allows you the facility to convert all loans whether structured or unstructured into loans with a repayment schedule. Version 1.51 23 August 2001 *************************** Modifications to screen handling routines to reduce the possibility of long delays due to "deadlock" problems. Modification to Direct Debit export routines to ensure the export file works properly with the NAB. Version 1.50 18 August 2001 *************************** Fixed problem which made it impossible to print statements. Added new Credit Card facility so people can pay their loans by credit card as well as Direct Debits. (Note the export facility won't be able to create Credit Card Export Files until next version). Version 1.49 16 august 2001 *************************** The Loan Account Number field can now be up to 20 characters long. The Action Code on a diary reminder can now be up to 4 characters long. Fixed problem with Loan Summary Report which was incorrectly including both 30 and 60 day arrears balances in the 30 day column. Fixed direct debit export routine to include a carriage return at the end of the file so it would work properly with the NAB. When searching for a loan, you can now see the business code in the search results list box. Increased the size of the Reference field in the Identity tab for clients to 100 characters. Fixed problems when posting direct debits which caused GL Debit and Credit transactions to go to the wrong GL accounts. Improved the Import function from IBS to speed up importing GL Transactions. If you have multiple branches per workstation, and you set the "Use Branch Address on Reports" option in Setup / Parameters / General, the Customer Statements will now show the Branch Address at the top, rather than the head office address. Version 1.48 12 July 2001 ************************* If you change the status of a new loan to HELD before you process new loans, the system will not activate that loan. Fixed page totalling problems with GL Statements. Previously if a GL Statement went over 2 pages, the opening balance at the top of the subsequent page was incorrect. Changed the balance calculation routines in the General Ledger. This version will validate existing GL balances and may take a long time to run the first time it is installed. The "Export Repayment" screen now shows the title of the bank account you are going to use when creating direct debits. Modified the internal routines to stop a "Timeout" error which occurs when you try to run SQL commands that take more than a couple of minutes to complete. Version 1.47 6 June 2001 ************************ Fixed error when trying to print customer statements using consolidated Interest, Payments and Fees. You now get the option of browsing new loans before posting any transactions. You can now specify an alternate location of MS-Word in User/Preferences if Tango can't find a valid reference to it in your registry. Minor performance improvements when opening and closing screens. Version 1.46 24 May 2001 ************************ The system will display an error if you try to add a client with banking information but forget to check the "Direct Debit" checkbox. Tango32 now uses the XJPG20.OCX system file so that it can display photos on machines that don't have a JPG graphics filter. Version 1.45 20 May 2001 ************************ Fixed problem with loading photos. Version 1.44.01 18 May 2001 *************************** Minor bug fixes --------------- Fixed "File already open" error with Camera routines. Fixed "Type mismatch" when downloading new version. NOTE. Because Version 1.44 had errors in the "Check for new version" option, you have to upgrade from this version manually as follows: 1. Click on Help / Address 2. Type "tango32.com" [enter] 3. When the web page loads, click "Manually install upgrade now". 4. Click "Run from current location". 5. While the upgrade is downloading, close Tango32 (File / Exit). 6. When the upgrade starts, click "EXTRACT" to install it. Version 1.44 16 May 2001 ************************ Camera Support -------------- * Fixed minor bugs with Camera routines. Version 1.43 15 May 2001 ************************ Camera Support -------------- * Added support for AXIS web camera. You can now store photos of the client in the database. See http://www.axis.com for info about web cameras. Repayment Schedule Safeguard ---------------------------- * Added safeguard mechanism to Repayment Schedule. Whenever a transaction is posted for a loan which has a repayment schedule, and the repayment schedule is not yet complete, the system will double check that the total repayments in the schedule will eventually pay off the balance of the loan. If there are insufficient repayments, the system will alter the schedule so that it does eventually pay off the balance of the loan Customer Statements ------------------- * Fixed formatting problems with statements: - Negative debits now appear as positive credits - Negative credits now appear as positive debits - The Loan Account and Customer Name appear at the foot of subsequent statement pages - "Page X of Y" is displayed at the foot of subsequence stamement pages. Loan Summary Report ------------------- * Fixed bug which didn't allow the selection of loans which were held. Direct Debits ------------- * Fixed bug which wouldn't select direct debits for new loans Version 1.42 19 April 2001 ************************** Maturity Analysis ----------------- * Fixed Error 2757 Transaction Audit Report ------------------------ * Fixed Error 2465 Customer Statements ------------------- * You can now print a statement for a customer even though it has no transactions in the given date range. Daily Activity -------------- * The daily activity report allows exclusion of transactions that were generated by direct debit. Wizard ------ * Shows whether or not a client has the "Stop Credit" flag turned on. Version 1.40 3 April 2001 ************************* Loan Details ------------ * While browsing the repayment schedule of a loan, you can click on the "Banking Info" button to display the banking information for the loan. Wizard ------ * While entering a new loan, the wizard will assume that the new client has direct debit information by default. Assets ------ * Implemented asset management routines. Assets can form part of loans. Assets have Cost Centres and Item Types. Assets can be reported on the Asset Register report. Version 1.38 12 March 2001 ************************** Posting "Reversal" transactions ------------------------------- * Fixed bug in reversing transactions with associated special charge payments. Assets Register --------------- * Added "Minimum WDV" columns for Tax and Book values in the FM_Assets table New database role "Tango_Manager" higher in authority than "Tango_Supervisor" but lower in Authority than "Tango_Administrator" Wizard ------ * New option to edit a loan when you click on "finish" * Fixed "Invalid use of Null" and "Type Mismatch" errors when you click "Finish" on the final screen of the wizard. Loan Summary Report ------------------- * New option to summarize the report by business code Version 1.37 5 March 2001 ************************* * Hearbeat Monitor - now shows clock time of server * Changed "Blackban" flag to "Stop Credit" flag * Changed Wizard to allow option of entering additional borrowers for a loan * Changed Setup / Parameters / General to have a flag which prevents users from getting the system to remember their password so they don't have to enter it when logging in. * Fixed "Error_open. Invalid use of null" message when trying to use the "Reschedule" button in the repayment section of a loan. Version 1.36 26 February 2001 ***************************** Heartbeat Monitor ----------------- * Some users have experienced problems when connecting to the database over the internet using ADSL connections. If you don't use Tango for a few minutes, the connection to the database gets broken. We have rectified this via a "Heartbeat Monitor" which sends a short pulse to the database every 5 seconds. To enable this feature, click on "User" / "Preferences" and check the box "Use HeartBeat Monitor to keep database connection open". The monitor sits at the top left of your screen and continually lets you know the delay (in seconds) that it takes a pulse to get from your machine to the database and back again. If the connection is broken, (for example, if the modem disconnects, or you lose your internet connection), the Heartbeat Monitor will try to reconnect to the database. Black Ban --------- * There is now a "Black Ban" button you can press to blackban a client. This marks the client's data in a red box, and warns other users to not grant credit to that client. Reversing Payments ------------------ * Fix problem with Payment Reversals which would not reverse a repayment if there was an associated special charge with the repayment. File Size --------- * Dramatically reduced the size of the Tango32.ADE program. This means it should be quicker to load, and quicker to download from our web site when upgrading. Reference Check --------------- * There is a new "Check References" option on the "User" menu to check all the files that Tango needs to run. Version 1.34 16 February 2001 ***************************** Exporting Direct Debits ----------------------- * Provides a more easy to understand warning if the system doesn't create an export file. Changing Repayment Schedule --------------------------- * The option to change the repayment schedule now works properly. Screen Defaults --------------- * The system correctly remembers to change the defaults for a screen if you blank some items out. Previously, it didn't remember if an item on the screen had a blank default value Version 1.33 15 February 2001 ***************************** Importing Direct Debits ----------------------- * Fixed problem which would not properly import dishonors for accounts that had been previously paid in full, or for accounts where the dishonored payment had also been applied against special charges such as dishonor fees or ODI. * Fixed problem which incorrectly rejected a dishonor because it could not find a repayment of the same value. * The import program will now move any transactions with missing account numbers into the error batch. Previously, it put these transactions in the "valid" batch even though they had no account numbers. * If there are no errors during the import, the system won't show the error report. Previously, it tried to show an empty error report and ended up showing an error message instead. Repayment Schedule ------------------ Fixed formatting problems on this report which caused it to use up extra pages. MS Word Viewer -------------- There is a copy of this free Microsoft program on the Tango web site at http://Tango32.com. If it does not exist on your system, Tango will download it from this Website rather than trying to get it from Microsoft's Web site. Searching --------- If you enter a keyword into the search program, it will first display those matches where the keyword is in the customers name, before showing matches where the keyword is in the customers address. Favourites ---------- There is a new "Favourites" section on the "Help" menu. If you have favourite web sites, or folders on your PC, you can add these to your "Favourites" folder view Internet Explorer, and view these favourites while you're still in Tango32. Version 1.32 13 February 2001 ***************************** Menus ----- The menus are slightly different. There are new FILE and EDIT menus which contain the standard Windows items. When you preview a report, the FILE menu contains all the things you need to change the printer set up, send the output to the printer, or export the data. The Reports/"Printer control" menu allows you to send the contents of a report to a MS-Word or MS-Excel document. There are now separate menu items for Direct Debits and Importing Banking Info. Title Bar --------- The title bar is easier to read. You can now easily see which server, database and user you are logged into. Form Letters ------------ Microsoft advises there is a bug in Word Viewer 97 which prevents it from automatically printing. Tango will accommodate for this problem by automatically uninstalling the buggy version of Word Viewer and then downloading and installing a version of Word Viewer that actually works. If you already have MS-Word 2000 installed, Tango recognizes this and no longer needs to load Word Viewer when processing RTF files. When you print a number of form letters that have previously been queued for printing, Tango will now only start one instance of your word processor to print them. Previously it started a copy of the word processor for every letter you wanted to print. Daily Activity Report --------------------- Now has a separate column for "Fees" Loan Summary Report ------------------- Now works properly if you blank out the FROM and TO account numbers. Now shows total number of loans reported at the bottom of the report. Changing Loan Details --------------------- If you have already entered a loan with a repayment schedule, you can go to the repayments tab and press the "CHANGE REPAYMENT" button to alter the schedule to weekly, fortnightly or monthly. Only the remaining unpaid portion of the loan will be altered. Version 1.31 6 February 2001 **************************** General Ledger -------------- Fixed problem which was showing debits and credits in wrong columns in GL Statements. Wizard ------ Fixed "Invalid use of Null" error when you don't select any check boxes on the final screen of the wizard. Version 1.30 5 February 2001 **************************** Loan Summary Report ------------------- If a loan has a repayment schedule, the earliest scheduled repayment that has not yet been fully paid will show in the "repayment" column of the report. Form Letters ------------ Fixed bug which caused system to crash if you didn't have MS-Word installed on your system. Loan Repayments --------------- Fixed bug which calculated incorrect gross balance when you entered a new loan. New Loan Wizard --------------- When you finish entering a new loan, the system gives you the opportunity to edit the details of the new loan, immediately after it has been created. Fixed bug which caused the system to ignore the value of the "General Purpose 1" field when saving a new loan. Daily Activity -------------- Fixed bug which caused the "Daily Activity Report" to crash with an error stating "Recordset could not be found". Version 1.29 25 January 2001 **************************** Logon ----- You can now tell the system to remember your password when you login. This saves you having to type your password each time you login. Use this option with caution because it means other people will be able to login from your workstation. When the login screen appears, the cursor will go immediately to the password field so you can type in your password. When you press ENTER, the system will process the login request. This makes the login screen similar in function to the Windows login screen. Previously, when you pressed ENTER on the login screen, the cursor would move from one field to the next. You can belong to more than one store or branch. If this is the case, the system asks you to select which branch you want to work with when you login. You can use CTRL-Click to select more than one branch to work with at one time. Direct Debits ------------- Fixed a bug which would not select accounts for direct debits if you specified more than one business code on the prompt screen. You can now create direct debits more easily. There is a new "Direct Debits" menu item which hangs off the "Transactions" menu. The Browse button on the direct debits screen uses the Windows "Save As" dialog box instead of the "File Open" dialog box. This is easier to use when you want to save files. The Summary screen for direct debits is a bit more user friendly. It warns you if you try to post a batch that hasn't been exported yet, or if you try to exit before posting or exporting. You can now post a batch directly from the Direct Debit Summary screen. Loan Repayments --------------- When entering a new loan either via the wizard, or using the Loans form, the system now correctly recalculates the Gross Balance. Version 1.27 13 January 2001 **************************** Wizard ------ Put more meaningful help tips on screens User Preferences ---------------- A new "User" / "Preferences" menu option allows you to specify where you store your help text and form letters, and where you want to look for your updates to Tango32. It also allows you to specify whether or not you want to use MS-Word or MS-Wordview to print your form letters. If you don't have MS-Word, you should specify this in User / Preferences. Form letters ------------ You no longer need MS-Word to print form letters. You can use a free download from Microsoft called MS-Wordview. Tango will automatically download this for you. Form letters should be saved as RTF (Rich text format) files, and formatted using Mailmerge fields (the old version uses Bookmark fieldS). You will still need MS-Word if you want to create your own Form letters. Loans ----- When you change the repayment schedule, the system will ask you if you want to make similar changes to all the other repayments in the schedule. The "Recalculate" button now correctly recalculates Gross Interest when you change repayment details A new "Print Schedule" button allows you to print out a list of all payments due. A new "Enter Transactions" button allows you to jump to the transaction entry screen while you're entering a loan. Receipt Allocation ------------------ You can now search for batch numbers from the Receipt Allocation Prompt Screen. Version 1.25 18 December 2000 ***************************** Loans ----- * You can now view the Gross Balance on the "Balances" tab of the Loan form. * Fixed bug which wouldn't recalculate repayments properly if you changed the purchase price on a new loan. * Fixed bug which showed incorrect repayment amount on customer statements Wizard ------ * When using the wizard to add new loans, you no are forced to key in given names and date of birth. The system will search using any information you supply. Clients ------- * The system now displays a running balance of "Points" scores when adding identification information. Version 1.24 11 December 2000 ***************************** Reports ------- * There is now a "Reports" / "Printer Control" option. Whenever you preview a report, you can use this option to send the output to a printer, or export it to a MS-Word document, spreadsheet or email Menus ----- * The "Client" menu has changed. Instead of Client/Add and Client/Edit, we changed the menu items to Client/Search and Client/Wizard. If you want to look up a client, use the Client/Search option. If you want to add a new client or a new loan, use the Client/Wizard. It will guide you through the steps you need to take to enter a new loan. Loan Repayments --------------- * Fixed some inaccuracies when calculating repayments for weekly or fortnightly loans. In some circumstances the system would under-calculate the required repayments. * You can now specify whether or not a loan's repayments get rounded to the nearest dollar when they're worked out. For example, for a loan with 5 repayments of $20.05, the system would round this to 4 repayments of $20 and one repayment of $20.20. You specify this in the "Setup" / "Business Codes" option. In the Tango internet database, we have set up the system to round to the nearest dollar for PDA loans and to NOT round for LSL (consumer credit) loans. Version 1.23 5 December 2000 **************************** Client Names ------------ * Fixed problem which occured if you entered client names which had apostrophe's in them. Performance ----------- * Sometimes the system would "hang" for long periods of time after you keyed incorrect information in some areas (such as the subledger screen). This has been fixed. (Technical description: Error Handlers within SQL transaction blocks will issue a Rollback when an error occurs so that the transaction block gets closed) Version 1.22 3 December 2000 **************************** General ------- * Removed unnecessary windows which cluttered up the screen. * Fixed problem caused by two workstations with the same name trying to log into the same database. (Technical Description: Changed the unique key constraint on the Workstation table from Workstation Name, to Workstation Name and Serial Number) * Tango Service Pack 1 should be installed before this upgrade. Tango Service Pack 1 -------------------- * Installs additional utilities from Microsoft which Tango32 needs to run. (Technical description: MSCOMCTL.OCX which is required for the ProgressBar control. Without this OCX installed, the "Check for new version" option does not work, but crashes with a message "object or class does not support the set of events") If you don't install this service pack, you won't be able to download and install new versions of Tango32 Version 1.21 2 December 2000 **************************** Security -------- * Fixed bug which forced you to enter your name and password twice * The system now returns more meaningful error messages if you make a mistake while logging in * Database upgrade files are now delivered in a more secure "TGO" format instead of "SQL" format in order to preserve the integrity of the upgrade. * Fixed bug which added extra bytes to the end of the upgrade program when you downloaded it. Client / Edit ------------- * If you key in a loan number, the system will go straight to the details of the loan, rather than forcing you to display the client details first. Client / New ------------ * Fixed "Type mismatch" bug when entering a new organization Subledgers ---------- * Fixed error which occurred while trying to delete a subledger * Fixed minor spelling errors * The sequence number defaults to 10. The system prevents you from entering a blank sequence number. Version 1.17 26 October 2000 **************************** Delinquency System ------------------ * Fixed #Name? eror at the bottom of Delinquency Reports * Fixed page formatting problem * Fixed error which occurred if one report in a series of reports contained no data. If one report contained no data, none of the reports would print. * Modified logic to remove the need for an underlying temporary view to print the report. Script Processor ---------------- * Fixed minor problem with script processor which caused system to insert blank lines at the start of scripts. System Parameters ----------------- * You can now enter a Country as part of the system shipping and postal addresses. Arrears Adjustments ------------------- * Modified system routines to take into account arrears adjustments (and the date they were entered) when calculating arrears balance, next due dates, and amounts due.