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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (