This article is for anyone who sees the Date Canceled field being populated on Non-Cleared checks.
- Requirement: Database admin access
- Run the following SQL Query to know the number of affected checks:
SELECT COUNT(*) FROM Pyapprole.Checks WHERE Date_cancelled IS NOT NULL AND Check_Cleared_Bank = 'N';
- Run the following SQL Query to update the Date Canceled of the checks to
NULLfor the checks that are marked as not cleared.
Update Pyapprole.Checks set Date_cancelled = NULL where CHECK_CLEARED_BANK = 'N';
- The number of affected rows for the 2nd query should be the same as the 1st query
- On the CORT Payroll application, Go to Reports -> Spreadsheet
- Click on Find to create a new Cort Payroll Spreadsheet
- Go to Spreadsheet -> Add Col
- Add the items: CLEARED and CDTECXLD (Date Check was Cancelled by Bank)
- Go to Sort -> Sort this by Col
- Verify that the checks marked with an N letter have no canceled date
Content Author: Santiago Lunar