350
Hi All,
I am writing a report where I need Latest Unit COST and UNIT PRICE at each LOCATION.
Below is the script I am using but
How do I restrict to get latest data (ReqShipDate ) for each Location.
SELECT ITEMNMBR,
LOCNCODE,
UNITCOST,
UNITPRCE,
ReqShipDate
FROM SOP30300
where ITEMNMBR = '19'
ORDER BY ReqShipDate DESC
*This post is locked for comments
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (