This chapter contains these topics:
Payments are the forms employees receive when they get paid. You can set up employees to receive any of the following types of payments:
Employees who are set up to receive different types of payments can be included in the same payroll ID. For example, a payroll ID might include some employees who are paid by cheque and some who are paid by automatic deposit.
After you process pre-payroll, you can print payments for employees.
During the print process, the payroll system generates positive pay information that you can review before submitting positive pay data via an external media (tape, diskette, or CD) to financial institutions.
Following payment processing, you can create choose to reconcile computer-generated, manually generated, auto deposit, or all three types of paycheques. Create a version of the Reconcile Cheque History (P065613) program and use the first processing option to specify your paycheque reconciliation process.
The following graphic illustrates the location of the payments step in the cycle of payroll processing.
See Also:
Appendix A - Technical Overview of the Payroll Cycle in JD Edwards World Canadian Payroll II Guide for information about the tables that are affected when you print payments
Creating an Automatic Deposit Tape (P075511) in JD Edwards World Canadian Payroll II Guide
A payroll ID can include employees who are set up to receive any of the following types of payments:
Paycheques or interim cheques
Automatic deposit advice slips
Payslips
Typical tasks you perform when you print payments include:
Printing cheques or interim cheques only
Printing cheques and automatic deposits
Submitting a positive pay workfile build
Employees who are set up to receive different types of payments can be included in the same payroll ID. For example, a payroll ID might include some employees who are paid by cheque and some who are paid by autodeposit.
You use the Print Paycheques program to print all types of payments. When a payroll ID includes employees who are set up for different types of payments, the Print Paycheques program prompts you to print each type of payment.
When your payroll ID includes autodeposit employees, you must also instruct the system to generate an autodeposit external workfile, which contains the information that the bank needs to transfer funds to the employees' bank accounts. You can generate the autodeposit workfile when you print payments, or you can generate the workfile separately.
Immediately after printing all cheques, including auto deposits, you are prompted to select the Yes/No option on the Canadian Cheque Print Parameters or Canadian Interim Print Cheques Parameters screen to submit a positive pay workfile build. When transmitted to financial institutions, positive pay information can help banks prevent cheque-cashing fraud.
After you print any type of payment, and before you either continue to the next type of payment or exit the Print Paycheques program, you should inspect the payments to verify that they printed correctly. If printer problems, such as a paper jam, prevented one or more payments from printing correctly, you can reprint them.
Verify that your system timeout value is set high enough to allow enough time for all payments to print before the terminal times out
Topic | Description |
---|---|
Print Paycheques version | The version number you enter for the Print Paycheques report must match the version numbers that control other types of payments, such as automatic deposits, payslips, and attachments.
See Setting Up Payroll Cycle Reports in JD Edwards World Canadian Payroll II Guide for more information on setting up these versions. |
Reprinting payments | If you complete the Print Paycheques program and later realize that you need to reprint payments, you must reset the paycheque workfile before you can reprint the payments. |
Duplicate payment numbers | The system does not check for duplicate payment numbers because you might be using multiple bank accounts. You must track them manually. |
Attachments | The system can print only 14 lines on a pay stub. If an employee's payment needs more than 14 lines, the system prints an overflow attachment in addition to the payment. The attachment contains all remaining lines. If an employee's net pay is zero, the system prints an attachment, instead of a payment. |
Payment date | To correct a payment date, you must reset your payroll ID, change the payment dates in your pre-payroll parameters, and process the payroll cycle again. |
Printing mailing labels | When you are ready to mail cheques or other payroll-related documents, you can use the Print Mailing Labels option to print standard 4-up, or Cheshire mailing labels in a laser format.
This option prints 30 1-1/2" X 2-5/8" labels in portrait format on an 8-1/2 X 11" sheet. |
See Also:
You use the Print Paycheques program to print all types of payments. When all of the employees included in a payroll ID are paid by cheque, the Print Paycheques program prompts you to print cheques only.
On the first Canadian Cheque Print Parameters screen
Complete the following field:
Payroll ID
Choose the Submit Job function.
Figure 22-3 Canadian Cheque Print Process screen
On the first Canadian Cheque Print Parameters form, complete the following field:
Beginning Cheque Number
Choose the Submit Job function.
Figure 22-4 Canadian Cheque Print Parameters screen
On the second Canadian Cheque Print Parameters form, initiate an additional session to access the message queue.
Load the forms and verify that they are aligned properly.
Respond to the messages in the operator message queue.
Review the cheques to verify that they printed correctly.
On Canadian Cheque Print Parameters, complete the following fields:
Have All Cheques Been Printed (Y/N)?
Submit Positive Pay WF Build (Y/N)?
Enter N to correct any printer errors.
Field | Explanation |
---|---|
Beginning Cheque Number | Enter the beginning payment number for the payment run. If this is a restart, it will be a new starting payment number from the first run. |
Have ALL Cheques been Printed (Y/N)? | You must respond to the system operator's message queue before responding to this question. Enter Y if all cheques have printed correctly. Enter N if one or more cheques did not print correctly because the printer was misaligned, has jammed, or has damaged a cheque. If you enter N, the system allows you to reprint the cheques. You can reprint a single cheque, a range of cheques, or all cheques. You must manually track any unusable cheques, because the system does not write them to history. |
Submit Positive Pay WF Build (Y/N)? | Enter Y to build a positive pay workfile. : If you enter N for the Submit Positive Pay WF Build option, cheque information will not be updated to the positive pay workfile. |
The following steps apply to printing interim cheques, as well. See Section 37.1, "Printing Interim Cheques." for details.
On the first Canadian Cheque Print Parameters screen
Complete the following field:
Payroll ID
Choose the Submit Job function.
Figure 22-5 Canadian Cheque Print Parameters screen
On the first Canadian Cheque Print Parameters screen, complete the following field:
Beginning Cheque Number
Choose the Submit Job function.
On the second Canadian Cheque Print Parameters screen, initiate an additional session to access the message queue.Programs and IDs:P07230-2 (Canadian cheque print parameters)
Load the forms and verify that they are aligned properly.
Respond to the messages in the operator message queue.
Review the cheques to verify that they printed correctly.
On Canadian Cheque Print Parameters, complete the following fields:
Have All Cheques Been Printed (Y/N)
Submit Positive Pay WF Build (Y/N)
Enter N if you need to correct printer errors.
Field | Explanation |
---|---|
Beginning Cheque Number | Enter the beginning payment number for the payment run. If this is a restart, it will be a new starting payment number from the first run. |
Have ALL Cheques been Printed (Y/N)? | You must respond to the system operator's message queue before responding to this question. Enter Y if all cheques have printed correctly. Enter N if one or more cheques did not print correctly because the printer was misaligned, has jammed, or has damaged a cheque. If you enter N, the system allows you to reprint the cheques. You can reprint a single cheque, a range of cheques, or all cheques. You must manually track any unusable cheques, because the system does not write them to history. |
Submit Positive Pay WF Build (Y/N)? | Enter Y to build a positive pay workfile. : If you enter N for the Submit Positive Pay WF Build option, cheque information will not be updated to the positive pay workfile. |
From Canadian Payroll Master (G77), choose Pay Cycle Processing
From Pay Cycle Processing (G7713), choose Print Paycheques
You use the Print Paycheques program to print all types of payments. When a payroll ID includes some employees who are set up to receive cheques, and others who are set up for automatic deposit, the Print Paycheques program prompts you to print each of these types of payments separately. The program creates separate spool files for cheques, automatic deposit advice forms, payslips, and attachments.
When your payroll ID includes automatic deposit employees, you must also instruct the system to generate an automatic deposit external workfile, which contains the information that the bank needs to transfer funds to the employees' bank accounts. You use Print Paycheques to generate the automatic deposit external workfile.
You can generate the automatic deposit workfile when you print payments, or you can generate the workfile separately. You must generate the workfile before you process final update for this payroll cycle.
The automatic deposit workfile build remains on hold until you release it from the job queue. After you generate the automatic deposit workfile, you (or someone in your MIS department) must copy the workfile to an external media and send it to the bank.
The following steps describe how to create the automatic deposit workfile, as well as how to print cheques and automatic deposits.
To print cheques and automatic deposits
On the first Print Paycheques screen
Complete the following field:
Payroll ID
Choose the Submit Job function.
On the second Print Paycheques form, choose Run Auto Deposit external file create AND Net Pay Document create.
On the third Print Paycheques form, read the information and press Enter.
On the Version Selection screen, run a version.
Update the processing options.
Press Enter to submit the version.
Exit from Version Selection.
On the first Canadian Print Cheques Parameters form, complete the steps for printing cheques.
Caution:
After you complete the steps to print cheques, the system displays the Canadian Cheque Print Parameters screen again with information for automatic deposits displayed. Do not exit from the program until you print the automatic deposit forms.Complete the steps for printing automatic deposits. These steps are the same as those for printing cheques.
From the Payroll Cycle Processing Menu, use hidden selection 33 to release the automatic deposit external workfile build program (J07550) from your job queue.
Topic | Description |
---|---|
Submitting the workfile build separately for Canadian payroll | If you do not submit the external workfile build when you print your net pay documents, you must reset your cheques and run the Print Paycheques program again or submit the workfile build directly from a DREAM Writer versions list. |
From Canadian Payroll Master (G77), choose Pay Cycle Processing
From Pay Cycle Processing (G7713), choose Print Paycheques
On the second Canadian Cheque Print Parameters form
Figure 22-10 Canadian Cheque Print Parameters screen
Complete the following fields:
Void Cheque Numbers Beginning With
Ending With
Choose the Submit Job function.
Complete the steps for printing payments.
Field | Explanation |
---|---|
Void Cheque Numbers Beginning With | A range of cheque numbers may be entered to void when restarting the cheque run. The value entered in this field must be less than the beginning cheque number and represents the beginning of the range of cheque numbers to be voided. |
Ending With | A range of payment numbers may be entered to void when restarting the payment run. If this field is left blank, all payments processed after the beginning payment number will be voided. This represents the end of the range of payment numbers to be voided. |
From Canadian Payroll Master (G77), choose Pay Cycle Processing
From Pay Cycle Processing (G7713), choose Positive Pay Processing Menu
The positive pay process is initiated by selecting this option on the Canadian Cheque Print Parameters and Canadian Interim Cheque Print Parameters screens. The positive pay process is designed to help you minimize the risk of cheque-cashing fraud.
During the print payment process, you can choose to generate a positive pay workfile that contains data about every cheque printed by the payroll system. This workfile data is then used to create a bank transmittal file that can be sent to financial institutions. Banks use this information to verify the validity of cheques before they are cashed.
Tasks you perform as part of the positive pay process include:
Updating the payor bank account information, if necessary.
Submitting the positive pay workfile build process after printing cheques
Building the positive pay workfile
Generating and reviewing the positive pay workfile report
Building the positive pay bank transmittal workfile
Generating and reviewing the positive pay bank file build report
Copying positive pay bank file transmittal data to an external media
Purging the positive pay workfile
Verify that the Bank Transit Number and Bank Account information on the Bank Account Information screen (G03111/14) are correct. The positive pay workfile identifies the payor bank using the Bank Transit Number, which is located in the Bank Transit Number Master file (F0030).
When you print regular or interim payroll cheques, the system displays a Yes/No (Y/N) option to submit (build) a positive pay workfile. This option displays on the Canadian Print Cheques Parameters and Canadian Print Interim Cheques Parameters screens. When submitted, the positive pay workfile is built in a batch job from the print cheques program.
If you choose to bypass (not to submit) the positive pay workfile submission, a warning message will display stating that the cheques just printed will not be captured in the Positive Pay Workfile.
The positive pay workfile is built as a batch when you enter Yes (Y) to the Submit Positive Pay WF Build (Y/N)? option on the Canadian Cheque Print Parameters and Canadian Print Interim Cheques Parameters screens. The workfile contains information about all regular, interim, and void paper cheques that were printed.
Note:
Auto deposits are not included in the positive pay workfile.The positive pay workfile build program determines if a record should be written to the file using the cheque control number as a unique identifier.
The positive pay workfile is the source for the positive pay bank transmittal file, and it includes the cheque types listed below with their ICC/ICS indicators:
N, C - Computer cheque
Y, C - Interim computer cheque
Y, M - Interim manual cheque
Y, M - Interim manual voids
Y, V - Void paycheque
Note:
Computer and interim cheques should only be included in the positive pay workfile if they have been printed. However, since interim manual cheques, interim manual voids, and voids are not printed, they should always be included in the positive pay workfile.System and user steps required to build the positive pay workfile include:
The person who prints the cheques will be prompted to submit positive pay information as part of the normal cheque-printing parameters step during payroll processing.
When you respond Yes (Y) to the positive pay option, paycheque records are written to the positive pay workfile, and the Positive Pay Workfile Report is generated.
Positive pay records are created as unprocessed with a blank value in both the Processed Code and Member ID fields.
Once the positive pay workfile is created, you can build the bank transmittal workfile and review the related Positive Pay Bank File Build Report.
To reset the positive pay workfile
If it becomes necessary to reset/reprint cheques after the bank transmittal file has been created, it is recommended that the Positive Pay Workfile be reset as well.
When you reset back to pre-payroll after cheques are printed, records in the positive pay workfile will be cleared for that payroll ID. If paycheques are reset, and then rerun, the positive pay workfile will automatically update accordingly.
Option 5 will reset all records that were loaded to the bank transmittal file back to an unprocessed status. It will also delete the physical file member and the corresponding record in the Positive Pay Tape Attributes File table (F062362).
Then, you can submit the bank file build process again, after the cheque print rerun has been completed. This will ensure that any changes are captured before the bank transmittal file is sent to the financial institution.
Based on the results of the positive pay workfile build process, this report will be generated every time the batch process runs. There is also a standalone version of the report available on the Canadian Payroll Positive Pay Processing menu for you to run this report on demand, as needed.
You can create alternative DREAM Writer versions of the report to allow more data selection options, such as:
Cheque number
Cheque date
Net pay
Payee number
Member ID
Processed flag
Cheque type (ICC/ICS)
G/L bank account
Creation User ID
Caution:
It is not recommended to change the data sequencing, as unpredictable report formatting and totaling results may occur.To generate the positive pay workfile report
On Positive Pay Workfile Report
Figure 22-11 Positive Pay Workfile Report screen
Enter 1 (Run) next to the appropriate version, and press Enter to display the processing options.
Accept or change the default processing option values, as necessary:
Payment Information
Header/Trailer Records
Report Option
Bank Tape
Press Enter to build the bank file and print the report.
The Positive Pay Workfile Report provides information about regular, interim, and void cheques that have been printed for each payroll cycle. This report is generated whenever the batch process runs. A standalone report version is available on the Canadian Payroll Positive Pay Processing menu for you to run this report on demand, as needed.
You can reconcile information written to the positive pay workfile with other payroll process reports using the Positive Pay Work File Report, which is sorted by:
G/L bank account
Member ID
Cheque number
Subtotal and total on G/L bank account
Make sure all paycheque records are correct and should be included. You can delete records from the positive pay workfile, if necessary.
Note:
To delete specific records from the positive pay workfile, create your own version of P00PURGE, and change the data selection to permit the deletion of specific records. See Section 22.2, "Printing Payments." for details.Figure 22-12 Payroll Positive Pay Work File report
Once unprocessed records have been added to the positive pay workfile, you can run the Positive Pay Bank File Build program to create a bank transmittal workfile.
System and user steps to build the positive pay bank transmittal workfile include:
The system uses unprocessed records to create a new physical file member, which contains cheque data formatted for the bank.
You can set up a DREAM Writer version with data selection that is based on the positive pay workfile.
The system enters Member ID values and updates the Processed Code for all corresponding records in the positive pay workfile, so that they display as processed.
The system determines which records are already processed and should be excluded from the workfile.
You can review the Positive Pay Bank File Build report in summary or detail mode. This report contains processed data along with the name of the newly created file member in the report heading. Be sure to verify the processing options before running the report.
After you review bank transmittal data, you can submit it to the bank via modem, an external media, or a File Transfer Protocol (FTP) process, if an FTP standard is available at your company.
Note:
Because financial institutions use a variety of positive pay formats, the bank transmittal data generated by the JD Edwards World system is designed to fulfill the formatting requirements of most banks. If you use modem and email methods to submit positive pay data to a bank, you are responsible for the encryption.If it becomes necessary to reset/reprint cheques after the bank transmittal file has been created, it is recommended that the Positive Pay Workfile be reset as well.
After the cheque print rerun has been completed, you can submit the bank file build process again. This will ensure that any changes are captured before the bank transmittal file is sent to the financial institution.
It is recommended that you set up a DREAM Writer version with data selection that is based on the positive pay workfile.
See Positive Pay Bank Workfile Build (P062361) in JD Edwards World U.S. Payroll I Guide.
To generate the positive pay bank file build report
On Positive Pay Bank File Build
Figure 22-13 Positive Pay Bank File Build screen
Enter 1 (Run) next to the appropriate version, and press Enter to display the processing options.
Accept or change the default processing option values, as necessary:
Payment Information
Header/Trailer Records
Report Option
Bank Tape
Press Enter to build the bank file and print the report.
You can review bank transmittal information to ensure that paycheque data is correct before submitting it to the bank.
Figure 22-14 Payroll Positive Pay Trans File report
The Copy Bank File to External Media program allows you to validate bank transmittal file member records before sending that information to financial institutions. Banks verify that transmittal data matches the cheques before they cash them.
You can copy selected members to an external media, such as magnetic tape, diskette, or CD, or you can upload the data directly to a financial institution via modem. You can load the tape or diskette before you execute the program, or you can load it after you select the copy function.
If your company uses an FTP standard, you can use the FTP process to download bank file data and send it as an email attachment or copy it to an external media.
The copy bank file program includes selection options that allow you to reset the positive pay workfile. You can also delete members from the transmittal file once they have been sent to the bank.
Note:
When you delete a bank file member on the Copy Bank File to Ext Media screen, the record is deleted in the Payroll Positive Pay Copy Attributes file (F062362). If the bank file member was available on disk, the record will be deleted from the disk, as well.To copy positive pay bank file transmittal data to an external media
On Copy Bank File to Ext Media
Figure 22-15 Copy Bank File to Ext Media screen
Complete the following fields and press Enter:
Bank Account
User ID
Member ID
Press F4 to access the detail area.
Verify that all detail fields are populated as expected:
Tape File
Device Name
Record Lngth
Tape Density
New Volume
New Owner ID
Block Size
Label Name
Do one of the following in the Option field and press Enter:
Type 3 (Copy/Tape) and verify that a tape is mounted.
Type 4 (Copy/Disk) and verify that a diskette is loaded.
Complete the following fields:
Action Code - Enter C (Change)
Option - Enter 9 (Delete)
Verify that the tape attribute record and the physical file member were deleted as expected.
The positive pay purge workfile program is based on the JD Edwards World Generic Purge program. You can select and purge processed records from the positive pay workfile through DREAM Writer data selection.
The file to be purged displays in the Based on File field on the Additional Parameters screen. You can use a processing option to reorganize the purged file, or save deleted records to a special purge library, if desired.
Note:
The default purge program is set up to purge all processed records in the Positive Pay Workfile (F06236) unless you specify otherwise. See the warning message that displays when you execute the program.It is recommended that you purge the Positive Pay Workfile on an annual or later basis.
Because the positive pay workfile purge program is a DREAM Writer, you can create alternate versions to select specific records for deletion.
You can add DREAM Writer versions to purge other physical (not logical) files, as long as you select records to purge through data selection only.
Caution:
Do not use the Generic Purge program to purge JD Edwards World ledger and balances files that require special processing. Such programs have their own purge programs to use.To purge the positive pay workfile
On the Canadian Payroll Positive Pay Processing menu
Type 5 and press Enter to display a warning message.
Do one of the following:
To purge all processed records in the positive pay workfile, press F6, and go to step 3 below.
To select a specific group of records to purge, do the following:
Open the DREAM Writer Versions List (G81/2).
Enter P00PURGE in the Form field.
Select version ZJDE0046.
Create a new data selection version that will allow you to select only those records you wish to purge.
Complete one or both of the following optional fields and press Enter.
Saved Purged Records
Reorganize File
This section discusses payment reports.
Depending on the type of payments you run and the information in your payroll, the system prints various reports. You should review these reports to verify that the information is correct. For internal audit purposes, you should save these reports at least until the end of the calendar year.
When you print payments, the system prints a register. Use this report to review payment numbers and amounts. If you reprint any payments during the print payments step, the register indicates that the original payment was voided.
Figure 22-16 Payroll Cheque Register report
Depending on the type of payments you run and the information in your payroll, the system prints various reports. You should review these reports to verify that the information is correct. For internal audit purposes, you should save these reports at least until the end of the calendar year.
Use the Canadian Direct Deposit Report as an audit trail for the deposit information you send to the bank. The report contains key information about the payroll transactions that are copied to magnetic media for direct deposits. There is no setup for this report. To alter the report, you can use the processing options, data selection, and data sequence for the generic Canadian Direct Deposit Report.
Figure 22-17 Canadian Direct Deposit report
Depending on the type of payments you run and the information in your payroll, the system prints various reports. You should review these reports to verify that the information is correct. For internal audit purposes, you should save these reports at least until the end of the calendar year.
When the payroll ID includes employees who are paid in cash, the system prints the Denominations report. This report lists the quantity of each type of bill and coin (such as dollars and cents) that each employee received.