In NS, I need a report that shows every invoice and the related SO's, WO's and WOI's with the total material cost for that SO's. It needs to be in a row format so all of the related data is on the same row.
Should I try to access the table instead of making a report?
Yes, I can click through the "Related Records," but I have thousands of invoices to review and clicking just won't work. There has to be a report or table with this information.