GP Smartlist Question.

So, auditors are coming in and I have to pull a shit ton of invoices and their corresponding journal entries.

There are no default Smartlists that contain both the cheque number and the payable's journal entry, so for the past day I have been going through every table looking for common elements to put together the report I need.

Basically I want to start with a cheque number and work my way backward to the journal entry that records the expense being entered into the payable's journal.

Does anyone have any experience with this? Is it even possible?

Cheers,