Electronic Payments: Create a Bill Payment Search that has the Payment File Administration ID

1. Navigate to Lists>Search>Saved Searches>New>Transaction.

2. Under the Criteria tab:

--Type=Bill Payment
--Main Line=T

***Users can add a temporary Criteria Field to limit the results for testing purposes. You can use:

-- Formula (Text)

Where the Formula={memomain} starts with "00000"

3.Under the Results tab
--Name
--Number
--Formula (Text)
where Formula= SUBSTR({memo}, 0, INSTR({memo}, '/', 1) - 1) ...... Summary Type=Group..........Custom Label =Payment File ID
--Date Created..............Summary Type=Maximum
--Period....................Summary Type=Group
--Amount....................Summary Type=Sum......Function=Absolute Value.........Custom Label=Total Amount Paid

4. Enter a Search Title and click Save & Run.

Note: The Results should show the Payment File ID same as what users see under Payments>Payments Processing>Payment File Administration list.