Reed,
I am unsure of how your batch was created on importing your transaction into GP and what tool you used. These details would be helpful. Batches are held in the SY00500 table in SQL at the Company Database level (not in the system DB - DYNAMICS).
There is a BCHSTTUS field in this table, which tells GP the batch Status...
Here is a really good list of possible values - sourced from Victoria Yudin's site.
If the status of your batch were not in this data set, I imagine GP might not know exactly what to make of the situation.
Try running the following SQL query against your company database:
Select BCHSTTUS,* from SY00500 Where BACHNUMB = 'Your Batch ID'
If your batch status is not a value in this table, or the status should be Available, run the following script to fix the error (MAKE SURE YOU HAVE A BACKUP)
Update SY00500 set BCHSTTUS = 0 Where BACHNUMB = 'Your Batch ID'
Replace Your Batch ID with the batch number from GP of the batch with the problem.
Francisco’s list of BCHSTTUS (Batch Status) in SY00500:
[This is a much more comprehensive list posted by Francisco Hillyer in a GP Newsgroup - provided courtesy of e-mail by Robert Cavill - thanks Robert and Francisco!]
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
