Halfway through batch, now can't access it

[JunglesMcBeef]

Hi,

Dynamics 5.0: I have a batch that was almost ready for posting but then I got kicked out of Dynamics. Now when I try and access that batch from Transactions-Purchasing-Print cheques it gives me the msg "This batch has been marked for posting" and from anywhere else "This batch has been marked for posting by another user". I cannot delete it or anything, how can I make it so it can be accessed or deleted? Do I have to do it manually through SQL or would there be some sort of reversing action in a process in Dynamics that I could maybe use?

 

[klewis10367]

Do it through sql. I am on GP 7.5 so I do not know if this will help but what you need to do is use Query analyzer to change the status of the batch in the SY00500 table in the Company database to 0. Right now it should be marked as 1, 0 will make it available.

 

[JunglesMcBeef]

Thanks for that, but we worked it out in the end, that was what needed to be done. Excellent response though, thank you very much.