Issue
An employee's check did not get voided when using the Void Check feature. Receive an error that there are no checks in the range to void.
Resolution
Several things have to exist for the Void Check feature to work in Payroll.
1 The check you are trying to void must exist in both check and transaction history.
2. It cannot have a duplicate check number, determined from check history UPR30100.
If leading zeroes are not used in the check number (Cards | Financial | Checkbook), the system may see the following check numbers as duplicate as it reads the check number from left to right.
101
1011
If leading zeroes were used, the checks would look like the following and therefore would not be a duplicate.
00101
01011
3. The check must be available for reconcile in Bank Reconciliation.
4. The check must fall within the current year.
5. View the CM20200 table in Query Analyzer
SELECT * FROM CM20200 WHERE SRCDOCNUM ='XXXX'
SRCDOCNUM is the check number used in payroll. For the check you are trying to void, the below columns need to have this type of status for the check to appear in the payroll void window. For example, if the RECONUM column is 1.00000, then it will not appear in the void window.
RECONUM = 0
Recond = 0
VOIDED =0
6. Use the following statement in Query Analyzer to view the CM20200 table:
SELECT * FROM CM20200 WHERE CMTrxNum ='XXXX'
Search on the check number that you cannot void. Duplicate check numbers cannot exist. If there is a duplicate number, even if it is from another module, the check cannot be voided.
If one of these criteria is not the case, you need to enter a negative manual check. To back the check out follow the steps below:
In the Payroll Manual Check Adjustment Entry
1. Create a batch and open the affected employee record. Verify the check date and post date are the correct date for this information.
2. Click the Transactions button.
3. Enter negative amounts (individual transactions) for all dollar amounts, hours, days, and weeks for all of the pay codes, deductions, benefits, and taxes affected.
4. Save each Transaction and then post the batch by clicking Transactions, clicking Payroll, and then clicking Batches.
If you need additional scripting assistance, contact Technical Support. If you plan to complete any update statements to the table, we recommend you have a back up before proceeding.
This article was TechKnowledge Document ID:5096
An employee's check did not get voided when using the Void Check feature. Receive an error that there are no checks in the range to void.
Resolution
Several things have to exist for the Void Check feature to work in Payroll.
1 The check you are trying to void must exist in both check and transaction history.
2. It cannot have a duplicate check number, determined from check history UPR30100.
If leading zeroes are not used in the check number (Cards | Financial | Checkbook), the system may see the following check numbers as duplicate as it reads the check number from left to right.
101
1011
If leading zeroes were used, the checks would look like the following and therefore would not be a duplicate.
00101
01011
3. The check must be available for reconcile in Bank Reconciliation.
4. The check must fall within the current year.
5. View the CM20200 table in Query Analyzer
SELECT * FROM CM20200 WHERE SRCDOCNUM ='XXXX'
SRCDOCNUM is the check number used in payroll. For the check you are trying to void, the below columns need to have this type of status for the check to appear in the payroll void window. For example, if the RECONUM column is 1.00000, then it will not appear in the void window.
RECONUM = 0
Recond = 0
VOIDED =0
6. Use the following statement in Query Analyzer to view the CM20200 table:
SELECT * FROM CM20200 WHERE CMTrxNum ='XXXX'
Search on the check number that you cannot void. Duplicate check numbers cannot exist. If there is a duplicate number, even if it is from another module, the check cannot be voided.
If one of these criteria is not the case, you need to enter a negative manual check. To back the check out follow the steps below:
In the Payroll Manual Check Adjustment Entry
1. Create a batch and open the affected employee record. Verify the check date and post date are the correct date for this information.
2. Click the Transactions button.
3. Enter negative amounts (individual transactions) for all dollar amounts, hours, days, and weeks for all of the pay codes, deductions, benefits, and taxes affected.
4. Save each Transaction and then post the batch by clicking Transactions, clicking Payroll, and then clicking Batches.
If you need additional scripting assistance, contact Technical Support. If you plan to complete any update statements to the table, we recommend you have a back up before proceeding.
This article was TechKnowledge Document ID:5096