Managing EFTs
This section discusses how to create the EFT MT9 file.
The system creates the New Zealand standard MT9 deposits file using a process that gives you multiple options that control what the file contains. The process creates a separate MT9 file for each source bank account referenced in the processing. The files are named EFTxx999 where xx is the 2 digit bank ID and 999 is a sequence number.
Note: You must have prepared or finalized your banking process (GP_PMT_PREPARE) before you can create the MT9. Once the MT9 file is created, the system changes PMT_STATUS on GP_PAYMENT from either (P) Prepared or F (Finalized) to T (Transferred).
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
GPNZ_EFT_MT9_RC |
Enter the parameters for the electronic file creation |
Use the Create EFT Payment File NZL page (GPNZ_EFT_MT9_RC) to enter the parameters for the electronic file creation.
Navigation:
An Application Engine program, GPNZ_EFT_MT9, extracts the salary data from the Payroll Results Table and creates the MT9 file for transmission to the bank. You can create files for net pay only, recipient payments only, both net pay and recipient pay, or for specific deductions.
This example illustrates the fields and controls on the Create EFT Payment File NZL page. You can find definitions for the fields and controls later on this page.
Field or Control |
Description |
|---|---|
Payment Type |
Select from Net Pay Distributions Only, Net Pay and Recipients or Deduction Recipients Only. The EFT the system creates contains data only for payments of the type specified. |
Deposit Date |
This is the date of the actual transfer of funds and the date they are deposited with the bank. The date is written to the MT9 header. It is normally the same as the payment date on the pay calendar but you may need to change it if the payment date is not a business date. The date cannot be in the past. |
Net Payment Distributions
Field or Control |
Description |
|---|---|
Calendar Group ID |
Enter the ID for the calendar group for which you want the system to extract payee net pay data. You can only select calendars for which the banking process is prepared or finalized. You do not need a calendar group ID for the Recipient Deductions Only payment type. |
Recipient Payments
Field or Control |
Description |
|---|---|
Pay Entity |
When you set up deduction recipient data, you specify a pay entity as part of the payment details. It is where you specify commission details and your Group Number. You do not need a pay entity for net pay distributions only. |
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 extracts payments using the debit date without reference to a deposit schedule. |
Recipient Selection |
The system includes payments according to these rules (and according to the debit date and its rules): All Recipients: Payments for all deductions for all recipients according to the debit date rules. Selected Deduction: Payments for all recipients for the (single) selection you make in the Deduction field Selected Recipients: Payments for all deductions for the recipients you select in the Recipient ID field. |
Recreate |
Select to reprocess the payment records in a subsequent EFT run. The recreate process only includes payments with a status of Transferred; payments with a status of Finalized are not included. |