Advance adjustment with withholding entry. A regular voucher with withholding posted before applying with Advance voucher.
Due to which, two lines created in Remittance where in Voucher vendor amount adjusted with advance voucher and withholding amount remains unapplied.
SELECT COUNT(*) FROM PS_VCHR_LINE_WTHD
WHERE BUSINESS_UNIT = '' AND VOUCHER_ID IN (‘ ')
AND VOUCHER_LINE_NUM = 1 AND WTHD_ENTITY = ‘ 'AND WTHD_TYPE = ' '
AND WTHD_JUR_CD = ‘’ AND WTHD_CLASS = '' AND WTHD_APPL_FLG ='V'
(5 Row Selected)
UPDATE PS_VCHR_LINE_WTHD
SET WTHD_APPL_FLG = 'P' WHERE BUSINESS_UNIT= '' AND VOUCHER_ID IN (‘ ')
AND VOUCHER_LINE_NUM = 1 AND WTHD_ENTITY = '' AND WTHD_TYPE = ''
AND WTHD_JUR_CD = '' AND WTHD_CLASS = '' AND WTHD_APPL_FLG ='V'
(5 Row Updated)
SELECT COUNT(*) FROM PS_VCHR_LINE_WTHD
WHERE BUSINESS_UNIT = '' AND VOUCHER_ID IN (‘')
AND VOUCHER_LINE_NUM = 1 AND WTHD_ENTITY = ‘’ AND WTHD_TYPE = ''
AND WTHD_JUR_CD = ‘’ AND WTHD_CLASS = '' AND WTHD_APPL_FLG ='P'
(5 Row Selected)
UPDATE PS_VCHR_LINE_WTHD
SET WTHD_APPL_FLG = 'V' WHERE BUSINESS_UNIT= '' AND VOUCHER_ID IN (‘')
AND VOUCHER_LINE_NUM = 1 AND WTHD_ENTITY = '' AND WTHD_TYPE = 'INDTD'
AND WTHD_JUR_CD = '' AND WTHD_CLASS = '' AND WTHD_APPL_FLG ='P'
(5 Row Updated)
