SQL query for fully received items, which are not billed

 Hi,

I am trying to get  the receipts which have been fully received, but not invoiced. 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.

Receipt number

PO number

PO line id

Item code

item desription

ordered quantity

received quantity

billed quantity

Regards

George