Share
Report
2This is a problem and a resolution post... because I didn't see one out there and I know I can't be the only person that has had this problem.
Client called and stated that they went to post a check batch but after she printed the checks, the batch would not post. It kept saying it was in the printing status.
I logged into SQL and searched the SY00500 table for the batch, it was nowhere to be found.
The problem was that the BATCH NUMBER included an apostrophe. example: FINDER'S FEE
So, searching in SQL for that is impossible because of the apostrophe.
Here is what I did to find it, and then update the batch name and then update the batch status:
SELECT * FROM SY00500 where BACHNUMB like 'finder%' - - found a batch called: FINDER'S FEE
Update SY00500
set BACHNUMB='FINDERS FEE'
Where DEX_ROW_ID='103534066' -- THIS UPDATES the BATCH NUMBER TO NOT INCLUDE THE APOSTROPHE
SELECT * FROM SY00500 where BACHNUMB='FINDERS FEE'
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='FINDERS FEE'
Hope this helps someone.
Categories:
I have the same question (0)
All responses (
Answers (
