Goods Receipt Query

This question is answered

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

Former Member
October 14, 2008 at 01:15 AM
0 Likes

Correct Answer

Former Member replied

October 14, 2008 at 01:15 AM

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

0 Likes 0 View this answer in context

Goods Receipt Query

Former Member October 14, 2008 at 01:15 AM 0 Likes

Former Member replied

2 replies

Former Member
October 14, 2008 at 01:15 AM
0 Likes