DSauve
Legendary Poster
Just thought I'd let you know about SAR # 5087248, which deals with corruption of the APTD values in the F43121 table. (The SAR was originally included in ESU # 10960, which has been superseded by ESU # 11180.)
The problem we encountered was on multi-line PO's which were completely received, but then only some of the lines were vouchered and paid. The payment group update program (R04575) calls a business function, B0400076, which is supposed to update voucher records with payment information. However, it was "dribbling" the APTD value from the first record on down through ALL the F43121 records for that PO, whether they were vouchered or not.
This SAR does seem to address this issue, as I tested it successfully in Prototype. However, I am now left with the mess of trying to clean up the APTD values in the F43121 table. Unfortunately, as best I can tell, the "voucher detail" for vouchers matched against PO's, is stored in the F43121 table -- the very one which is corrupted. Does anyone know of any other table in which voucher detail information is stored? From the F43121 table, I have valid voucher #, type, and suffix (i.e. line#) values, but can't find any file like a voucher detail for these type of vouchers, so I can recalculate the correct values for APTD.
I hope this helps and/or alerts you if you are running XE and A/P with voucher matching. Please let me know if you have any suggestions on cleanup. Thank you.
Don Sauve
Wagstaff, Inc.
OW XE, SP15.1, HP-UX 11.0, Oracle 8.1.6
The problem we encountered was on multi-line PO's which were completely received, but then only some of the lines were vouchered and paid. The payment group update program (R04575) calls a business function, B0400076, which is supposed to update voucher records with payment information. However, it was "dribbling" the APTD value from the first record on down through ALL the F43121 records for that PO, whether they were vouchered or not.
This SAR does seem to address this issue, as I tested it successfully in Prototype. However, I am now left with the mess of trying to clean up the APTD values in the F43121 table. Unfortunately, as best I can tell, the "voucher detail" for vouchers matched against PO's, is stored in the F43121 table -- the very one which is corrupted. Does anyone know of any other table in which voucher detail information is stored? From the F43121 table, I have valid voucher #, type, and suffix (i.e. line#) values, but can't find any file like a voucher detail for these type of vouchers, so I can recalculate the correct values for APTD.
I hope this helps and/or alerts you if you are running XE and A/P with voucher matching. Please let me know if you have any suggestions on cleanup. Thank you.
Don Sauve
Wagstaff, Inc.
OW XE, SP15.1, HP-UX 11.0, Oracle 8.1.6