Goods Receipt Query
Hello -
We have this Query to show us when we have received products into stock. But, it doesn't seem right. The date is not right. Think it is linked to wrong doc...please check anyone!
Thanks!
Mike
SELECT T0.BASEREF [PO#], T0.ITEMCODE [Item#], T0.DOCDATE [Receipt Date], T0.QUANTITY [Receipt Qty], T0.PRICE [Cost]
FROM [DBO].[PDN1] T0
Gordon Du replied
Mike,
Try this:
SELECT T0.BASEREF PO#, T0.ITEMCODE Item#, T1.DocDate 'Receipt Date', T0.QUANTITY 'Receipt Qty', T0.PRICE Cost FROM DBO.PDN1 T0 INNER JOIN DBO.OPDN T1 ON T1.DocNum = T0.DocEntry Where T0.BASEREF is not NULL and T0.ITEMCODE is not NULL
Thanks,
Gordon