Generating the EFT Payment File and Banking Report

Page Name

Definition Name

Usage

Create EFT Payment File MEX Page

GPMX_BANK_EFT

Create an electronic flat file to be transferred (EFT) to the bank and generate a printed report.

Use the Create EFT Payment File MEX page (GPMX_BANK_EFT) to create an electronic flat file to be transferred (EFT) to the bank and generate a printed report.

Navigation:

Global Payroll & Absence Mgmt > Payment Processing > EFT Payment File MEX > Create EFT Payment File MEX

This example illustrates the fields and controls on the Create EFT Payment File MEX page. You can find definitions for the fields and controls later on this page.

 Create EFT Payment File Mex

Field or Control

Description

Calendar Group ID

Select the Calendar Group ID for which you want to generate a payment file.

Pay Entity

Select the pay entity for which you want to generate a payment file.

Pay Entity Bank Id

Select the bank by Pay Entity. Option list displays the available banks populated after running the Payment Prep Process MEX.

Bank Format

Select the bank. Values are Banamex, BBVA Bancomer, Banorte, HSBC, Scotiabank, and Santander. Depending on which bank you select, additional fields may appear on this page. Each bank may require different information about the bank file transfer. The following table lists the additional fields that appear depending on the bank format you select.

Bank Format

Additional Fields that Appear

Banamex

File Name, Payment Term, Reference Number, Bank Cust ID, Reference Number E, Message

Bancomer

File Name, Secondary Reference, Bank Cust ID, Reference Number, Operation Date

Banorte

File Name, Bank Cust ID

HSBC

File Name, Transfer Type, Batch Reference, Beneficiary Account Reference, Reference Number

Note: The Reference Number field is displayed only when Interbankis selected in the Transfer Type field.

Scotiabank

File Name, Bank Cust ID, Reference Number C, Reference Number D, Message

Santander

File Name, Transfer Type, Reference Number

Note: The Reference Numberfield is displayed only when Interbankis selected in the Transfer Type field.

Note: Once the GP_PAYMENT table and the GPMX_PAYMENT table are populated, you can launch an SQR that generates the flat file for banking along with a printed report of payment details.