H or B status batches do not show in batch PV list in Manual Check/Payment Entry screen if there apdocs with T status
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
Load a file like this in the "possible values import" screen
File name 25892.csv
"Select_03030_Batch","","","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 DESC, EditScrnNbr","Batch","Batch.BatNbr;Batch Nbr;0;0","Batch.EditScrnNbr;Screen;0;0","Batch.Status;Status;0;0","Batch.PerPost;Period to Post;114;0","Batch.PerEnt;Period Entered;114;0","Batch.CtrlTot;Control Total ;0;0"Just a few areas to look:From the front end of the application, if the check is not "printed", does it appear in the check preview? If not,can you select the voucher you are trying to associate with the electronic payment in Edit and Select Documents for Payment (screen 03.050.00)?If you run a batch register report for that period (choose summary), is both the voucher batch and the payment batch listed and what is the status on each? I have seen the manual payment batch be voided "V" status when releasing the voucher prior to the check print screen initializing.
Site designed by Brightfind
Powered by Cobalt xRM and Higher Logic