Sage 100

Sage 2016 Premium. Is there a way to merge a range of SO Invoice batches? I can merge one by one but need something faster. Alternatively, is there a way to select a range of batches in the grid, some key combo maybe? Or SQL query/update? The grid is taking about 8-10 minutes to load. Select all is not an alternate it generates an error; there are 21,000 batches to update each batch has only one invoice (EDI and customer just confessed they are ""behind"" in updates)

Use SSMS. Use MAS_ABC. Update SO_InvoiceHeader Set BatchNo = '12345' (Use the first batch number probably). Assumes all invoices will be posted as one batch. Then post this one batch. Once all modules batches are posted then you can use SSMS again to delete the remaining batches from GL_CompanyActiveBatch. Not sure if this table has extra stuff in it or you could simply Delete from GL_CompanyActiveBatch. Be careful on this last one since I'm not looking at a sample table now

Great idea thanks @RobertWhite I'll watch the last file as suggested.

MAS_TST Update SO_InvoiceHeader Set BatchNo = '01972' returned (19594 row(s) affected) but the invoices and batches are still in Invoice Data Entry. Opened a batch, invoice and all detail still there. Was this to be executed SSMS Query or somewhere else?

Your goal, I thought, was to put all invoices in 1 batch. You did that. If you 'verify' the batch the number of invoices in that batch should update to 19,500. It's the second SSMS thing that will clear out the now empty batches. If you select distinct(batchno) from so_invoiceheader that will confirm what batches have invoices in them.

Yes, my goal is that I jumped to the conclusion Update...sorry...got it...

Thank you for the help @RobertWhite. I was able to consolidate to one SO batch and update. It did takes several hours but at least I was just monitoring the update of one batch instead of running 1,000s. In the final step, used module code to eliminate risk of deleting any other batches: Delete From [MAS_TST].[dbo].[GL_CompanyActiveBatch] Where [ModuleCode] = 'S/O'

Great news. Thanks for the update @MoiraGoggin