Share
ReportI'd like to see the value of my inventory but have it sorted by the last date the inventory was used (sold or adjusted)
Any help would be appreciated!
*This post is locked for comments
You’re offline. This is a read only version of the page.
I'd like to see the value of my inventory but have it sorted by the last date the inventory was used (sold or adjusted)
Any help would be appreciated!
*This post is locked for comments
Hi Eric
You can try this query
SELECT DISTINCT InvtID, TranType, MAX(TranDate) AS date, UnitPrice
FROM dbo.INTran
GROUP BY InvtID, TranType, UnitPrice
HAVING (TranType = 'cg')
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (