Saved Search to Show Transactions associated to Fixed Asset accounts with the Date When Bill is Paid In Full

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

2. Select Transaction

3.  Criteria tab:

Account Type : is Fixed Assets

Posting : is True

4.  Results tab:

Date > Summary Type = Group

Period > Summary Type = Group

Type > Summary Type = Group

Number > Summary Type = Group

Vendor: Name > Summary Type = Group

Account > Summary Type = Group

Amount > Summary Type = Sum

Formula (Text) > Summary Type = Maximum > Formula = CASE WHEN {type}='Bill' AND {systemnotes.newvalue} LIKE 'Paid In Full' THEN {systemnotes.date}END > When Ordered By Field = System Notes: Date

4.  Click Save & Run