@samyt Wouldnt you just do a transaction search of type Payment with maximum of date.