Payment instrument

Vasu_JDE

Well Known Member
We have an issue in A/P that some A/P transactions are updated with the incorrect payment instruments. we cannot replicate the issue ourselves. It is one in 500. Hence cannot ask JDE to replicate. Has anyone come across this issue.

Thanks
Regards
 
Yes, we have this issue and are unable to replicate it either. It also occurs sporadically.

Prior to running a weekly cheque run, we run a sql statement which picks these up:

spool C:\OneWorldScripts\Output\alt_payee.txt

set pagesize 50;
set linesize 250;
SELECT RPAN8 as "Supplier", RPDOC as "Voucher Number", RPDCT as "Doc Type", RPPST as "Pay Status", RPAG / 100 as "Gross Amount", RPAAP / 100 as "Open Amount", RPPYIN as "Pay Inst", RPTORG as "Originator", RPUSER as "Last User", RPPID as "Program", RPUPMJ as "Date", RPJOBN as "Computer"
FROM PRODDTA.F0401, PRODDTA.F0411 WHERE A6AN8 = RPPYE
AND RPDCT = 'PV' AND RPPST = 'A' AND RPAAP <> 0 AND RPPYIN = 'T' AND A6PYIN = ' ';

spool off

exit

This gives our AP people a chance to change the incorrect payment instruments through speed release before locking up the cheque run.

Hope this helps.

Regards
Marty
 
Back
Top