A/R Aging Saved Search - Partially Applied Credit Memo

1. Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Select Transaction.
3. On the Criteria tab > Standard subtab, add the following Filters:

             - Account Type is any of Accounts Receivable
             - Status is none of Invoice: Paid in Full , Invoice: Pending Approval
            - Amount Remaining is not equal to 0.00

4. On the Results tab > Columns subtab > click the Remove All button and then add the following Fields:

           - Name |Summary Type = Group
           - Type
           - Date
           - Document Number
           - Due Date/Receive
           - Days Open 
           - Amount Remaining |Summary Type = Sum
           - Formula (Currency) |Summary Type = Sum: |Formula = CASE WHEN {type} IN ('Credit Memo') THEN -{amountremaining} ELSE {amount} END "

5. Rename theSearch Title.
6. ClickSave & Run.