SAP B1 AP invoice with serial numbers

HI All,

I am looking for all AP invoices with serial numbers

like showing invoice number, doc date, customer name, product name, price, serial number where docnum = invoice number

when some one searches by invoice number it should show up along with the serial numbers. Can some help me with query please.