| Purpose |
| Questions and Answers |
| Electronic Funds Transfer (EFT) Payment General/Setup Questions |
| Question 1: What is the purpose of the Pre-Note Code when using EFT payments? |
| Question 2: What are the lines filled with 9s after record 8 used for in the AP Payment Tape table (F04572OW) for CTX format? |
| Question 3: Is it possible to use a different payment instrument than the default setup in the Supplier Master? |
| Question 4: Does EnterpriseOne provide the capability to send e-mail notifications to suppliers with payment details? |
| Question 5: Does EnterpriseOne support the PPD format? |
| Question 6: Can the EFT Remittance Advice be reprinted? |
| Question 7: Where is the File ID Modifier (as per the R04572T2 processing options) updated? |
| Question 8: Is there a way to mask the bank account number on the Remittance Advice PDF? |
| Question 9: Is it possible to use different versions of the P04572T1 for different G/L Bank Accounts? |
| Question 10: How is the next payment number determined for Electronic Funds Transfers (EFT)? |
| Question 11: Is it possible to reset the payment number used for EFT payments? |
| Question 12: Which payment methods use the pre-note code? |
| Question 13: How is the '7 ' record formatted for the CTX payment format and what is the information stored after *CK* string in the text file? |
| Question 14: What field is used to print the Supplier information on the Bank Tape? |
| Question 15: Is it possible to select a delimited character when creating the EFT payment file using R04572T1 or R04572T2? |
| Question 16: Is the payment next number warning message relevant if using an EFT print program? |
| Question 17: Where are the values for Duns and EIN stored, which is used by Processing Option 4 of the R04572T2? |
| Question 18: What payment formats are available for localizations? |
| Question 19: Is it possible to process an EFT file (F04572T) containing more than one bank account? |
| Question 20: Is it possible to send the EFT Remittance Advice Electronically to the bank? |
| Question 22: Is there a processing option for the CTX format to provide the balancing debit entry to the file as there is for the PPD format? |
| Question 23:Is there a way to create the bank tape in a way that the bank processes the payment for a future date? |
| Question 24: Can a negative payment be generated in bank tape process? |
| Question 24: Can a bank tape be created in XML format? |
| Electronic Funds Transfer (EFT) Payment Troubleshooting Questions |
| Question 1: What causes EFT payments with a supplier's Pre-Note Code unchecked to increment both the ACH Next Number and the Bank Account's Next Payment Number? |
| Question 2: Why does the payment advice PDF for the Create A/P Bank Tape (R04572T2) UBE print in landscape orientation? |
| Question 3: Why is the check payment number, retrieved from Work with GL Bank Accounts (P0030G), displayed when writing an EFT payment group? |
| Question 4: Why is the EFT Bank Tape for CTX formatting missing a '1' in front of the Tax ID? |
| Question 5: Why are standard checks (R04572) still printing in conjunction with the EFT program (R04572T2) even though the Pre-Note Code is not checked in the Supplier Master (P04012)? |
| Question 6: What could cause an EFT program such as R04572T2 or R04572OZ to loop when Pre-Note Code is checked in the Supplier Master (P04012)? |
| Question 8: When running the R04572T1 for PPD format, why does a hyphen appear in the Identification Code Designator? |
| Copy Payment To Diskette (P0457, P0457D) General/Setup Questions |
| Question 1: Can a default server be specified for the file created by the Copy Payment to Diskette (P0457D) if we have more than one server for JDE? |
| Question 2: How can the file name (FNAM) displayed in the P0457 grid be changed? |
| Question 4: Is there a purge program for the F0457 and F04572OW (A/P Payment Tape) tables? |
| Copy Payment To Diskette (P0457, P0457D) Troubleshooting Questions |
| Question 1: When running the P0457 Copy Bank Tape, on release 8.12 on an AS400 platform, why does the export .txt file contain garbage characters? |
| Question 2: On an 8.12 web release and on an AS400 platform, why does the output only go to the IFS file under the Root Directory? |
| Question 3: When I try to copy the bank file to a flat file, why do I get an error message saying "Error while attempting to create file"? |
| Question 4: Why do the records in a payments text file not have the desired/needed number of characters? |
| Question 5: Why might the bank file appear as only one line of data when running the P0457D Copy Bank Tape using a non Windows Enterprise Server? |
| Question 6: What could cause the Create Bank Tape (P0457D) to generate a blank text file? |
| Payment Outbound Interoperability (P0400297) General/Setup Questions |
| Question 1: Is there a process by which I could use the F0413Z1 and F0414Z1 tables data for inbound payments processing? |
This document provides answers to frequently asked questions regarding EFT Processing, Outbound Interoperability Payment and Payment Register.
Answer 1: The Pre-Note Code checkbox (data dictionary item AB1) located in the Supplier Master (P04012) indicates how supplier payments are written. The two different processes are as follows:
Answer 2: Lines starting with number 9 are called File Control Records and are the final record set in the CTX (Corporate Trade Exchange) format. These lines are mandatory and denote the end of the CTX file. Without this record, the bank will not process the CTX payment format successfully. It represents the following elements:
Answer 3: Yes. The payment instrument (PYIN) can be entered at the time of voucher entry (P0411), or it can be changed by using speed release (P0411S) before the payment group is created.
Answer 4: One can leverage the BI Publisher and JD Edwards integration. As of Tools Release 8.98 one can setup Report Definitions and use the Data Driven E-Mail feature. See more on how to set a Report Definition to e-mail the Payment Print PDF to the Suppliers in How to e-mail Accounts Payable Payment Print PDFs to Suppliers using Report Definitions)
Answer 5: Yes. The PPD format is available as of EnterpriseOne release 8.9. To use this format, set a payment instrument to use the Payment Print Program P04572T1 in the Work with Default Payment Instrument Defaults program (P0417).
Answer 6: Yes. There is an option using Manual Payment with Voucher Match (P0413M) application. To reprint the Remittance Advice use the following steps:
Answer 7: The File ID Modifier is written in the 34th position under the field name KNAPTA in the A/P Payment Tape table (F04572OW).
Answer 8: The standard EnterpriseOne solution does not provide this functionality.
Answer 9: This setup can be achieved by creating different versions for the EFT payment instrument for the different G/L Bank Accounts in the Work with Payment Instrument Defaults program (P0417). Each payment instrument record can specify a different version of the P04572T1 in the Print Version (data dictionary item PVN) field.
Answer 10: When writing EFT payments, the system displays the next payment number from the GL bank account information (P0030G). However, this number is not used. EFT payments use the Accounts Payable Next Numbers for ACH from the Work with Next Number (P0002) application.
Answer 11: To reset the payment number used for EFT Payments:
Answer 12: The pre-note code is only used for R04572T2 (CTX) and R04572T1 (PPD) format. Other electronic payment formats (for example localizations) do not use the pre-note code. Check formats never use the pre-note code.
Answer 13: After '*ZZZ\REF*CK*' string in the text file, the payment number is inserted.
Answer 14: The EFT programs use the Alpha Name (ALPH) in Address Book (P01012) to populate that Supplier information in the bank tape file.
Answer 15: JD Edwards EnterpriseOne does not provide an option to select a specific delimited character to be inserted in the electronic payment file (F04572OW) when running R04572T1 or R04572T2.
Answer 16: The following warning message that pops up in Work with Payment Group - Check Number (P04572|W04572D) screen appears despite the payment instrument being used: "If this check write process does not run to completion, you may want to reset the next available check number to avoid out-of-sequence check numbers." In the case of EFT payments, changing the number on this screen does not change the next number used for the payments created and the warning message is irrelevant.
Answer 17: The DUNS number is maintained in the Address Book Master (P01012) under the Additional 2 tab. The EIN number is also in the Address Book Master (P01012) but is saved in the Tax ID (TAX) field.
Answer 18: For details on localization payment formats check JD Edwards EnterpriseOne Globalizations: Localizations, Translations, Certifications/Registrations (Doc ID 752291.1) under Details and Announcements columns for each specific localization.
Answer 19: Yes, set processing option #2 in the PRINT tab behind P04571 to '1' to separate the file by bank account.
Answer 20: No, the system does not currently have the functionality to send an electronic copy of the EFT Remittance Advice to the bank. It is possible to send the file via email using BI Publisher. This functionality is discussed in Doc ID 652988.1.
Note: the payment instrument pointing to R04572T2 is not the blank payment instrument, but T for example.
Answer 21: R04572 will use a version with the same name as the version defined for R04572T2 in P0417. For example given the following:
When writing the payment group created for this supplier’s vouchers with this payment instrument, Work with Payment Groups (P04571) will try to find a R04572 version called TEST0001. If it exists, R04572 TEST0001 is called.
If it does not exist, R04572 ZJDE0001 is called.
Answer 22: No, this is not available for the CTX format.
Answer 23: This functionality is not currently available.
Answer 24: Unlike automated check processing a Debit memo cannot be generated when writing to a bank tape.
Answer 24: This functionality is not currently available.
Answer 1: It is possible that the Special Handling Code (data dictionary item SPHD) for the EFT (Electronic Funds Transfer) print program is incorrect. In UDC table 04/PP (Produce Bank File), ensure that the Special Handling Code is set to 2 for the Produce Bank Tape - CTX Format (P04572T2). In releases 8.10 and higher, also verify that Produce Bank Tape - PPD Format (P04572T1) is included in this UDC.
Answer 2: The current design of the Create A/P Bank Tape (R04572T2) would not fit all the information and columns with a portrait orientation on letter sized paper. Therefore, this particular payment program is set to default with a landscape orientation. The report's format would need to be customized to print it with portrait orientation.
Answer 3: If the Pre-Note Code has been flagged for the supplier in the Supplier Master (P04012), a physical check is produced in addition to the ACH test file. In this scenario, the system uses both the Next Payment Number (data dictionary item NXTC) from the GL Bank Account, as well as the Next Number for EFT payments. However, even if the Pre-Note Code is not checked, the system still displays the Next Payment Number from the GL Bank Account, but the number is not used or incremented.
Answer 4: To fix this error, follow the steps below:
Answer 5: If you do not have a bank account defined for the Supplier in P0030A, then the file created by the EFT CTX format (R04572T2) would be incomplete and your bank would not know where to send the payment. Therefore, the system treats the EFT process as a pre-note and still prints standard checks even if the pre-note code is not checked in the Supplier Master (P04012). If you are experiencing this issue, ensure you have a bank account defined for the supplier.
Answer 6: This issue is most likely caused by an incorrect set up in the processing options of the EFT print program. For all ACH programs, there is Print tab that has a processing option where you should populate the standard check program that should be used if Pre-Note code is checked in the Supplier Master (P04012). The pre-note code in the Supplier Master (P04012) indicates that you are running a TEST ACH/EFT batch and therefore also need the standard checks to print so that you can mail these to your suppliers. The Print Program on the Print tab should point to a standard, non-EFT program, that prints hard copy checks in the case that Pre-Note code is checked If this processing option is set to the same print program that is calling it (e.g. P04572T2 inside the POs of R04572T2), the program calls itself, so that it will run the first time, check the pre-note code, then use the Print Program PO and call itself again and check pre-note code, then use the Print Program PO and call itself again, over and over again in an endless loop until you get the memory violation. Please change this Processing Option to a standard check print such as the P04572.
Answer 7: There is no TC (table Conversion) for the F0401 during the migration process to E1 from World. E1 does not recognize the value of BLANK because it does not exist in E1. You will need to use a utility to update the field in E1 from P to N.
Answer 8: Verify that the pristine ZJDE0001 version of the R04572T1 is executed and not a copied version.
Answer 1: To have a default server, you have two options to consider:
Answer 2: The File Name can be changed from the processing option of the program creating this record. For example, in R04572A, R04572T2 and under the Tape tab, change the setup for [File Name].
Answer 3: It is currently not possible to have R04572F3, or any other EFT payment format, to call P0457 and P0457D automatically.
Answer 4: No, there is not a purge program for these tables. In case a bank needs a second copy of these files, this is the only place the information is stored in the system.
Answer 1: Verify the AS/400 System or User Specific Code Page. These are the commands used to determine the Code Page by System and User on the AS/400:
Use this Code Page value to set up the correct Flat File Encoding page in the Work with Flat File Encoding application (P93081).
Answer 2: This functions as designed and unfortunately this cannot be changed at this time.
As of February 2010, a client provided the following suggestion. "use /folder/folder/filename. For example using "/E900/DV900/Export/ACH.txt" will write the ACH.txt to the Export folder under the DV900 folder under E900."
Answer 3: There are multiple reasons why this error can occur.
Answer 4: The record length of a text file processed through Copy Bank File to Diskette (P0457D) depends on the processing option value for record length behind P0457D. This is the first processing option on tab 'Defaults'.
If this processing option is left blank, the records in the file created will have their original length, which may not be the desired/needed number of characters per record.
To create records with the desired/needed number of characters, populate this processing option with this number.
Answer 5: The data will appear as either one or two lines depending on which program you are using to view the data. For example in notepad the data might appear as one line, but using notepad ++ the data might appear as two lines. This is because some operating systems use different New Line conventions. However, the record has been created successfully may still process through the bank. See more on this in When creating a file with P0457D, why is the file missing the carriage returns?
Answer 6: It is possible that the UDC 04/SC is set up incorrectly. Per E1: 04: Overview of User Define Codes Within EnterpriseOne Accounts Payable Setup (P0004A) (Doc ID 1991768.1), this UDC needs to have the invalid characters (up to 30) in the description 01 field and NOT in the code field. They can have up to 30 per line in this UDC and the Code value actually does not matter. Be sure to clear cache after making changes to any UDC.
Answer 1: Since Payments are usually meant for outbound processing, it allows to share payment information with the external systems. Currently there is no such process which could use the inbound information in the F0413z1/F0414z1 tables to process it further to create payments in the master transaction F0413 and F0414 tables. However, you can use the R04110ZA to create Manual Payments without Voucher Match. To do so, you add a Matching Document Number (DOCM) to the F0411Z1 data. This process will create the voucher and associated payment in the F0413 and F0414 tables.