I'm running a SQL query against transactions and I can't for the life of me work out how to include unapproved customer invoices (non GL impacting). Any ideas? No problem doing it in a saved search.