Views:

For SL 2015 and SL 2018, if you have an issue in AP Manual Check Entry where you can't pull up a check batch with a status of H or B, try typing in the batch number in the field and tab off that field to see if it will come up.  If not, you can run the below query against the application database to fix the stored proc on the database, and then you should be able to type in the batch number.  You won't be able to hit F3 on the PV and see it, but you should be able to type it in the batch number field.  

Note: As a precaution please confirm recent backups of your SL databases exist before proceeding.

Run this  SQL script on app DB(s)

alter Proc Select_03030_Batch @parm1 varchar(10), @parm2 varchar ( 10) as
       Select * from Batch
           where CpnyID = @parm1
                 and ((EditScrnNbr = '03030' and status in ('B','C','H','P','S','U'))
    OR (EditScrnNbr = '03620'and status in ('C','P','U')))
             and module = 'AP'
   and BatNbr like @parm2
           order by BatNbr