Share
ReportIs there a smart list that will show QOH with serial number\Lot numbers??
*This post is locked for comments
You’re offline. This is a read only version of the page.
5,080
Is there a smart list that will show QOH with serial number\Lot numbers??
*This post is locked for comments
Here's a select statement you could turn into a view for SLB.
SELECT RTRIM(A.ITEMNMBR) ITEMNMBR
, RTRIM(A.ITEMDESC) ITEMDESC
, B.LOCNCODE
, COALESCE(RTRIM(C.SERLNMBR), RTRIM(D.LOTNUMBR), '') LOT_SER_NO
, COALESCE(CASE WHEN C.SERLNMBR IS NOT NULL THEN 1 ELSE NULL END, D.QTYRECVD-D.QTYSOLD, B.QTYONHND) QTY_ON_HAND
FROM IV00101 A
JOIN IV00102 B ON A.ITEMNMBR = B.ITEMNMBR AND B.RCRDTYPE = 2
LEFT JOIN IV00200 C ON B.ITEMNMBR = C.ITEMNMBR AND B.LOCNCODE = C.LOCNCODE AND C.SERLNSLD = 0
LEFT JOIN IV00300 D ON B.ITEMNMBR = D.ITEMNMBR AND B.LOCNCODE = D.LOCNCODE
WHERE B.QTYONHND <> 0
-Trevor
IV00200 = serials on hand; IV00300 = lots on hand
-Trevor
Not out of the box.
And what tables hold the serial numbers on hand?
No, you would need to use SmartList Builder in order to get that information.
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (