You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Vouchers not being picked up by PayCycle

1 reply [Last post]
Guest's picture
Guest

I have a custom process that creates single payment vouchers from a csv file. The load to the voucher staging tables ( PS_VCHR_HDR_STG, PS_VCHR_LINE_STG, PS_VCHR_DIST_STG, PS_VCHR_VNDR_STG) load with no problem. When the PayCycle Selection Criteria is ran it doesn't pick up any of the records.

I have verified the following:

The bank information is correct
PS_PYMNT_VCHR_XREF.PYMNT_SELCT_STATUS = 'N'
PS_VOUCHER.IN_PROCESS_FLG = 'N'
Vendor not on payment hold
Voucher not on hold or inactive
Voucher is approved

So just troubleshooting I changed the payment information on one voucher and saved it, then changed it back and saved it again...ran paycycle process and it returned the 1 voucher.

So it's missing some key information but not sure what just yet. I will do a trace but want to see if there were known issues.

Thanks

Guest's picture
Guest (not verified)
Re: Vouchers not being picked up by PayCycle

Didn't get any responses but the solution was to make sure the VCHR_BANK_STG was loaded with the key information - VCHR_BLD_KEY_C1, VCHR_BLD_KEY_C2, VCHR_BLD_KEY_N1, VCHR_BLD_KEY_N2...so that VCHR_VNDR_BANK is loaded when the voucher build process runs.

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
4 + 5 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.