Monday, December 10, 2018

Search for Checks or Bill payments that were used to pay multiple Bills

To search for Bill Payments or Checks that were used to pay multiple bills:

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

2. Under Criteria Tab > Standard subtab > add the following filters:

Type: is Bill Payment.

Formula (Text): Formula: {tranid} > is not empty.

Account : is any of the AP GL accounts

3. Under Results Tab > Columns subtab > add the following fields and corresponding Summary Type:

Field: Date ; Summary Type : Group

Field: Name ; Summary Type: Group

Field: Number; Summary Type: Group

Field: Applied to Transaction; Summary Type: Count

Field: Applied to Transaction; Summary Type: Null/Blank

4. Go back to Criteria Tab > Summary subtab > add the following filter:

Summary Type: Count

Field: Applied to Transaction

Description: is greater than 1.

5. Click Preview button or rename the Search and click Save & Run button.

No comments:

Post a Comment