Amortization Schedule Saved Search> Show the Most Recent Journal's Posting Period
I have an amortization schedule saved search that I want to show me just the most recent journal's posting period. So, I used summary type = Minimum on the results column = Journal: Period. This seems to be working on some of my result lines but not all.
If I used the Journal: Date field summarised to show = Maximum I get the correct date for each amortization schedule but the Journal: Period remains wrong (mostly observed to be the previous period from the most recent.
Does anyone know how I can fix this as I am sure I am using the correct summary type (Minimum)? I attached a screenshot of the Journal: