Afraid it doesn't help, INV_PICK_SLIP_NUMBERS is a supply chain management table like doo_headers_all - looking to join doo_headers_all to any financials table (tertiary join if necessary).

'So, basically you are looking for a customer PO number and the invoice against that? ' Essentially yes, this is the one part of my report I haven't been able to figure out. Its a 16 col report but for the sake of simplicity just looking to match each invoice num with a respective customer_po_number.

Hi Mandeep, thanks for your reply, in this case all the customer_po_numbers are different than the invoice numbers, looking to bring them both into one table.