You’re offline. This is a read only version of the page.
Hi all, how can i get the latest invoice per customer in soshipheader??
thanks
*This post is locked for comments
I have the same question (0)
If you want the most recent invoice number for each customer the following should work:
select custid,max(invcnbr) from soshipheader group by custid
If you want the most recent invoice date it can be a bit tricky because you could have more than one invoice on the same date so the following could return more than one invoice per customer
select custid,max(invcdate) from soshipheader group by custid
Share
Report
All responses (
Answers (
