My Oracle Support Banner

E1: 04: Create A/P Bank Tape - PPD Format (R04572T1) Incorrectly Leaves Record 6 Field 4, Check Digit, (Pos. 12) Blank Even if the Bank Transit field (TNST) Has a 9-Digit Number. (Doc ID 2880233.1)

Last updated on JUNE 30, 2022

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Create A/P Bank Tape - PPD Format (R04572T1) incorrectly leaves Record 6 field 4, Check Digit, (pos. 12) blank even if the Bank Transit field (TNST) has a 9-digit number. If the TNST field has a 9-digit number, then R04572T1 should use the 9th digit as the Check Digit in position 12 of Record 6.

If the TNST field only has an 8-digit number, but the Check Digit field (CHKD) has a value in it, then the value of the CHKD field should be used.

The Record 6 field 4, Check Digit, (pos. 12), should only be blank if the TNST has 8 digits and the CHKD is blank.

See also Nacha’s ISO 20022-to-ACH Mapping Guide & Tool on the ISO 20022 page on NACHA’s website. This was last updated on December 2021.

STEPS TO REPRODUCE

  1. P0030G: set up GL bank account
  2. AAI: set up PB AAI to point to this GL bank account
  3. Batch Versions: set up a version for R04572T1 - PPD format, and submit its version specs
  4. P0417: set up the payment instrument for PPD to point to this R04572T1 version
  5. P04012: set up three suppliers with this payment instrument as the default, and uncheck the pre-note code field
  6. P0030A: set up a bank account for the suppliers:
    1. Supplier 1:
      1. Make sure that the Bank Transit Number only has 8 digits
      2. Make sure that there IS a value in the Control Digit field
    2. Supplier 2:
      1. Make sure that the Bank Transit Number has 9 digits
      2. Make sure that there is NO value in the Control Digit field
    3. Supplier 1:
      1. Make sure that the Bank Transit Number only has 8 digits
      2. Make sure that there is NO value in the Control Digit field
  7. P0411: create a voucher for each supplier and post them
  8. Run R04570 for the suppliers
  9. P04571: inquire on the payment group created and write it
  10. P0457: create a text file for the payment
  11. Verify the values, if any, in the Records 6 for position 12 to 12 of the text file that was created

DESIRED OUTCOME

R04572T1 should check both the 9th character of the TNST field and the CHKD field and use either of the values in these fields if only one is present (whichever one is present). If both are present, then the CHKD value should have priority.

  

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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