Need help in preparing a SQL query to fetch data

Hi Guys,

i was trying to frame a select query which will extract the receipt lines that have been corrected/returned to supplier after being matched to a paid Invoice line in AP. The parameters in the query will be PO number / po header id.

I am facing difficulty in writing a query which returns the following data. Appreciate your help.

Supplier Number,

Invoice Number,

Receipt Number,

Receipt Date,

Item Number,

PO Number,

Original Quantity Received,

Corrected Quantity Received, (originial quantity - quantity which has been corrected/retured)

--Yogendra