Cleared checks from the payroll banks must be loaded into the ‘Loaded Cleared Checks’ table (via LMTD) before this function is run.
Checks are selected for one payroll bank per run and only outstanding checks on the check file can be cleared.
The cleared amount must match the check amount. If these amounts differ, then the check must be cleared manually. The record will be rejected with an error message.
You may store these checks through the Reconcile O/S Checks (IPCR) form.
Checks can be manually reconciled through the following process:
This service is not provided by all US banks and is not always called ‘Positive Pay’, however if the intent is the same, then Personality will provide the functionality through the Generate Check File To Bank (UPPOSPAY or UPPOSPAYW) form. Personality does not support the numerous banks out there, but can accommodate the support of other banks if required.
All checks that have been either issued or voided within the date range provided since the last time UPPOSPAYx was executed are picked up and recorded in the output file.
Once UPPOSPAYx is completed, the check record will be updated with the execution id of the UPPOSPAYx run. The field is MEX_ID_SENT from the P2K_PR_CHECKS table.
All checks with a non-null MEX_ID_SENT will be bypassed on subsequent processing of the UPPOSPAY or UPPOSPAYW program.
Replacement checks as well as the associated void check are included.
Manual checks and manually voided checks are also included.
This function can be used to supply the bank with a list of issued checks if the bank is providing a reconciliation service.
CHECK RECONCILIATION PROCESS/ReplaceManual.JPG
Once you have clicked the button, you will be presented with the following dialog MPRCM screen.
CHECK RECONCILIATION PROCESS/ReplaceCheckManual.JPG
The Check # field will display the current check number, you will enter the replacement check number in the Replace with Check # field.
Once you have entered the replacement number in the Replace with Check # field, you may click the OK button to complete the process.
The IPCH screen will now display the change you’ve made. In the Number field, you will see the new check number. In addition, on the right hand side of the screen, in the Replaced # field, you can see the old check number.
Be sure to enter the correct check number here since correcting a mistake beyond this point requires DBA assistance.
At this point, you will need to go to UPSTUBC and ‘reprint’ the replacement check
Go to the Maintain Checks (IPCH) form and find the check number that has been lost.
Click on the Replace with Next button:
CHECK RECONCILIATION PROCESS/ReplaceNext.JPG
Once you have clicked the button, you will be presented with the MPRCN dialog screen. CHECK RECONCILIATION PROCESS/ReplaceNextCheck.JPG
The application will populate the Replace with Check # field with the next check in the range. If you are happy with the check number press OK, or Cancel to cancel the replacement.
The original check will now be identified with the following:
A new line will have been created for the replacement check with the new check number, the original issue date, person code, name, and amount. This new check will be identified with the following:
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation