This chapter contains these topics:
From Accounts Payable (G04), enter 27
From A/P Advanced and Technical Operations (G0431), choose Positive Pay Processing
From Positive Pay Processing (G04312), choose the appropriate selection
Managing check fraud risk and reducing exposure to fraud is increasingly important to today's finance managers. Financial institutions have a variety of Positive Pay file formats. The JD Edwards World Positive Pay file is a generic file that should meet basic requirements for financial institutions. The file contains information such as payment number, payment date, payment amount, payee and other pertinent information. When a payment is presented to your bank, the bank reviews your Positive Pay transmissions to see if the payment is valid. A payment will only be honored if the Positive Pay transmission matches the payment details.
The Positive Pay Workfile Build (P04585) will create records in the Positive Pay Workfile (F0458). The DREAM Writer is based on the A/P Matching Document Header file (F0413) and uses the Data Selection to determine which records to update to the Positive Pay Workfile. For example, you may want to select records for a particular bank account or range of payment numbers.
The information in the F0458 will be updated based on information from the A/P Matching Document Header file and the Bank Transit Number Master File (F0030). These records will be written as unprocessed by having both the Generic Flag (GFL1) and Member ID (MID) set to blank. The Generic Flag (GLF1) represents whether the record has been processed to the AP Bank tape file or not. The Member ID represents the Bank Tape Member ID which will link the F0458 record to the record created in the AP Bank Tape File (F04581).
The Positive Pay Workfile Build will determine whether a record will be written or updated to the F0458 file. The following criteria will be used to process records to the F0458.
If payment is not in F0458, write a new record to the F0458.
If a new payment and it is not voided, write a new record to the F0458.
If payment record has been updated in the F0413 and a corresponding record does exist in the F0458 but the record has not been processed, then the existing record is deleted and rewritten to the F0458.
If payment is in the F0458 and has been updated as processed, the record is skipped and that record will not be updated.
If payment has been voided and exists in the F0458 but has not been updated as processed, then delete the record from the F0458.
If payment has been voided and exists in the F0458 and has already been updated as processed, then skip the record in the F0458.
P04586 will read the work file for unprocessed records and will create the F04581/specific member with the data for the bank and update the Positive Pay Workfile (F0458) detail records as having been sent (GFL1 = 1). The Positive Pay Workfile detail record will also be updated with the new member ID. A report will be produced displaying the data in the file and the newly created F04581 member will appear in the heading.
Set the processing option according to your needs and to enter bank tape information.
The tape files created on disk are maintained in the A/P Payments Tape file (F04581). All tapes on disk may be reviewed and copied to magnetic tape or diskette through the Copy to Tape program (P0457).
Once the specific member ID is located, open the Detail area (F4) to make sure all tape parameters have been updated properly. Once you are ready to process the member to tape, use the Copy option (3) next to the member record. Once the copy is successful, use the Delete option (9) to delete this member and prevent duplicate processing.
Version ZJDE0045 of the P00PURGE program has been established to allow users to purge processed positive pay member records from the work file F0458. The DREAM Writer data selection has been set up to purge only processed items. You may want to further narrow the purge options to Bank Transit number and/or Bank Account.
Processing options are provided to store the purged records on disk in a new physical file in a special purge library, and/or reorganize the file following the purge process.
The Positive Pay file format consists of a header record, detail record and a trailer. The following file field description will list the field description, field name, position in which the field will be contained, and the field definition for the AP Positive Pay Tape file (F04581). This file field description can be found in the source code within Positive Pay Create Bank File (P04586).
Field Description - Header Record | Field Name | Position | Field Definition |
---|---|---|---|
Record Type Code | B1RT | 1-1 | The value in this record will have a 1 to signify the header record. |
Bank Number - House Bank | B1TNST | 2-21 | The RMGLBA from the F0413 will be the payor bank account. This bank account will be used to track down the TNST field in the Bank Transit Number Master File (F0030) |
Company | B1CO | 22-26 | This value is the payor's bank account company. The RMGLBA's company number (GMCO) from the GL Bank Account number will be updated to B1CO |
Company Name | B1CN | 27-56 | The bank account company's name is retrieved from the Company Constants (F0010). The field CCNAME will be used to populate B1CN. |
Extract Creation Date | B1DATE | 57-62 | The current system date |
Extract Creation Time | B1TIME | 63-68 | The current system time |
Filler | B1FILL | 69-100 | Blanks will complete the record |
Field Description - Detail Record | Field Name | Position | Field Definition |
---|---|---|---|
Record Type Code | B2RT | 1-1 | The value in this record will have a 2 to signify the detail record |
Bank Account to be Debited | B2CBNK | 2-21 | CBNK is the account number derived from the Bank Transit Number Master File (F0030). This will be the payor's bank account |
Check Number | B2DOCM | 22-29 | Payment Number |
Payee Number | B2PYE | 30-37 | Payee Number |
Payee Name | B2PN | 38-67 | The payee name retrieved from the address book field ABALPH |
Payment Amount | B2PAAP | 68-82 | Payment Amount |
Payment Currency | B2CRCD | 83-85 | Currency Code value of the payment |
Payment Date | B2DMTJ | 86-91 | Payment Date |
Filler | B2FILL | 92-100 | Blanks will complete the record |
Field Description - Trailer Record | Field Name | Position | Field Definition |
---|---|---|---|
Record Type Code | B3RT | 1-1 | The value in this record will have a 3 to signify the trailer record |
Bank Number of House Bank | B3TNST | 2-21 | TNST is the transit number derived from the Bank Transit Number Master File (F0030). This will be the payor's bank account. |
Total Number of Payments | B3TNO | 22-36 | Total number of payments |
Hash Total of Payments | B3HASH | 37-51 | Total amount of payments |
Filler | B3FILL | 52-100 | Blanks will complete the record |
See Also:
POOPURGE – Generic Purge Program