How to Create and View a Custom Report Using The Extended Lookup Feature

Creating Custom Reports

1. From the WIP, click the Lookup Button.
2. Then select the Extended Button.
3. The "Search Field Setup" window populates. See below.

"Available Display Fields" on the upper left which show the field's that will display on the report.
"Available Search Fields" on the lower left are "filters' which will only show the returns that match the search parameters entered. 
      This will restrict data from populating.

For an illustrated example, see below a created report which shows display fields.

• Taxpayer's Last Name
• Taxpayer's First Name
• SSN
• Cell Phone
• IRS ACK Code
• Date
• Refund Amount.
  

  

Optionally, by selecting the IRS ACK Code in "Available Search Fields," the search results can be narrowed to returns only matching a particular value.
In the example below,  

• "A-Accepted" has been selected, which will limit the report to only showing the returns that have been Acknowledged. 
  

  

Once satisfied with the custom report, it is recommended to save.

1. Click Save
2. Name the report
3. Select OK to save the report
4. Afterward, click OK to run the report.
   

   

The results of the report can be: 

1. Printed by using the F8 button.
2. Exported and save to Excel spreadsheet.
3. Send Mass Text.
   Custom reports can be used to send texts to all of the resulting taxpayers as long as a Cell Phone and Carrier was entered on the Client Data.
   

Article ID: 281
Created: Tue, Aug 16, 2016
Last Updated: Thu, Mar 16, 2023

Online URL: //kb.erosupport.com/article-281.html