Sage 100

v2013 std - client can't update SO invoice batch because it shows it is in use. It isn't. Nothing on KB that I can find. Any idea on how to clear? Thanks in advance.

I would have everyone exit and start with rebooting workstations and if that doesn't help, try rebooting the server. It sounds like the file is locked.

Hoping to avoid that, but may be unavoidable...

They didn't by any chance delete a batch, did they? I've had issues where it won't update because a phantom batch (the invoice is still out there but not the batch) is hung. Might query the invoice headers by batch and see if they are all out there. If not, you can reenter it to access the invoice, if necessary. WAG.

Well, I got a little too fancy/schmancy so I deleted the record out of GL_companyActivebach and now everything disappeared.....

Re-enter the batch number in SO Invoice Data Entry and you SHOULD be able to access it again.

All's well that ends well. Recovered the batch and was able to update. Wipe sweat off brow....

Next time try: DFDM GL_CompanyActiveBatch and change the BatchStatus field to blank (if you are sure nobody is using it).

Clicking on Verify Batch button is a good option too.