Is there a way -- without using Analytics -- to create a report using both posting and non-posting transactions? Thanks

I have used Sales Orders (non-posting) and Invoices (posting) in the same Dataset/Workbook. What hasn't worked for you?

Just jumping in here to follow as I have the same issue as we report sales on Sales orders less Credit Memos! I can't get them on the same report (and then from there creating dashboard KPIS and reports)