If you frequently transfer Sales orders in bulk from orders to invoices and looking for a solution to segregate order from invoices in batches, check this out in Mariano Gomez( MVP ) blog post “Hybrid – SOP Batch Splitting”. He did explain in details the business case and the solution.
This is not all, he also has given a file download link for the same which include VBA package & SQL stored procedures.