My Oracle Support Banner

E1: 04: FAQ - Frequently Asked Questions about EDI Payments (820) (R47052T/R47057/R47058) (Doc ID 1065636.1)

Last updated on MAY 28, 2021

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version XE and later
JD Edwards EnterpriseOne EDI - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.


This document provides answers to some frequently asked questions regarding EDI outbound payments (R47052T, R47057, R47058).


Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Internal Note
Questions and Answers
 General/Setup Questions
 Question 1:  Does JD Edwards EnterpriseOne provide a Payment Print Program for EDI Payments to European countries (i.e. UK, Germany, Switzerland, or France)?
 Question 2:  Is it possible to specify a version of the Create A/P Bank Tape EDI Format (R47052T) other than ZJDE0001?
 Question 3:  Is there an extraction program for EDI 820 Outbound payments?
 Question 4:  Does Oracle provide detail specifications of the flat file layout for the EDI 820 payment process?
 Question 5:  Is there a program to purge the records in the EDI worktables: (EDI Payment Order Header F47056W, EDI Payment Order Bank F470561W, EDI Payment Order Vendor F470562W, EDI Payment Order Payee F470563W, EDI Payment Order Remittance Advice F47057W)?
 Question 6:  When you undo an EDI payment group in the Work with Payment Control Group application (P04571), are the records in the temporary work tables (F47056W, F470561W, F470562W, F470563W, F47057W) removed?
 Question 7:  Are there any EnterpriseOne reports to reconcile EDI 820 payment data sent to the bank?
 Question 8: What payment format is used by the Copy To Outbound EDI File UBE (R47057)?
 Question 9: How does R47052T populate the Control Digit (CHKD) field in EDI Payment Order Payee N & A – Work (F470563W)?
 Troubleshooting Questions
 Question 1:  When running the Copy to Outbound EDI Files program (P0457) on the web, why is the file not saving to the local path specified?
 Question 2:  When a discount is taken on a voucher that is then paid using EDI, why is the Discount Taken Transmitted (data dictionary item TDSA) field not populated in the EDI Payment Order Remittance Outbound table (F47057)?
 Question 3:  Why is the EDI payment amount in the A/P Payment Tape (F04572OW) preceded with an asterisk (*) and displayed incorrectly?
 Question 4:  Why are the Discount Taken Transmitted (TDSA) amounts in the EDI Payment Order Remittance Advice - Outbound (F47057) duplicating through the transaction records after the first record with a discount, resulting in an out of balance condition between the EDI Payment Order Remittance Advice - Outbound (F47057) and the EDI Payment Order Header - Outbound (F47056) records?
 Question 5:  According to the NACHA (National Automated Clearing House Association) standards for ACH 820, CTX format for the Addenda record 7, the payment file should include the invoice number on the vouchers being paid. Why does the EnterpriseOne CTX format for record 7 not include this information?
 Question 6:  When running the Copy To Outbound EDI File UBE (R47057), why are the records not copied to the EDI Payment Order Header Outbound table (F47056), even though they were added to the remaining EDI outbound tables and the "Duplicate Not Allowed' error message is being thrown?
 Question 7:  Why does the system create a check (R04572) when running EDI payment R47052T?
 Question 8:  Why is the system using the Next Payment Number from the GL Bank Account when writing an EDI payment?
 Question 9: When using data selection on the Copy to Outbound EDI Files program (R47057), why is the system not selecting the correct records?
 Question 10: When the bank rejects the bank tape because one payment is corrupted, how do you fix the bank tape?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.