This page (revision-26) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
26 26-Nov-2021 10:22 7 KB RForbes to previous
25 26-Nov-2021 10:22 7 KB RForbes to previous | to last
24 26-Nov-2021 10:22 7 KB RForbes to previous | to last
23 26-Nov-2021 10:22 8 KB JEscott to previous | to last
22 26-Nov-2021 10:22 7 KB JEscott to previous | to last
21 26-Nov-2021 10:22 7 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
CHECK RECONCILIATION PROCESS
CHECK RECONCILIATION PROCESS

Version management

Difference between version and

At line 6 changed one line
## Run [LMTD] to load a flat file to populate the Loaded_Cleared_Checks table.
## Run SqlLoader to populate the Loaded_Cleared_Checks table.
At line 17 changed one line
##Supply the bank with a file of ‘issued’ checks, also known as ‘Positive Pay’ ([UPPOSPAY]). (This list is sent each pay cycle.)
##Supply the bank with a file of ‘issued’ checks, also known as ‘Positive Pay’. (This list is sent each pay cycle.)
At line 20 changed one line
Checks loaded into the [P2K_PR_LOADED_CLEARED_CHECKS] table through [LMTD] may be viewed or corrected through the Manage Loaded Cleared Checks [IPCFB] form. The [LMTD] function is used to load external data from a flat file into the Personality tables.
Checks loaded into the Loaded_Cleared_Checks table through the SqlLoader may be viewed or corrected through the Manage Loaded Cleared Checks [IPCFB] form.
At line 22 changed one line
You may make use of the conversion function [IVLOAD] to load lines (records) from an outside flat file to [{$applicationname}] 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.
At line 27 changed one line
Cleared checks from the payroll banks must be loaded into the ‘Loaded Cleared Checks’ table (via [LMTD]) before this function is run.
Cleared checks from the payroll banks must be loaded into the ‘Loaded Cleared Checks’ table (Via SqlLoader) before this function is run.
At line 39 changed one line
#Enter in total amount of checks cleared from bank statement in the [Given $|DRV_GIVEN] field
#Enter in total amount of checks cleared from bank statement in the Given $ field
At line 41 changed 2 lines
#When the [Actual $|DRV_ACTUAL] field equals the [Given $|DRV_GIVEN] field, then the [Reconcile button|ACT_RECONCILE] will become available.
#If you wish to actually perform the reconciliation, you need only to click on the [Reconcile button|ACT_RECONCILE] and all the cleared checks will be removed. The reconciliation may also be cancelled through the [Cancel Reconcile button|ACT_CANCEL_RECONCILE]. This will remove any amounts from the Cleared Amount column.
#When the Actual $ field equals the Given $ field, then the Reconcile button will become available.
#If you wish to actually perform the reconciliation, you need only to click on the Reconcile button and all the cleared checks will be removed. The reconciliation may also be cancelled through the Cancel Reconcile button. This will remove any amounts from the Cleared Amount column.
At line 52 changed one line
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.
This service is not provided by all US banks and is not always called ‘Positive Pay’, however if the intent is the same, then [{$applicationname}] will provide the functionality through the Generate Check File To Bank ([UPPOSPAY]) form. [{$applicationname}] does not support the numerous banks out there, but can accommodate the support of other banks if required.
At line 54 changed one line
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.
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.
At line 56 changed one line
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.
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.
At line 58 changed one line
All checks with a non-null [MEX_ID_SENT] will be bypassed on subsequent processing of the [UPPOSPAY] or [UPPOSPAYW] program.
All checks with a non-null mex_id_sent will be bypassed on subsequent processing of the [UPPOSPAY] program.
At line 69 changed one line
If you need to replace a check from a manual range of numbers, you may do so directly through the [IPCH] form by clicking the [Replace in Manual Range button|ACT_REPLACE_CHECK_MANUAL].
If you need to replace a check from a manual range of numbers, you may do so directly through the [IPCH] form by clicking the Replace in Manual Range button.
[{Image src='ReplaceManual.JPG' width='260' link='attach/ReplaceManual/ReplaceManual.JPG'}]
At line 71 changed one line
[CHECK RECONCILIATION PROCESS/ReplaceManual.JPG]
Once you have clicked the button, you will be presented with the following screen.
[{Image src='ReplaceCheckManual.JPG' width='260' link='attach/ReplaceCheckManual/ReplaceCheckManual.JPG'}]
At line 73 changed one line
Once you have clicked the button, you will be presented with the following dialog [MPRCM] screen.
The Check # field will display the current check number, you will enter the replacement check number in the Replace with Check # field.
At line 75 changed one line
[CHECK RECONCILIATION PROCESS/ReplaceCheckManual.JPG]
Once you have entered the replacement number, you may click the OK button to complete the process.
At line 77 changed one line
The [Check #|CHECK_NUMBER] field will display the current check number, you will enter the replacement check number in the Replace with Check # field.
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.
At line 79 removed 4 lines
Once you have entered the replacement number in the [Replace with Check #|DRV_REPLACE_CHECK_MANUAL] 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|CHECK_NUMBER] field, you will see the new check number. In addition, on the right hand side of the screen, in the [Replaced #|CHECK_NUMBER] field, you can see the old check number.
At line 89 changed one line
If an employee loses their check, you can create a replacement check within [{$applicationname}].
If an employee loses their check, you can create a replacement check within Personality.
At line 93 changed one line
Click on the [Replace with Next|ACT_REPLACE_CHECK_WITH_NEXT] button:
Click on the Replace with Next button
[{Image src='ReplaceNext.JPG' width='260' link='attach/ReplaceNext/ReplaceNext.JPG'}]
At line 95 changed one line
[CHECK RECONCILIATION PROCESS/ReplaceNext.JPG]
Enter the next manual check number available, then click the OK button.
[{Image src='ReplaceNextCheck.JPG' width='260' link='attach/ReplaceNextCheck/ReplaceNextCheck.JPG'}]
At line 97 removed 6 lines
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 #|DRV_REPLACE_NEXT_CHECK_NUMBER] field with the next check in the range. If you are happy with the check number press OK, or Cancel to cancel the replacement.
At line 104 changed 4 lines
*[Check Status|CHECK_STATUS] - Replaced Check
*[Check Type|CHECK_TYPE] - Void Check
*[Replaced #|CHECK_NUMBER] - the next check number used
*[Printed|CHECK_PRINTED] - this toggle will be set ON (if not already) to prevent it from being printed again.
*Check Status - Replaced Check
*Check Type - Void Check
*Replaced # - the next check number used
*Printed - this toggle will be set ON (if not already) to prevent it from being printed again.
At line 110 changed 9 lines
*[Check Status|CHECK_STATUS] - Outstanding
*[Check Type|CHECK_TYPE] - Replacement Check
*[Replaced #|CHECK_NUMBER] - the original check number
*[Printed|CHECK_PRINTED] - this toggle will be set ON to prevent it from being printed automatically.
----
![Notes|Edit:Internal.CHECK+RECONCILIATION+PROCESS]
[{InsertPage page='Internal.CHECK+RECONCILIATION+PROCESS' default='Click to create a new notes page'}]
*Check Status - Outstanding
*Check Type - Replacement Check
*Replaced # - the original check number
*Printed - this toggle will be set ON to prevent it from being printed automatically.
This page (revision-26) was last changed on 26-Nov-2021 10:22 by RForbesTop