Transaction Detail Report Instructions
Locate and Duplicate Canned Report:
-
From the Epic home screen, click “Reports/Marketing” in the left navigation panel.
-
Select “Transaction” (hover over and left click once to display the default/canned reports
-
Highlight “Production Report – Modified”
-
Copy report - Click “Actions,” choose “copy report to” a separate window will open
-
In the Copy Report window:
-
Check the box for “My Reports”
-
Name the report: “ProfitLens Production”
-
Add custom note in comment box if desired
-
Click Finish
Configure the Criteria
-
Navigate to “My Reports” on the left menu, find your “ProfitLens Production” and click the Edit Pencil (or double-click) to open the Criteria page
-
Set all core criteria filters to ALL*, except for the following sections which require specific manual configurations:
-
Accounting Month – select “Range,” uncheck the open boxes, input your From and To dates for a 12 month move
-
Bill Mode – select Both
-
Transaction Class - (see below with screenshot)
-
Select Include for each of these categories: Adjustments, Financed Transactions, Installments, Parameter Page
*These filters should be set to ALL: Region, Agency, Branch, Department, Profit Center, Production Month, Effective Date, Transaction Issuing Company, Transaction Premium Payable Company, Transaction Premium Payable Broker, Type of Business, Policy Type, Line Type, Transaction Commissionable Broker, Transaction Producer, Account Agency Defined Options
How to Configure Transaction Classes & Exclude CFIN
-
Transaction Class - Move ONLY these three codes into the Selected panel:
-
ACUR
-
DBIL
-
FEES
2. Excluding CFIN Transactions: Selecting the three classes above automatically forces Epic to pull CFIN transactions into your data. To remove CFIN data from your report, add a specific exclusion filter using these steps:
-
Locate the Modify Criteria section at the bottom of the page and click the + (Plus Sign) to create a new custom criteria row
-
In the folder selection window that appears, double-click the Production Report folder
-
Double-click the Transaction subfolder, then highlight and select Transaction Code
-
Look back at your main criteria list where this new row has been added. Change Equals to Exclude
-
Select the CFIN code to complete the exclusion
Modify Layout and Expand the Details Box
-
Click “Layouts” in the far-left column. Check the Print box only for Complete Detail (or Transaction Detail depending on your system). Uncheck all other layouts
-
Highlight “Complete Detail” and click the Edit Pencil (or double-click)
-
Resize Details Bar: Click the blue Details bar (it will turn green). Hover over the bottom center white box and drag it down to maximize the workspace.
-
In the details section, locate both “Account Lookup” and the “Effective Date” fields along the top line in the section, right click, and select delete. (see screenshot below)
Drag & Drop Custom Fields
To build your custom layout, you will use the Folder Path column in the table below to find specific fields, then add them to your report layout workspace
Follow these steps for each row in the table:
-
Locate the Folder: Look at the Folder Path column. Start at the Main Folder (Labeled Production Report). If arrow(s) are shown, double-click each subfolder in order to open it
-
Add Your Fields: In the Target Fields column, find the listed items. You can add them using either method below. (Note: It does not matter where you place these additional fields, as long as they land inside the Details box!)
-
The Double-Click Shortcut (Fastest): Ensure the Details bar is highlighted green (active). Then, simply double-click the target field to automatically send it to the Details section
-
The Drag & Drop Method: Click, hold your mouse down on the target field, and manually drag it over into your green Details workspace box
-
To Navigate back to any folder click the Back Arrow
|
Folder Path |
Target Fields to Drag & Drop |
|
Main Folder > Servicing Roles > Primary Account Manager |
1. Name |
|
Main Folder > Policy |
2. Account Name 4. Policy Effective Date |
|
Main Folder > Billed To > Main Business Contact > Main Business Contact Info |
6. Main Bus. Contact Primary Number |
|
Main Folder > Billed To > Main Business Contact > Main Business Contact Address |
7. Main Bus. Contact Address Line 1 |
|
Main Folder > Commission |
11. Premium Payable Name |
|
Main Folder > Commission > Producer Broker |
17. Production Credit (%) |
|
Main Folder > Commission > First Producer |
20. Producer Name |
|
Main Folder > Transaction |
21. Invoice Number |
3. In the upper left corner, select “File” and click “Save All.” You will not get any message confirming saved. Once it allows you to click File again, click “Exit.”
You will be returned to the Layout list.
Set Delivery Options & Generate
-
Click on Delivery Options in the left navigation panel, then click the edit pencil
-
When the “Edit Recipient” box opens:
-
Delete “local default printer” from the Printer box
-
Click the box for “Save to Disk”
-
Set the “Save As” box to “Microsoft Excel Workbook”
-
Click the magnifying glass icon next to “Location” and select where you want the report to save when generated. Enter the file name (ex. Your Agency Name Production MM YY), Click save
3. Click “Finish” on the Edit Recipient screen
4. Click Save on the top toolbar
5. Generate the Report - On the top toolbar click “Actions,” then click “Generate Report.”
6. Confirm your file location and ensure the type reads *.xlsx before clicking the final Save
Your report is now ready to submit.
Email report to [email protected]
