Tuesday, January 15, 2019

Create a report that will capture all vendor bill payments made via ACH.

1. Navigate to Reports > Vendors/Payables > A/P Payment History by Payment > Customize.
2. Enter a Name for the saved report (i.e. ACH Bill Payments)
3. In the Edit Columns page, under the Report Preview section, highlight the Transaction column and hit Remove Column.
4. In the Search Fields section, open the Bills By Payment folder then open the Entity sub-folder and click Name.
5.  Navigate  to the Report Preview section and move the Name column field to the left most part of the report.
6.  Navigate  to the Filters page then under the Search Fields section, open the Bills By Payment folder then open the Transaction Type sub-folder and click Long Name.
7. Under the Filters section, search for Long Name and select the first one in the list then set it to Bill Payment.
8. Still in the Filters section, open the Transaction Dimension folder then click Transaction Number.
9.  Navigate  to the Choose Filters section, filter the Transaction Number contains To ACH.
10. Click Preview or Save.

Note: It is not yet possible to create a transaction saved search to capture all vendor bill payments made via ACH because the To ACH box was not yet available via saved search.  See Enhancement 161121.

No comments:

Post a Comment