| Purpose |
| Questions and Answers |
| General/Setup Questions |
| Question 1: Where is the flat file for Retrieving Positive Pay Text File Processor (P007101) on the Web? |
| Question 2: Can the text file format be modified? |
| Question 3: Is it possible to change the default setting for the path for P007101 Text File Processing which currently is set to c:\default.txt, is this possible and if so how do I change it? |
| Question 4: Can a text batch be processed a second time? |
| Question 5: What is the functionality of the Form Exit > Import Text and Row Exit > Upload Text menu items in Text File Processor (P007101)? |
| Question 6: How can the default bank account number that is used in the Positive Pay export file be changed? |
| Question 7: Is it possible to reset the Positive Pay Flag (GFL7) in the Payment Header (F0413) after the payment has been included in a positive pay file? |
| Question 8: How to Purge both Header Records (F007101) and related Detail Records (F007111) when running Text File Processor (P007101)? |
| Troubleshooting Questions |
| Question 1: UBE R04572A3 is generating the payment file in the Text File Processor tables. When copying to a text file the P007101 is inserting a carriage return after each line, why? |
| Question 2: When generating the Positive Pay file on IBM iSeries, why does the text file contain garbage characters? |
This document discusses frequently asked questions regarding the text file processor (P007101).
Answer 1: The location of the flat file is relative to where the business function is running. For HTML, you must point to the enterprise server. You should test with the simplest text path and name like "outbound". Then, search for the file on the enterprise server to figure out the default location. It is easier if you save the file to a standard location like \\denxpi7\DV9export. If you have tight controls on accessing the server, create a shared folder just for text file purposes and make sure you watch out for the file extension. There can also be security on a folder; in other words, just because you can write to a folder, does not mean that you can retrieve it.
Answer 2: Unfortunately the text file is standard format. Client would need to modify/customize the text file to meet their bank's specific needs/requirements.
Answer 3: Yes this is hard-coded and changing it is considered customization. Unfortunately GCS would not be able to support these changes at this time. Work Around: P007101 form W007101A has Event Rules in the Row Exit Process Batch, Copy Text to assign a variable C:\default.txt.
Answer 4: To process a text batch a second time, the batch must be reset. Resetting a batch updates the status flags in the Text Processor Header table (F007101). The system changes outbound statuses to blank (Unprocessed/Outbound) and changes inbound statuses to 5 (Unprocessed/Inbound). The steps to reset a batch are:
Answer 5: The Import Text form exit is used to create a batch in the Text Processor Header table (F007101) and the text Processor Detail Table (F007111). To move the information from the Text Processor Header (F007101) and Detail (F007111) tables into other tables in JD Edwards Enterprise One, a batch program that has been designed to retrieve data from these tables must be run.
On the other hand, the Upload Text Row Exit calls the batch program that moves the data from the Text Process tables to other tables. When this menu item is selected, the system requests for the Program ID to be used to take data from the Text Processor Header table (F007101) and the text Processor Detail Table (F007111) and move to other tables of JD Edwards EnterpriseOne. Some possible UBEs used are Upload ESR Payments (R03B803) and Initial Loading Master (R76B4103). The grid record must be in status ‘5’(Unprocessed/Inbound) to be able to execute an Upload Text program.
Answer 6: The bank account numbers that are used for the Positive Pay file, are the ones set up in G/L Bank Accounts (P0030G) for the G/L bank accounts out of which the payments are made to the suppliers. If the bank account in the Positive Pay file is incorrect, please verify the P0030G setup for the bank account(s) in question.
Answer 7: There is currently no way to reset the Positive Pay Flag (GFL7) in the Payment Header (F0413) within EnterpriseOne.
Answer 8: The purge application calls the UBE Purge Processed Transactions(R007102 version ZJDE0001). The Processing Option 1.Purge Header Records needs to be set to ‘1’ = Delete Header Records. This will purge both the Header and related Detail records.
Answer 9: The P007101 calls business functions B0001002 or B7001002 (for some files created for localization features). One way to achieve this is using an additional non AS400 Enterprise Server. In order to generate the files on another machine in the network one needs to add OCMs to have B0001002 and/or B7001002 run on the non AS400 server. And then use a path format that is valid for the Operating system of the additional Enterprise Server.
Answer 1: When copying to a text file the P007101, UDC 00/TP (Tex File Processor Delimiters) is used in conjunction with the URC1 field in the F007111 to determine the delimiter used between records. Description01 in the UDC determines the suffix of a record. Description02 determines the prefix of a record. The R04572A3 uses value NCR from this UDC. If it does not exist, add the following values:
Answer 8: It is possible the settings for this text file processor are incorrect in Work with Flat File Encoding application (P93081). You will need to 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:
System code page: cmd: WRKSYSVAL QCCSID
User profile can override system value: cmd: DSPUSRPRF <user>
For example: cmd: DSPUSRPRF JDE Page down 3 times Display User Profile - Basic
Use this Code Page value to set up the correct Flat File Encoding page in the Work with Flat File Encoding application (P93081). For example if CCID is 37, set the Work with Flat File Encoding application (P93081) to IBM37.