I would like a report that shows the remaining sales order value that is left to invoice for a specific period.

Eg. JUNE SALES : Total sales orders to be fulfilled/invoiced in June is $500

Half way through the month, I would like to know how we are tracking. The report would show something like:

Order 1       $100        $0            (Order is $100. The sales order is completely invoiced so the remaining value is $0)

Order 2       $50           $50

Order 3       $300         $250

Order 4        $50           $0

Therefore the remaining sales order value is $300 and we have invoiced $200.

Thanks for your help!