Which orders can be fulfilled (with ASM and 1.7.8

[madpugger]

Hi, I am looking for a module, or an SQL query that will show all orders that can be fulfilled today with the stock we currently have.

For example, perhaps we have had a delivery of goods and I want to know which back orders can now be processed.

PS must already have this basic functionality, as when an order is placed, it will automatically select Payment Accepted or In Back Order as the order status depending on stock levels. So what I want is to use this functionality at a later date, not just when the order is placed.

 

Surely we are not the only people who would find this useful!