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