ricky
Active Member
Hi,
My understanding is that the payment instrument field on an AP record (PV) defaults from the vendor master data. However, we sometimes come across different PVs, for the same vendor, most of which have the "right" payment instrument defauted from vendor mast ,BUT a few with a wrong PI, probably JDE got the Payment instrument from the previous records while looping in the batch, but I can not prove this guess so far.
Any idea on what could cause this? I check through the posts on the list and find some simular post and thinking that maybe it is kind of JDE Bug..
1) I can not duplicate the issue yet.because there in 1 in 500 vouchers run into this issue.
2) I am 100% sure that no user change that field when they doing the voucher match.
3) we are using this SQL to check the issue:
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 "F0411 Pay Inst", A6PYIN as "F0401 PYIN",RPTORG as "Originator", RPUSER as "Last User", RPPID as "Program", TO_CHAR( TO_DATE(TO_CHAR(1900000+RPUPMJ), 'YYYYDDD'),'MM/DD/YYYY') as "Date", RPJOBN as "Computer"
FROM PRODDTA.F0401, PRODDTA.F0411 WHERE A6AN8 = RPPYE
AND RPAAP <> 0 AND A6PYIN <>RPPYIN;
4)We are in ERP8.0
Any help will be greatly appreciated.
My understanding is that the payment instrument field on an AP record (PV) defaults from the vendor master data. However, we sometimes come across different PVs, for the same vendor, most of which have the "right" payment instrument defauted from vendor mast ,BUT a few with a wrong PI, probably JDE got the Payment instrument from the previous records while looping in the batch, but I can not prove this guess so far.
Any idea on what could cause this? I check through the posts on the list and find some simular post and thinking that maybe it is kind of JDE Bug..
1) I can not duplicate the issue yet.because there in 1 in 500 vouchers run into this issue.
2) I am 100% sure that no user change that field when they doing the voucher match.
3) we are using this SQL to check the issue:
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 "F0411 Pay Inst", A6PYIN as "F0401 PYIN",RPTORG as "Originator", RPUSER as "Last User", RPPID as "Program", TO_CHAR( TO_DATE(TO_CHAR(1900000+RPUPMJ), 'YYYYDDD'),'MM/DD/YYYY') as "Date", RPJOBN as "Computer"
FROM PRODDTA.F0401, PRODDTA.F0411 WHERE A6AN8 = RPPYE
AND RPAAP <> 0 AND A6PYIN <>RPPYIN;
4)We are in ERP8.0
Any help will be greatly appreciated.