Saturday, April 27, 2019

Search to show all Paid in Full Invoices and the associated Payments and Credit Memos

1.   Navigate to Lists > Search > Saved Searches > New
2.   Select Transaction
3.  Criteria tab > Standard sub tab:

Type : is Invoice
Status: is Invoice : Paid in Full
Main Line: is True
Applying Link Type : is Payment

4.  Results tab > Columns sub tab:

Date > Summary Type = Group
Number > Summary Type = Group
Amount > Summary Type = Sum
Applying Transaction > Summary Type = Group
Applying Link Amount > Summary Type = Sum

5.  Rename Saved Search Title

6. Click Save & Run

NOTE: : In the saved search results, Applying Transaction column may include Payment, Credit Memo, Journal and Deposit Application.

No comments:

Post a Comment