Batched is marked or stuck
Run script below
use TROP;
SELECT * FROM sy00500 where bachnumb = 'xxx'
xxx is name of batch
Check mkdtopst – if it is set to 1 it is marked so you need to set it to 0
Also check bchstatus (below)
The following list shows what each number represents when it is used in the Batch Status field of the SY00500 table: (I have copied this list from Victoria yudin’s website, this is very comprehensive list therefore I have copied it as it is)
0 – Available
1 – Batch Posting
2 – Batch Being Deleted
3 – Batch Receiving Transactions
4 – Batch Done Posting
5 – Being Printed
6 – Being Updated
7 – Interrupted While Posting
8 – Interrupted While Printing
9 – Interrupted While Updating
10 – Recurring Batch Errors / Transactions Did Not Post
11 – Single Batch Error / Transactions Did Not Post
15 – Error While Posting Computer Checks
20 – Interrupted While Processing Computer Checks
25 – Interrupted While Printing Computer Checks Align
30 – Interrupted While Printing Computer Checks
35 – Interrupted While Printing Computer Checks Align Before Reprint
Computer Checks
40 – Interrupted While Voiding Checks
45 – Interrupted While Reprinting Checks
50 – Interrupted While Processing Remittance Report
55 – Interrupted While Processing Remittance Report Align
60 – Interrupted While Printing Remittance Report
100 – Processing Computer Checks
105 – Check Align Being Printed Before Print Checks
110 – Printing Computer Checks
115 – Check Align Being Printed Before Reprint Checks
120 – Voiding Computer Checks
125 – Reprint Computer Checks
130 – Remittance Report
135 – Printing Remittance Align Form
140 – Printing Remittance Form
Then run this to open the batch up:
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
xxx is batch name
Should get a row affected then try to get into the batch again