You may make use of the conversion function IVLOAD to load lines (records) from an outside flat file to Wiki tables. Type ‘IVLOAD’ into the command line and a small dialogue box will appear asking for the control file, F_loaded_cleared_checks.ctl. Enter the name of the control file, either from the working directory or prefixed by the fully qualified path. The control file must contain the path and name of the data file. This functionality can be used to load pay lines, cleared check records, or time clock entries.
Cleared checks from the payroll banks must be loaded into the ‘Loaded Cleared Checks’ table (Via SqlLoader) 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 Wiki will provide the functionality through the Generate Check File To Bank (UPPOSPAY) form. Wiki 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 UPPOSPAY was executed are picked up and recorded in the output file.
Once UPPOSPAY is completed, the check record will be updated with the execution id of the UPPOSPAY 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 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.
Once you have clicked the button, you will be presented with the following screen.
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, 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
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