I want to make a query report for the sales invoices that will be as follows:
Row: master data from the invoice like ID, customer name, …etc
under this row I want to list all invoice items with its quantity.
So any advice or there anyway to do this ?!
Bellow an attachment for the report view I need: