This solution details the enhancements made to the January 2021 version of Chintaro. The changes in this release are for the SQL version only.


Chintaro SQL Enhancements


Chintaro Insights

The January 2021 release of Chintaro includes Chintaro Insights, the web-based Business Intelligence platform that uses your Chintaro data to present an overall view of your business, and allows you to analyse, or "drill-down" into, the data that is used to calculate your performance indicators. For more information about Chintaro Insights, click this link: Chintaro Insights Explained


Client Enhancements:

  • Client DOB invalid warning message: Previously, Chintaro would allow an invalid date of birth to be entered (EG in year 2088 or 1679). Message now appears warning you to change as it will affect reporting:
  • 'Time Spent' added to Manage Client Notes: Previously removed, this column has been added back to the Manage Client Notes screen
  • 'Created By' added to Manage Client Notes: This column is exported as 'Note Originator' in the screen export from the Manage Client Notes screen
  • Rent Calculator Enhancements: Users now have the ability to; edit the Market Rent used in the Rent Calculation, record the amount of Service Fee and track the amount of rent that is subsidised.


Tenancy Enhancements:

  • Added the option to give NonRent priority in splits to SQL: The Access version of Chintaro has the ability to set a NonRent priority so that splits will occur even if rent is not fully covered by the amount of the payment. This has been added to the SQL version of Chintaro
  • Current Rent Field added to the Manage Tenancy screen:  The Current Rent rate is selected by today's date  
  • Payment Cycle Field added to the Manage Tenancy screen: Weekly or Fortnightly payment from the Tenancy> Payment Arrangements screen
  • Last Payment Detail Fields added to the Tenancy Balances screen: Last Payment Date, Last Payment Amount, and Last Payment type. These columns display the details of the last Rent payment type.
  • New field added on the Tenancy> Lease Details screen - Tenancy: Displays the tenant's surname and first name.
  • Tenancy SMS screen: City field added
  • Generate rent reversal function: Rent cannot be reversed if it has been exported to General Ledger

Waiting List Enhancements:

  • Manage Waiting List Screen: Current Housing Type field added to the Manage Waiting List screen. The Access version of Chintaro has the ability to set a NonRent priority so that splits will occur even if rent is not fully covered by the amount of the payment. This has been added to the SQL version of Chintaro


Finance Enhancements:

  • Performance Improvement to Tenancy Bond screen: Sped up the opening of the Tenancy Bond screen in Finance and improved the performance of filtering when in the screen. Finance > Manage Bonds
  • Improved logic for matching Payment Book ID in middle of string for NAB Bask Import: Now able to match on a code with 5 digits (3 letters and 2 numbers with no space) anywhere in the description string.
  • New file format for ANZ BPAY: New format was added to recognise BPAY files for importing.
  • Adjustment to GL Export format: Added the Property address in the export
  • Tenancy transactions calculate GST:  GST is now calculated from the transaction amount when the transaction type is ticked for GST in the reference table: System Maintenance> Reference Tables> Transaction Type> GST?
  • Property transactions calculate GST:  GST is now calculated from the transaction amount when the transaction type is ticked for GST in the reference table: System Maintenance> Reference Tables> Transaction Type Property> GST?

Property Enhancements:

  • Inactive Inventory Items removed from Property > Inventory screen: Only Active Inventory Items will appear on the Property screen by default, but can be viewed by unticking 'Active' column filter. Properties > Manage Properties > Inventory.
  • 'Age of ceiling insulation' changed to 'Age of underfloor insulation': Under the Insulation section for underfloor, 'ceiling' was referenced incorrectly. Property > Insulation > Underfloor insulation
  • New field: Oven Type added to the Property Screen with the property Services fields:

  • New field on Inventory Items screen: Estimated Amount
  • Property screen> Keys screen: Comments Field added to columns displayed on the list of keys. 
  • New column added to Manage Properties Screen: 'Last Inspection Date' added. Properties > Manage Properties



Reports and Exports Enhancements:

  • Centrepay Codes Updated in Centrepay Changes Report: Report now shows updated Centrepay Codes. Reports and Exports > Reports > Finance > Centrepay Changes
  • Performance Optimisation in Transaction inc Bond Report: Report now runs faster. Reports and Exports > Reports > Finance > Transaction Summary including Bond (Date Range)
  • New Field Added to Tenancy Balances by Txn Group As At Date Export: Export now includes 'Program' field. Reports and Exports > Exports > Tenancies > Tenancy Balances by Txn Group
  • New Field Added to Forecast Maintenance Detail Export: Export now includes 'OrderNumber' field. Reports and Exports > Exports > Property & Maintenance > Forecast Maintenance Detail
  • New field 'Vacant?' added to the NRS reporting: The 'Vacant' tickbox from the maintenance task screen is added to the NRS 2.2 screens Reports and Exports> Statutory Reporting Analyser> NRS> 2> 2.2
  • HPF Maintenance Report (VIC reports): Now excludes Maintenance Tasks with the order status of Cancelled. See more details in this article:  How to cancel a Maintenance Task Reports and Exports> VIC reports> HPF Maintenance Reporting


Maintenance Enhancements:

  • Increased Functionality for Maintenance Reference Tables: Maintenance Type now appears in Item Type Reference table, Item Group included in Works Type Reference Table
  • Improved Data Checking for Program Names: Program names with apostrophes cause errors when scheduling inspections. Apostrophes will be removed and cannot be saved in new Program names.
  • Added additional information for deleted Maintenance Tasks on the Audit screen: Added the Property Name and Work Order Number to the Audit screen when a Maintenance Task is deleted 
  • 'Property Status' added to the Manage Maintenance screen: Column that shows if the property is Occupied (green), Partially Occupied (Orange), or Vacant (red)
  • 'Vacant' tickbox added to the Maintenance Task screen: This box may be ticked on Maintenance Tasks when a property is vacant.
  • New column 'Vacant' added to the Manage Maintenance Tasks screen: This column displays the 'Vacant' field on the Maintenance Task records.
  • Incomplete Maintenance Tasks on the Home screen show the number of vacant properties separately: The count of vacant tasks is based on the Vacant tickbox on the Maintenance Task screen. 


Complaints Enhancements:

  • Complainant field added: Now able to record who the individual raising the complaint was


Views Enhancements:

  • Ability to delete Global views: Users can now delete Global Views. System Maintenance > Manage Saved Views 


Word Merge Enhancements:

  • Word Merge Plus: New features for Word Merge throughout Chintaro that provides users with increased word merge functionality. Click this link to learn more about Using Word Merge Plus in Chintaro

  • Tenancy Word Merge: New field for Smoke Detector Last Checked - SmokeDetectorLastChe - added
  • Tenancy Word Merge: New field for the Rent Balance - RentBalanceAsAtToday - added
  • Tenancy Word Merge: New fields for Owner details - Owner, Owner_Address, Owner_City, Owner_PostCode, Owner_State, Owner_Phone  - added
  • Tenancy Word Merge: New field for Support Agency - SupportAgencies - added
  • Tenancy Word Merge: New field for date rent is paid to - RentPaidTo - added
  • Tenancy Word Merge: New field for vacating date - EndDate - added
  • Tenancy Word Merge: New field for date of the last rent payment - LastPaymentDate - added
  • Tenancy Invoice and Receipt Word Merge: New fields for calculated GST and exGST - calcGSTAmount, calcExGSTAmount, calcGSTAmountNZ, calcExGSTAmountNZ
  • Property Word Merge: New field for OwnerContact1Phone - added
  • Property Word Merge: New field for OwnerContact1Email - added
  • Property Word Merge: New field for OwnerBankName - added
  • Property Word Merge: New field for OwnerBSB - added
  • Property Word Merge: New field for OwnerAccountNum - added
  • Property Word Merge: New field for OwnerAccountName- added


SMS Enhancements:

  • Added functionality to use SMS Global new API: The update process will update the database parameter SMSGateway to the new site https://api.smsglobal.com/http-api.php? for Chintaro databases that are configured for SMS Global SMS service. System Maintenance > Reference tables> SMSGateway 




Bug Fixes:

  • Statutory Reporting Analyser - total at the top of the screen missing - fixed.
  • Statutory Reporting Analyser  - sped up screen and fixed #Deleted on NAHA Tenancies tab.
  • Statutory Reporting Analyser - VRS KPM 9.1 Syntax Error - fixed.
  • Statutory Reporting Analyser - NRS 6.9, 6.1.12 logic error - fixed.
  • Statutory Reporting Analyser - NRS 1.2.3, 6.1.6 were not matching - fixed.
  • Bank Processing Screens - unable to select *Not A Rent Payment
  • Market Rent Review screen - Error - fixed.
  • ODBC error on login - caused by dodgy dates of birth in Client records - fixed.
  • Joint Tenant not appearing on Bulk Email Statement - fixed.
  • Bank Format BNZ CSV Salvo treating some credits as debits - fixed.
  • Error #91 when cloning an Inventory Item to one Property only - fixed.
  • Unable to Add/Edit Trades Types when creating new Tradesperson - fixed.
  • New Maintenance Task > add Tradesperson > click Tradesperson Details > error - fixed.
  • FHL Occupancy Export - Error - fixed.
  • Opening Notes - Error - fixed.
  • Adding a client - Error - fixed
  • Error #440 when adding a Client Note - fixed.
  • Unable to tick 'Include' box on the Manage Inventory Items - fixed.
  • Fixed Rent and Banking screens to allow use of Enter key - fixed.
  • Fixed Trade Type filtering on existing WOs - fixed.
  • Rent Report Launch Export - Error - Fixed.
  • Waiting List - Write conflict error in some circumstances - Fixed
  • System freezes when clicking 'Print Note History' for certain Tenants - Fixed
  • Error #2110 appears when opening a Room after setting security on fRoomDetails - Fixed 
  • A random balance is shown on the Ledger when a new Tenancy is created - Fixed 
  • ArrearsRent Parameter set to 2 is ignored when Rent is generated - Fixed 
  • Add maintenance task - email button not showing in some circumstances - Fixed
  • Message defaults getting cut off in notes if over 255 characters - Fixed


Patch Update 2021.02.05


Bug Fixes: 

  • Client Notes - Search field not displaying correctly - Fixed
  • Message Default - Character limit preventing use of longer messages - Fixed
  • BNZ CSV Bank Format - Issue with debits not appearing correctly - Fixed
  • Insights Export - Performance issue with Export process - Fixed