RE: How to list only most recent record of similar multiple records?

I have a saved search returning multiple records, for example,

  • Purchased seminar A on 1 Jan 2020
  • Purchased seminar A on 1 Jan 2021
  • Purchased seminar A on 1 Jan 2022

In my results I only need to see the 2022 record, the most recent.

Is it possible to institute something like,
IF seminar A > 1 list in results only the latest one?

Thank You!

StephenO Rookie Asked on May 18, 2022 in Saved Searches.
Add Comment
3 Answers

Hi Stephen,

To get the Purchase by Item Detail report:
Go to Reports > Purchases > Purchase by Item > Detail.

In that report you can filter the PO by using the period filer.

Beginner Answered on February 7, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.