I've got a sales order user event script that creates a cash sale when SOs are created by an integration suitelet. For some reason the suitelet doesn't always trigger the user event. I'm trying to write a map/reduce to go back and create the cash sales. Is there an easy way to find sales orders that don't already have cash sales?

Usually that is a transaction search where the status is one of the pending billing statuses

I figured it out. I have a transaction search where the type is sales order, the created by is the integration user, and the first line item's billing transaction is empty.