Hi,
I am trying to list all historical sales orders with certain criteria but only the last version of each. How do I get Jet to give me only the last version?
Thanks
Pat
Date
Votes
1 comment
-
Jet Reports Historic Posts It may be helpful to review this KB article - http://kb.jetreports.com/article/AA-00779
You can pull a last or first of a list of items but you need to apply a sort to it. So if, for example, you wanted to find the most recent posting of document from a customer, you would either use NL(Last) with a descending sort to a posting date or an NL(First) with an accending sort to the posting date.
If you post your Jet function, we may be able to get it set up properly if you need help.
Please sign in to leave a comment.