Here’s another post that isn’t rocket science but might save someone some time and effort.

We had a payables batch that gave an error message when our user tried to post it. Batch recovery did not help. Our user could not tell what transactions were contained in the batch, because we could not open the batch and look.

GPStuckPayablesBatch

This SQL query showed us the batch transactions. I’ve used XYZ for the batch name.

select * 
from pm10000
where bachnumb='XYZ'

From there, our user was able to check the status of each document and fix the problem.

Hope this saves someone a little time!

Leave a Reply

Your email address will not be published. Required fields are marked *

 characters available