Monday, November 5, 2018

Saved Search to display the Unapplied Amount of Payment Transaction

1. Navigate to Lists > Search > Saved Searches > New
-Click on the Transactions link

2. On the Criteria tab> Standard sub tab> select the following:
-- Main Line is false
-- Type is Payment

3. On the Results tab > Columns sub tab> Enter the following:
Fields    | Function
-- Date 
-- Period   
-- Number
-- Name
-- Amount | Absolute Value
-- Amount Remaining
-- Amount Paid

4. Enter Search Title and click Save & Run button

4 comments:

  1. This returned results for all payments, not just those with amounts remaining. Not sure what I missed on the set up, but I followed your criteria.

    ReplyDelete
  2. This returned results for all payments, not just those with amounts remaining. Not sure what I missed on the set up, but I followed your criteria.

    ReplyDelete
    Replies
    1. Add in the filter Amount Remaining - is grater than 0.00

      Delete