Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A sales applicant’s fixed rate mortgage expiry date can be stored on their applicant record and then reported on - this provides opportunities for mortgage service referrals based on when the renewal is required

Tip

This update (available from version 12.156+) allows the fixed rate mortgage expiry date to be entered

From version 12.157+, the mortgage offer expiry date can be entered in the sales progress screen, as outlined here: Store mortgage offer expiry date

1. Add mortgage expiry date

From sales applicant:

  • Click link beside Status to view Applicant Status screen

  • Enter date in Mortgage Expiry Date field

  • Click cross to exit Applicant Status screen

  • Save applicant record

Image Removed
Image Added

2. Reporting

From Reports on main menu:

  • Click Power Reports

  • Select Applicant Report for Sales then click Show more

  • A Mortgage Expiry option is available

Image Modified

3. Example report

For example, this report will return active sales applicants from the logged in user’s office with a mortgage due to expire in the next 3 months

Image Modified

4. View mortgage expiry information in results grid

The mortgage expiry date can be shown in the report results grid - but first needs to be added and saved to the grid

first

, as follows:

  • Right-click over the column headings, click Pick columns, select More, tick Mortgage Expiry, then click Accept

  • The new column will be added to the far right side of the grid - click and drag the column heading to the desired position

  • Right-click over the column headings again and click Save grid layout

Image Modified
  • Grid functions can be used to sort or filter the report results by mortgage expiry

    • To sort the list, click the column heading

    • To filter, click to the right of the column heading (to view filter icon - shown above) and enter dates to filter by

Filter by label (Content by label)
showLabelsfalse
max8
sortmodified
showSpacefalse
reversetrue
cqllabel = "applicant"

...