How can I get invoice collection filter by status paid & payment method ?
I know how to filter order collection by payment method
$orders = Mage::getModel('sales/order')->getCollection(); $orders->getSelect()->join( array('payment' => $orders->getResource()->getTable('sales/order_payment')), 'payment.parent_id = main_table.entity_id', array('*') ); $orders->addFieldToFilter('method','ccsave');
But I can't make it work with
where invoice status is also paid