Sales Queries

Hi Gurus

I'm a beginer in SAP and SQL,Im facing difficulty generating a sales report which shows all sale with credit notes deducted. Im using SAP B1 8.8, basically what i need is

Barcode, Itemcode, Item_type (which is a user defined value ), Size (UDF), Gender (UDF), Brand (UDF), Lintetotal, Quantity, Grossprofit, Ocrcode, Ocrname, Cardcode, Cardname, docdate

Im able to generate total sales however i cannot find a way to remove the retuned items from sales report. please note sometimes credit notes are created without any link to invoice or item ( when invoice is closed there is no way to link to it ).

I would apriciate if you can help me on this.

Kind Regards

Hussain Shah