IT gave me this code and I want to validate it directly with GP's interface.
I'm skeptical because I have orders that have more shipped than ordered. Thanks ahead
SELECT
B.ITEMNMBR
, B.QUANTITY * QTYBSUOM AS ordered
, B.QTYPRINV * QTYBSUOM AS shipped
,DOCDATE
,b.SOPNUMBE
FROM SOP30200 AS A WITH (READUNCOMMITTED) INNER JOIN
SOP30300 AS B WITH (READUNCOMMITTED) ON A.SOPNUMBE = B.SOPNUMBE AND
A.SOPTYPE = B.SOPTYPE