Saturday 28 June 2014

Vouchers were not getting picked for Matching Process

if Vouchers were not getting picked for Matching Process then excute the below statement and run again matching process.

SELECT COUNT(*) FROM PS_VOUCHER WHERE VOUCHER_ID LIKE '00033333' AND BUSINESS_UNIT='22000'
AND MATCH_OVERRIDE='N' AND MATCH_STATUS_VCHR='E'

1 row selected

UPDATE PS_VOUCHER SET MATCH_OVERRIDE='Y', MATCH_STATUS_VCHR='O' WHERE VOUCHER_ID LIKE '00033333'
AND MATCH_OVERRIDE='N' AND MATCH_STATUS_VCHR='E'
1 row updated