BTW this is only when you press the filter button, it just resets back to the 1st sales page.

Even better would be a query in admin.php (similar to what you do for the orders) whereby you could filter by the payment status as well as the order status.

I am not very good at these queries, could you supply me with the one that would do this in the switch case statment in the count_links function in admin.php.

I need to be able to filter the sales ASAP and I need this up and running urgently.