Report to Show Bills Paid via Electronic Payments.

When paying Entities (VendorsEmployeesCustomers) using EFT Bill Payment, there is no feature right now to extract the Bills paid via the Payment File Administration record.

To get a list of the Bills paid per PFA, you may use the following saved search setup and export the results for further reconciling:

 1. Navigate to Lists > Search > Saved Searches > New > Transaction
 2. Under the Criteria tab, set the following filters:

  • Type = is Bill Payment
  • Document Number/ID = has keywords (enter the PFA number *complete with all the zeros)
  • Main Line = is true

3. Over at the Results tab, you may set any other field, but for confirmation, have the following show on the results:

  • Document Number
  • Name
  • Applied to Transaction
  • Applied to Transaction : Amount

 4. Provide a search name
 5. Click Save & Run

Leave a comment

Your email address will not be published. Required fields are marked *