SELECT
T0.[CardCode] AS 'Vendor Code',
T1.[CardName] AS 'Vendor Name',
T0.[LeadTime] as 'Lead Time',
T0.[ItemCode],
T0.[ItemName],
T2.[OnHand] AS 'In Stock',
T2.[OnOrder] AS 'Ordered',
T0.[MinLevel] AS 'MSQ',
T0.[MinOrdrQty] AS 'MOQ...
Hi Anthony,SELECT T0.[DfltWH], T0.[ItemCode], T0.[ItemName], T0.[CodeBars], T0.[SuppCatNum], T0.[OnHand], T0.[MinLevel], T0.[MaxLevel], T1.[Price] FROM OITM T0 INNER JOIN ITM1 T1 ON T0.[ItemCode] = T1.[ItemCode]hopefully it can help you
I have a simple query for that.SELECT T1.[ItemCode], T1.[Dscription], SUM(T1.[Quantity]) FROM OIGE T0 INNER JOIN IGE1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.[DocDate] BETWEEN [%0] AND [%1] GROUP BY T1.[ItemCode], T1.[Dscription], T1.[Quantity] ...
