State Tax Reports:

Suppose there are 4 employees for a state filing (SC, NC, or any other state), and 1 employee has an invalid SSN while the remaining 3 employees have valid SSNs. Checks are created for all employees, including the 12th-month information.

When the CSV is generated, the record for the employee with the invalid SSN is correctly excluded, and only 3 employee records are included in the file. However, the Total Employee for 12 th date  checks Count is still showing 4.

Expected Result: Since only 3 employee records are included in the CSV, the Total Employee Count should be 3 for 12th date .

Actual Result:The Total Employee Count is showing 4, including the employee whose record was excluded due to the invalid SSN.

Screenshot:-https://drive.google.com/file/d/1yRmEsGK55L96BkOXorP7PrcRY61U3_qJ/view?usp=sharing

Db:-https://drive.google.com/file/d/1uHOF80M6OKhaUdFPMwNwjaPHjmvBgvbF/view?usp=sharing