Bug 19921

Summary: 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.
Product: PR 32-bit W&M - 2026 Reporter: pavan <cpavankumar>
Component: State Taxes ReportAssignee: Lalitha <tlalitha>
Status: RESOLVED FIXED    
Severity: Medium    
Priority: Medium    
Version: 26.0.12 Ver-04   
Hardware: All   
OS: All   

Description pavan 2026-06-17 17:26:33 IST 
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
Comment 1 psajith 2026-06-17 17:47:01 IST 
The Same was existing in Mac also
Comment 2 Suresh 2026-06-18 17:08:44 IST 
Fixed in Win / Mac, available in version 04
Comment 3 Lalitha 2026-06-24 12:38:41 IST 
[Re-open]: The issue exists in NC state on both Windows and Mac.

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

Mac:https://drive.google.com/file/d/1_zpo-3-v266a55uzHl9kFkiWK3F06sTO/view?usp=sharing

DB:
https://drive.google.com/file/d/1CgnJu4EuNwyZ4mXqbWKw75b-3RE9Lv9W/view?usp=sharing


Working fine:
The above issue is working fine for the SC state on both Windows and Mac.

Screenshot:
https://drive.google.com/file/d/1NN6NZKQq5ZSmQ7AVdiDT76uaC5rXEL8N/view?usp=sharing
Comment 4 Suresh 2026-06-24 15:51:41 IST 
Fixed in NC state for Win/Mac, available in version 05