This chapter provides an overview of banking and recipient processing and discusses how to:
Manage the Malaysian banking process flow.
Create electronic funds transfer (EFT) files.
Generate recipient payment report files.
Report net payment.
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
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:
Run an EFT file creation process to generate a file that includes employee salaries (net payments) and recipient payments.
Net amount and recipient payments are calculated by the core banking process and stored in the GP PAYMENT result table.
Generate data for the purpose of delivering deduction details to the recipient.
The program extracts payment information directly from the GP PAYMENT result table to create the MAYB and RHB files.
Select whether to have the system deduct commissions from the recipient payment.
Generate a report containing information on amounts that are transferred to employee accounts (the Net Payment report) and another report containing details of amounts that are collected from employees on behalf of a recipient (the Recipient report).
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:
Bank IDs must be four numeric characters, and the bank must appear in the Bank table (BANK_EC_TBL).
Branch codes must be three numeric characters.
They are validated against the Bank Branch table (BANK_BRANCH_TBL).
Bank account numbers must be no more than 11 numeric characters, and no validation occurs.
See Also
Setting Up Banking and Recipient Processing
Generating Recipient Payment Report Files
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:
Run the payroll process by using Global Payroll.
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.
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:
Payment status: finalized.
Payment type: net pay distribution.
Payment method: bank transfer.
Currency code: MYR (Malaysian Ringgits).
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
Setting Up Banking and Recipient Processing
Generating Recipient Payment Report Files
This section provides an overview of EFT files and discusses how to create 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:
Net pay only.
Recipient payments only.
Net pay and recipient payments.
See Also
Setting Up Banking and Recipient Processing
Generating Recipient Payment Report 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. |
This section provides an overview of recipient payment report files and discusses how to generate the recipient payment electronic files and reports.
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
Setting Up Banking and Recipient Processing
Page Name |
Definition Name |
Navigation |
Usage |
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. |
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. |
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
Setting Up Banking and Recipient Processing
Generating Recipient Payment Report Files
Page Name |
Definition Name |
Navigation |
Usage |
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. |