Author Topic: The "First Written" field in Transaction Searches  (Read 335 times)

0 Members and 1 Guest are viewing this topic.

Offline Jeff Zylstra

  • ScurvyDawg
  • *******
  • Posts: 5058
  • Karma: +557/-2
The "First Written" field in Transaction Searches
« on: May 11, 2018, 10:04:31 am »
I'm trying to group policies by the "first written" date that shows in the invoice template for each policy screen, but nowhere I can find in the report data fields.  I'm using the Search - Transactions to pump out raw data to Excel for each invoiced item, but I can't seem to add the "first written" field as data in the output.  Any ideas on how to get that to show?
"We hang the petty thieves, and appoint the great ones to public office"  -  Aesop

Offline Jan Regnier

  • Scalliwag
  • ******
  • Posts: 3930
  • Karma: +473/-4
  • Users Helping Users
    • Regnier Insurance Services
Re: The "First Written" field in Transaction Searches
« Reply #1 on: May 11, 2018, 10:37:38 am »
Jeff - if you go to Policy Data (Data File Choices) on that report Date First Written is there....to select to put in "fields selected"....does that work for what you are trying to do?
Jan Regnier
Regnier Insurance Services, Highland, IN 6 Users
TAM V2017 HF3, MS 2012 R2 Server, Windows 10 PRO WS; MSOffice 2016

Offline Jeff Zylstra

  • ScurvyDawg
  • *******
  • Posts: 5058
  • Karma: +557/-2
Re: The "First Written" field in Transaction Searches
« Reply #2 on: May 14, 2018, 11:19:38 am »
Doh!  Apparently I couldn't see the forest through the trees.   Making it much harder than it had to be.  Thanks, Jan! 
"We hang the petty thieves, and appoint the great ones to public office"  -  Aesop