Running Banking and Recipient Processes

This chapter provides an overview of banking and recipient processing and discusses how to:

Note. The PeopleSoft system delivers a query that you can run to view the names of all delivered elements designed for Malaysia. Instructions for running the query are provided in the PeopleSoft Global Payroll PeopleBook.

See Also

Understanding How to View Delivered Elements

Click to jump to parent topicUnderstanding Banking and Recipient Processing

Global Payroll for Malaysia supports net payment (employee salary) direct deposits and recipient payments by using an electronic file format (MAYB or RHB). Banking and recipient processing functionality enables you to:

Note. In this section, a provider and a recipient are the same thing, unless otherwise noted.

Bank Accounts

The following validation occurs when you are adding bank accounts for Malaysia:

See Also

Defining Banking Instructions

Setting Up Banking and Recipient Processing

Creating EFT Files

Generating Recipient Payment Report Files

Managing Off Cycle Processing

Click to jump to parent topicManaging the Banking Process Flow

The banking process of Global Payroll combines payroll data, pay entity source bank data, and payee or recipient bank data. The EFT file creation process extracts data that the banking process compiles according to the type of EFT file that you are creating, merges it with data that the Malaysia country extension provides, and creates the file for transmission.

To manage the banking process with Global Payroll:

  1. Run the payroll process by using Global Payroll.

  2. Run the Global Payroll banking process.

    The core prepayment banking process calculates net amounts and recipient payments and stores them in the GP PAYMENT result table. The Global Payroll status is set to Prepared. The GP PAYMENT result table contains one entry for every net pay distribution from every payment that is included in a calendar run and provides the basis on which an organization pays its payees.

  3. Using Global Payroll for Malaysia, run the Create EFT Payment File MYS Application Engine process (GPMY_EFT_FIL), which populates the file that is used for electronic fund transfer.

    In this step, the system selects payees from GP PAYMENT with the following parameters:

Note. The source bank in the GP_PAYMENT rows that are selected must have May Bank Malaysia or Rashid Hussein Bank as its EFT domestic. Otherwise, those GP_PAYMENT rows are not selected (even though the criteria in the four preceding bullet points are met).

The payment status for the selected payees is set to Transferred in GP PAYMENT.

Note. You must run the banking process before the Bank file generation process.

This diagram illustrates the process flow for banking and recipient processing:

Malaysian banking and recipient processing flow

See Also

Defining Banking Instructions

Setting Up Banking and Recipient Processing

Creating EFT Files

Generating Recipient Payment Report Files

Managing Off Cycle Processing

Click to jump to parent topicCreating EFT Files

This section provides an overview of EFT files and discusses how to create EFT files.

Click to jump to top of pageClick to jump to parent topicUnderstanding EFT Files

The system creates the Malaysia standard MAYH deposit file by using a process that gives you multiple options that control the contents of the file. The process creates a separate MAYH file for each source bank account that is referenced in the processing. The options for the content of a file are:

See Also

Defining Banking Instructions

Setting Up Banking and Recipient Processing

Generating Recipient Payment Report Files

Click to jump to top of pageClick to jump to parent topicPage Used to Create EFT Files

Page Name

Definition Name

Navigation

Usage

Create EFT Payment File MYS (create electronic funds transfer file MYS)

GPMY_EFT_FILE_RC

Global Payroll & Absence Mgmt, Payment Processing, Create EFT Payment File MYS, Create EFT Payment File MYS

Create EFT files. Enter the parameters for the electronic file creation.

Click to jump to top of pageClick to jump to parent topicCreating EFT Files

Access the Create EFT Payment File MYS page (Global Payroll & Absence Mgmt, Payment Processing, Create EFT Payment File MYS, Create EFT Payment File MYS).

An application engine process extracts the salary data from the GP_PAYMENT table and creates the EFT file for transmission to the bank. You can create files for net pay only, recipient payments only, both net pay and recipient payments, or specific deductions.

Note. You must prepare and finalize the banking process (GP_PMT_PREPARE) before you can create the MAYB file. When the MAYB file is created, the system changes the payment status in GP_PAYMENT from F (finalized) to T (transferred).

Payment Type

Select from Net Pay Distributions Only, Net Pay and Recipients, or Recipient Deductions Only.

The EFT file that the system creates contains data that is only for payments of the type that you specify.

Deposit Date

Enter the date of the actual transfer of funds and the date that they are deposited with the bank. This value is normally the same as the payment date that is on the pay calendar, but you can change it if the payment date is not a business date. The date cannot be in the past.

Net Pay Distributions

Calendar Group ID

Enter the ID for the calendar group for which you want the system to extract payee net pay data. You can select only calendars for which the banking process is finalized. You do not need a calendar group ID for the payment type recipient deductions only.

Recipient Payments

Pay Entity

When you set up deduction recipient data, specify a pay entity as part of the payment details. In the details, you specify commission details and the group number.

Debit Date

The system extracts recipient payments if the debit date is equal to the recipient's deposit schedule. If the recipient does not have a deposit schedule, the system extracts payments by using the debit date without reference to a deposit schedule. The date appears in the file header.

EFT Format Domestic

Select either MAYB (May Bank - Malaysia) or RHB (Rashid Hussein Bank).

Recipient Selection, Deduction, and Recipient ID

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 that you make in the Deduction field.

Selected Recipients: Payments for all deductions for the recipients that you select in the Recipient ID field.

Click to jump to parent topicGenerating Recipient Payment Report Files

This section provides an overview of recipient payment report files and discusses how to generate the recipient payment electronic files and reports.

Click to jump to top of pageClick to jump to parent topicUnderstanding Recipient Payment Report Files

Organizations commonly transmit files to recipients so that 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 that they want and the report file layout. After you create the file layout, link it to a recipient on the Deduction Recipient page.

The layout GPMY_RCPNT_FILE provides a sample file layout. The GPMY_RCPFILE Application Engine process gets the file layout, which is stored on the Deduction Recipient page.

Note. This electronic file depends upon first running the GPMY_EFT_FIL Application Engine process for all recipients.

See Also

Defining Banking Instructions

Setting Up Banking and Recipient Processing

Creating EFT Files

Managing Off Cycle Processing

Click to jump to top of pageClick to jump to parent topicPage Used to Generate Recipient Payment Report Files

Page Name

Definition Name

Navigation

Usage

Create Recipient File MYS

GPMY_RUNCTL_RCP_FL

Global Payroll & Absence Mgmt, Payment Processing, Create Recipient File MYS, Create Recipient File MYS

Generate the recipient payment electronic files and reports.

Click to jump to top of pageClick to jump to parent topicGenerating Recipient Payment Electronic Files and Reports

Access the Create Recipient File MYS page (Global Payroll & Absence Mgmt, Payment Processing, Create Recipient File MYS, Create Recipient File MYS).

Debit Date

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

Payment Date

This is the date, from the file header, on which the bank passes the payment to the recipient.

Recipient Selection and Deduction

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

Click to jump to parent topicReporting Net Payment

This section lists the page used to report net payment.

The Net Payment report (GPMYPY51.SQR) is a list of all the net payments that the core Global Payroll core banking process generates. You enter the calendar group ID that you want to report on and specify whether you want payee-level detail or merely a summary.

The Net Payment report extracts data from the EFT File Transactions, Header, Personal Data, and Job tables.

Choose detail or summary reporting.

Detail Reporting

The following table provides an example of the data that appears in the Detail report:

Employee ID

Empl#

Name

Pay Date

Pay Amount

KM001

0

John Lee

01/01/2001

5000

KM002

0

Susan Fong

01/01/2001

4500

Total Records

2

     

Total Credit

9500

     

Total Debit

9500

     

Summary Reporting

The following table provides an example of the data that appears in the Summary report:

 

Total Records

Total Credit

9500

Total Debit

9500

See Also

Defining Banking Instructions

Setting Up Banking and Recipient Processing

Creating EFT Files

Generating Recipient Payment Report Files

Click to jump to top of pageClick to jump to parent topicPage Used to Report Net Payment

Page Name

Definition Name

Navigation

Usage

Net Payment Report MYS

GPMY_NET_PAY_RC

Global Payroll & Absence Mgmt, Payment Processing, Net Payment Report MYS, Net Payment Report MYS

Generate and print a net payment report.