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

Mike Chen
October 14, 2008 at 01:15 AM
0 Likes

Correct Answer

Gordon Du 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

Mike Chen October 14, 2008 at 01:15 AM 0 Likes

Gordon Du replied

2 replies

Mike Chen
October 14, 2008 at 01:15 AM
0 Likes