Running Banking and Recipient Processes

Managing the Singapore Banking Process Flow

The banking process of Global Payroll brings together payroll data, pay entity source bank data, and payee or recipient bank data. The EFT file creation process extracts data compiled by the banking process according to the type of EFT file that you are creating, merges it with data provided by the Singapore country extension and creates the file for transmission.

Global Payroll manages the banking process as follows:

Run the payroll process using Global Payroll.

This provides the payment data for the banking process.
Run the Global Payroll banking process.

Net amounts and recipient payments are calculated by the core prepayment banking process and stored in the GP PAYMENT result table. The GP status is set to P(prepared). The GP PAYMENT result table contains one entry for every net pay distribution from every payment included in a calendar run and provides the basis on which an organization pays its payees.
Using Global Payroll for Singapore, run the Create EFT Payment File SGP process (Application Engine process GPSG_EFT_GIR), which populates the GIRO file used for electronic fund transfer.

In this step, the system selects payees from GP PAYMENT with the following parameters:
- Payment status: F (finalised).
- Payment type: 01 (net pay distribution).
- Payment method: T (bank transfer).
- Currency code: SGP.
  
  Note. The Source Bank in the GP_PAYMENT rows selected must have 'GIRO' as its EFT Domestic otherwise those GP_PAYMENT rows will not be selected (even though it satisfies the 4 previous bullet points.

The payment status for the selected payees is set to T (transferred) in GP PAYMENT.

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

The following diagram shows the process flow for banking and recipient processing:

Banking and Recipient Processing

See Also

Managing Electronic Fund Transfers

This section provides an overview of electronic fund transfers, and discusses how to create an electronic fund transfer file.

Understanding Electronic Fund Transfer

The system creates the Singapore standard GIRO deposits file using a process that gives you multiple options that control what the file contains. The process creates a separate GIRO file for each source bank account referenced in the processing. The files are named EFTxxxx999.GIR where xx is the 4 digit bank ID and 999 is a sequence number. Your options for the content of a file are:

Net pay only.
Recipient payments only.
Net pay and recipient payments.

Note. You must have prepared or finalized your banking process (GP_PMT_PREPARE) before you can create the GIRO file. After the GIRO file is created, the system changes PMT_STATUS on GP_PAYMENT from F (Finalized) to T (Transferred).

An Application Engine program, GPSG_EFT_GIR , extracts the salary data from the GP_PAYMENT table and creates the GIRO 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.

See Also

Page Used to Create the GIRO File

Page Name	Object Name	Navigation	Usage
Electronic Funds Transfer	GPSG_EFT_GIRO_RC	Global Payroll and Absence Mgmt, Payment Processing, Create EFT Payment File SGP	Enter the parameters for the electronic file creation.

Creating the Electronic Funds Transfer (EFT) GIRO File

Access the Electronic Funds Transfer page.

Payment Type

Select from Net Pay Distributions Only, Net Pay and Recipients or Recipient Deductions 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 GIRO 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 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 only select calendars for which the banking process is finalized. You do not need a Calendar Group ID for the Recipient Deductions Only payment type.

Recipient Payments

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 recipients 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 / Deduction

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.

See Also

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

Understanding 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 Recipient page.

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, GPSG_RCPNT_FILE. Application Engine, GPSG_RCPFILE, gets the file layout which is stored on the Deduction Recipient page.

Note. This electronic file depends upon the prior running of Application Engine, GPSG_EFT_GIR for recipients.

See Also

Page Used to Create Recipient Payment Electronic Files and Reports

Page Name	Object Name	Navigation	Usage
Recipient File - Electronicl	GPSG_RUNCTL_RCP_FL	Global Payroll and Absence Mgmt, Payment Processing, Create Recipient File SGP	Enter the parameters for generating recipient payment files.

Creating the Recipient Payment Electronic Files and Reports

Access the Recipient File - Electronicl page.

Debit Date

The system extracts recipient payments where the debit date is equal to the recipients 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.

Payment Date

This the date, passed to the file header, that the bank passed the payment to the recipient.

Recipient Selection / Deduction

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

Reporting Net Payment

This section provides an overview of reporting net payment, and discusses how to view the Net Payment Report.

Understanding Net Payment Reports

The Net Payment Report, GPSGPY51 SQR is a listing of all the net payments generated by the core Global Payroll core banking process. You enter the calendar group ID you want to report on and specify if you want payee level detail or just a summary.

The Net Payment Report extracts data from the GIRO Transaction Table, the Header Table, from Personal Data, and from Job.

See Also