SELECT

T0.DocNum AS Order,
T1.ItemCode AS Item,
T2.U_Internal_Code AS IntItem,
CAST (((T2.onhand+T2.OnOrder)-T2.IsCommited) as int) AS Stock,
T3.ShipDate

FROM

ORDR T0

INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode
INNER JOIN POR1 T3 ON T2.U_Bestelcode = T3.U_Bestelcode

WHERE T0.DocNum='1234' AND T3.ShipDate=(SELECT MAX (ShipDate) FROM POR1 WHERE T3.ShipDate = ShipDate)

ORDER BY T1.ItemCode