Epic Report Instructions

How to create your Client List and Policy List reports in Epic for integration with Fuse

This guide will walk you through setting up your Client List and Policy List reports in Applied Epic for seamless integration with Agency Revolution Fuse. The process involves one-time setup instructions and ongoing integration tasks.

In this article, we will be covering:

One-Time Setup Instructions

Ongoing Integration Tasks

One-time Setup Instructions

Creating the Policy List Report in Epic

1. In Epic, go to "Reports & Marketing" and click "Policy" 

2. Right-click "Policy List Report" and select "Create New Report"  [example]  

3. On the "Create New Report" window:
   • Name the report: “AR Policy List Report”
   • Create in... > “My Reports”
   • Click "Finish"  
   • [example]

4. On the "Report Criteria" window, select “All,” “Both” or "Each Time Found" for every available criteria except:
   • For the "Policy Status" criteria, exclude "HIS" status.
   • For the Parameter Page criteria, exclude the Parameter Page.

5. When finished with Criteria, click “Layouts”  [example] 

6. On the "Layouts" window:
   • Click the Paper icon to add a new layout
   • In the pop-up "Add Layout" window, enter the Name: "AR Policy List Report"  
   • Click "Finish" - [example] 

7. On the "Output Builder" screen:
   • Right-click and delete the "Layout Header/Footer" and the "Page Header/Footer" from the Layout (do not delete the "Details" section).  [example]

8. Under the "Data" column on the left side of the screen, all available fields will be found organized into a folder system. Navigate through these folders to find and add the necessary fields. When you find a field, double-click to add it to the Layout. It may appear as if the fields are being added in a haphazard, overlapping manner. This is normal and expected. Please feel free to leave them that way.  It does not matter what order the fields are in, as long as no required field is missing.
   ​
   ​Click here for supported Policy List Fields
   ​

9. After adding all required fields to the Layout, click "Save All" [example]  and close the "Output Builder" window. 

10. Back on the Layouts list, delete all layouts except for the new "AR Policy List Report" layout you just created.

11. Under "My Reports" (left menu bar) Click "Delivery Options" to get the "Report Recipients" window.  Select the default report recipient and click the Pencil icon to edit it  [example]

12. In the popup "Delivery Options" window, you will choose whether to have the report (A) auto-saved to a location on your computer or (B) emailed to you. The choice is yours:
    ​OPTION (A) - Have the report auto-save to your computer:
    • Make sure "Printer" is blank
    • Select “Save to Disk”
    • Save as Microsoft Excel Workbook
    • For "Location": click the magnifying glass to select a folder on your computer where the report will be saved
    • Click "Finish"
    ​OPTION (B) - Get the report emailed to you:
    • Make sure "Printer" is blank
    • In the "Email" field, enter an email recipient
    • Attach as Microsoft Excel Workbook
    • Click "Finish"
    • Enter a Subject for the email (The subject field is in the middle of the screen)

13. Make sure "Now" is checked on the right side of the screen (not "Schedule") and Click "Actions" > "Generate Report" [example]

14. Close the "Reports/Marketing" window 

15. When finished, your report will be found in the folder location or email inbox you selected above.

16. After your first successful integration, return to the "Delivery Options" for this report, change the checkbox on the right side of the screen from "Now" to "Schedule," and schedule the report to run daily at a time that works for you. Then click "Actions" > "Generate Report" to set the schedule.

Ongoing Integration Tasks

Running Your Epic Reports

If you've set up your reports to be automatically saved to a file or emailed to you every day, you don't need to do anything else.  Simply locate the reports each day in the designated location and upload them to Fuse.

Uploading Your Reports to Fuse

1. Log into Fuse and navigate to your List Setup Page.

2. Upload your Client List Report and Policy List Report into the respective pop-up windows.