How to Delete an Invoice Batch "Post-in-Progress" but with errors

[emillington]

I have an invoice batch imported with blank document types. An attempt to post the batch left it in the "Post-in-Progress" state and can not be opened to change the data. How do I delete the batch. Thanks

 

[ettienne]

Set the batch status to 1 in the batch control table.

 

[emillington]

Thanks - how do I access the batch control table and set the batch status to 1?

 

[Jay Converse]

With a database editor.

 

[emillington]

Is there any other option - I am a user and we have no IT support.

 

[ettienne]

Yes, contact your Accpac business partner.

 

[emillington]

sorry - but we are a two user shop - very small company - I will contact AccPac, but we are only on 4.2A with no support.

 

[Jay Converse]

Pervasive? Open up ARIBC in the Pervasive Control center.

 

[emillington]

thanks so much - i found another tool left over from our past IT support open the database, found the table and fixed the data issue - again - thanks so much

 

[kmgoingnuts]

Hi emillington - I am having the same problem today - how did you fix yours?