Skip to Content
0
Former Member
Jun 01, 2015 at 02:10 PM

All orders shipped and not invoiced

140 Views

Hi all,

I am trying to create a query that shows me all orders that have been shipped and not invoiced. I have tried combining the tables (Sales Order, Delivery, and Invoice) using Left Join but I haven't figured out how to show deliveries that have been delivered but not invoiced.

Best,

Kate