I have a list of taxes in Magento 1.9 and I need to display all this available taxes in the admin Order Grid. I found all this taxes in database in the sales_order_tax. Is there any way to display all this taxes?
My database table is look like this:
So the idea is: each tax must have their own column in the order grid
I try something like this but is not work:
$collection->getSelect()->joinLeft( array('sf' => $resource->getTableName('sales_order_tax')), 'sf.entity_id=main_table.order_id', array( 'sf.code' ) );