EAP: Enhancement to have the Option to control the creation of 627 or 637 Offset Line in EFT PPD Payment File (Doc ID 1422783.1)

Last updated on JUNE 08, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

When creating EFT files using the PPD layout, an offset line starting with 627 or 637 is populated in the payment output file. This offset record is created to balance the entries in the file.

Line 627 is generated when all vendors have Checking accounts, like:
622012345672012345672 0000100000USA0000001 xxx xxxx Electric- 0012345670000001
622012345672012345672 0000100000USA0000003 Telecomm for xxxxx xxx 0012345670000002
6271210428820741-256458 0000200000 US001 xxx xxx xxxxxx 0121042880000003

or when the first vendor has a Savings account and the second vendor has a Checking account, like:
632012345672012345672 0000100000USA0000001 xxx xxxx Electric- 0012345670000001
622012345672012345672 0000100000USA0000003 Telecomm for xxxxx xxx 0012345670000002
6271210428820741-256458 0000200000 US001 xxx xxx xxxxxx 0121042880000003

Line 637 is generated when the first vendor has a Checking account and the second vendor has a Savings account, like:
622012345672012345672 0000100000USA0000001 xxx xxxx Electric- 0012345670000001
632012345672012345672 0000100000USA0000003 Telecomm for xxxxx xxx 0012345670000002
6371210428820741-256458 0000200000 US001 xxx xxx xxxxxx0121042880000003

Some banks do not expect nor want this offset record, so it has to be manually removed before sending the file to the bank.

Request an option to turn on or off the creation of the Offset line.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms