Generating Recipient Payment Report Files

It is common for organizations to transmit a file to a recipient so they can update their records. For example, an organization may pay a recipient weekly and at the end of the month deliver a file with all the payment details. Recipients generally specify the information they want and the report file layout. After you have created the file layout, link it to the recipient in the Deduction Recipients NZL page in Set Up HCM > Product Related > Global Payroll & Absence Mgmt > Banking > Deduction Recipients NZL.

The process creates a separate flat file for each recipient/group ID/Pay Entity/Pay Date combination. The files are named xxxxxx99. TXT where xxxxxx is the recipient ID and 99 is a sequence number.

We have supplied a sample file layout, GPNZ_RCPNT_FILE. Application Engine program GPNZ_RCPFILE gets the file layout which is stored on the Deduction Recipients NZL page.

Note: The Application Engine program GPNZ_RCPFILE is written to process only the GPNZ_RCPNT_FILE recipient schedule file. You can make minor changes to that file, for example field order, but if you make major file layout changes you will need to create additional Application Engine programs to process them.

This example illustrates a sample recipient file layout.

 Sample recipient file layout

Note: This electronic file depends on the prior running of Application Engine program GPNZ_EFT_MT9 for recipients.

Page Name

Definition Name

Usage

Create Recipient File NZL Page

GPNZ_RUNCTL_RCP_FL

Enter the parameters for generating recipient payment files.

Use the Create Recipient File NZL page (GPNZ_RUNCTL_RCP_FL) to enter the parameters for generating recipient payment files.

Navigation:

Global Payroll & Absence Mgmt > Payment Processing > Create Recipient File NZL > Create Recipient File NZL

This example illustrates the fields and controls on the Create Recipient File NZL page. You can find definitions for the fields and controls later on this page.

 Create Recipient File NZL page

Field or Control

Description

Debit Date

The system extracts recipient payments where the debit date is equal to the recipient's deposit schedule. If the recipient does not have a deposit schedule the system exacts payments using the debit date without reference to a deposit schedule.

Payment Date

This is the date, passed to the file header, that the bank passed the payment to the recipient. It is written to the output report file.

Recipient Selection

Select from All Recipients, Selected Deduction, or Selected Recipients. You select only one deduction but multiple recipients for the second and third options.

Note: The recipient file report GPNZPY52 is an SQR version of the data extracted for the electronic recipient file. When you select to run the Create Recipient Schedule File Application Engine process in the PeopleSoft Process Scheduler Request page, you automatically get the SQR. You can then reprint the SQR later without rerunning the AE by selecting the check box and leaving the AE check box blank.