Generating Banking EFT Files and Report
This section provides overviews of the EFT process flow and processing steps and lists a prerequisite.
Page Name |
Definition Name |
Usage |
---|---|---|
GPJP_RC_BA02 |
Run a process to create a payment file that contains banking details. |
|
File Handles JPN Page |
GPJP_FILE_HANDL |
Assign a handle to each file that you want to export. |
GPJP_RC_BA01 |
Create EFT payment file. Run the EFT process, which prepares the EFT flat file that you transmit to the appropriate bank and launches the SQR program that prints the Banking report (GPJPBA01). |
This diagram illustrates the payroll EFT process flow for Japan, which includes descriptions of each step from the finalization of payroll to the printing of reports or the creation of a flat output file:
Payroll EFT process flow for Japan, including descriptions of each step to either print a report of the final payment or create a flat output file.
![Payroll EFT process flow for Japan, including descriptions of each step to either print a report of the final payment or create a flat output file.](img/i-cd7d26dn-71ca.png)
The steps in this section correspond to the numbers in the preceding diagram:
Process payroll in the Global Payroll core application.
Run the Global Payroll for Japan banking process.
This process populates the GP_PAYMENT output record.
Note: Select the Finalize check box on the Banking Run Control page when you run the Banking process. If you do not, there won't be any data available for the next step.
Run the Global Payroll for Japan EFT process (GPJP_BA01_AE).
This process selects all rows in GP_PAYMENT that have a status of Finalized for the specified calendar group ID, run type name, and source bank ID.
The process populates the following records, which form the header, transaction, and trailer of both the EFT file and the printed report:
GPJP_BA_HEADER: The data in this record comes from the run control parameters that you enter on the EFT page.
It identifies the company and the source bank account information.
GPJP_BA_TRANS: The data in this record comes from GP_PAYMENT and from the source and transfer bank data that you set up previously.
It details the employee information, the transfer bank account information, and the amount of the transfer.
GPJP_BA_TRAILER: This record stores totals, such as the number of records in the TRANS record and the total amount of money being transferred.
The process changes the status of rows in GP_PAYMENT from Finalized to Transferred.
The EFT process consolidates the data from the three records into one EFT file that you send to the source bank.
It uses the file name and character set from the File Handles JPN page.
The EFT process launches the SQR program (GPJPBA01 SQR).
The SQR program prints the Banking report in the standard character set by using data from the same three records as the EFT file.
You must set up file handles on the File Handles JPN page before you can run the EFT process. The file handle looks up the file name and character set (single-byte Katakana) that is used to generate the file.
Use the Run Banking Process JPN page (GPJP_RC_BA02) to run a process to create a payment file that contains banking details.
Navigation:
This example illustrates the fields and controls on the Run Banking Process JPN page. You can find definitions for the fields and controls later on this page.
![Run Banking Process JPN page](img/i-cd7d26dn-71de.png)
Field or Control |
Description |
---|---|
Calendar Group |
Select a calendar group for which to run the process. The system processes any items (segments) that are approved or finalized by the payroll process. |
Stream Number |
If the Process Streams check box is selected, and you select Calculate in the Processing Options group box, you must select the stream number to process. Each stream number represents a predefined range of payees. |
Process Streams |
The Process Streams check box is selected automatically if you selected the stream processing option when defining the calendar group. |
Processing Options
Field or Control |
Description |
---|---|
Calculate |
Select to have the system create the payment file by matching the approved and finalized results from the payroll process with information that you defined in banking setup. You can run the calculate step repeatedly until you finalize the banking process. |
Finalize |
Select, after everything is calculated. (If you use stream processing for the Calculate phase, the system finalizes all streams for the calendar group simultaneously.) Note: If you're not using streams, you can select Calculate and Finalize at the same time. |
Update Statistics |
Select to have the banking system generate statistics to help the data administrator fine-tune system performance. |
Streams
This group box displays all streams that are associated with the calendar group.
Calendars in Run
After you run the Calculate phase, this group box displays information for each calendar in the calendar run.
Use the Create EFT Payment File JPN (create electronic funds transfer payment file Japan) page (GPJP_RC_BA01) to create EFT payment file.
Run the EFT process, which prepares the EFT flat file that you transmit to the appropriate bank and launches the SQR program that prints the Banking report (GPJPBA01).
Navigation:
This example illustrates the fields and controls on the Create EFT Payment File JPN page. You can find definitions for the fields and controls later on this page.
![Create EFT Payment File JPN page](img/i-cd7d26dn-71e8.png)
All of the fields on this page are required to run the process.
Field or Control |
Description |
---|---|
Calendar Group ID |
The EFT process uses the values that you select in the Calendar Group ID, Run Type Name, and Source Bank ID fields to extract the appropriate information from the GP_PAYMENT table. |
File Handle |
The file handle set up on the File Handles JPN page that identifies the file name and character set used in this process. |
Payment Type |
Valid values are Salary and Bonus. This data appears in the header of the EFT file. |
Deposit Date |
This date appears in the header of the EFT file. |