FL Sales Letters

Purpose

User will print Buyer and Seller letters using the PACS Application. Sales letters may be printed individually at the property level, but also in Mass using sale date ranges.

Procedure

• Navigate to PACS Application button, then choose Activities>Letter Processing > Sales Letters

• System renders a Print Sales Letter Dialog

• Select the option to Print Grantee or Grantor Letter then select the appropriate Letter. User will have the four letters listed:
  • MH Buyer Letter
  • Sales Verification Letter
  • Citrus Sale Letter
  • Ag Sale Letter
• Create System Event – if this is checked, system will create event and letter object in the Event Panel at the Property Level
• Selection Criteria
  • Criteria
    • Deed Date Range – Enter range of dates for Deed Date
    • Sale Date Range – Enter range of dates for Sale Date
    • Record Date Range – enter range of dates for Record Date
    • Deed Type – user may narrow criteria by selecting specific Deed Types, Sale Types, Sales Qualification Codes, Property Types, Tax Areas, or Primary Use Codes. These may be used individually or in conjunction with each other.
  • Query – Queries may be used to select properties. Examples of queries are below. If you need assistance with queries, please call support.

Examples of Queries

–citrus sale query

select chg_of_owner_id as chg_of_owner_id

from hendry_sales_letter_vw

where entered_date >= ’12/01/2015′ and entered_date < ’01/01/2016′

and dor_qualify_code in (’01’, ’05’, ’99’)

and primary_use = ‘6600’

–mobile home sale query

select chg_of_owner_id as chg_of_owner_id

from hendry_sales_letter_vw

where entered_date >= ’12/01/2015′ and entered_date < ’01/01/2016′

and dor_qualify_code in (’01’, ’05’, ’99’)

and primary_use = ‘0200’

–sale verification query

select chg_of_owner_id as chg_of_owner_id

from hendry_sales_letter_vw

where entered_date >= ’12/01/2015′ and entered_date < ’01/01/2016′

and dor_qualify_code in (’01’, ’05’, ’99’)

and (primary_use between ‘0000’ and ‘0100’

or primary_use between ‘0300’ and ‘4900’

or primary_use between ‘7000’ and ‘9999’)

• Sale ID – input sale ids with carriage return

• Exclude Sales with the following Grantee/Grantor Letters – User may select letter; if PACS sees this letter currently exists on the property, it will exclude the sale from the print run.
• Click Print