Listing Purchase Orders based on items (Query)

[sherif_ahmed]

Hello there

I am using SAP Business one 8.8
I am trying to List all Purchase orders based single item (items and date period) using MSSQL query, similar to the inventory posting list.

would really appreciate some hints of how to achieve that.

Thank you

[Former Member · Accepted solution]

Hi,

Try:

SELECT T0.ITEMCODE, T1.DOCDATE, T1.DOCNUM, T0.WHSCODE,T1.CardCode, T1.CardName,T0.PRICE,T0.QUANTITY,

FROM POR1 T0 INNER JOIN OPOR T1  ON T0.DOCENTRY = T1.DOCENTRY

WHERE T0.ITEMCODE = '[%0]' AND T1.DocDate >= '[%1]' and T1.DocDate <='[%2]'

Thanks,

Gordon