I recently had that issue of closed sales orders still showing as open with zero balances in the Open Sales Order report. The solution was to go into the sales order and delete whole lines that were empty and below the last line item. They were empty lines but somehow causing the problem. Difficult to troubleshoot so I hope this helps you!
