This query shows goods receipts that were cancelled in the selected period:SELECT DISTINCT T2.DocEntry, T2.[DocDate], T2.CardCode, T2.CardName, T0.DocDate as "Cancelled on" FROM OPDN T0 INNER JOIN PDN1 t1 ON t0.Docentry = T1.DocEntry INNER JOIN OPDN...
SELECTT0.[ItemCode],T0.[ItemName],T1.[Price] as 'Inkoopprijs',T0.[AvgPrice],CASE WHEN T1.[Price] = T0.[AvgPrice] THEN 'WAAR' ELSE 'ONWAAR' END AS 'Gelijk?'FROMOITM T0 INNER JOIN ITM1 T1 ON T0.[ItemCode] = T1.[ItemCode]WHERET1.[PriceList] = [%0] ANDT0...
