<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "http://45.127.191.6/bugzilla/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.3"
          urlbase="http://45.127.191.6/bugzilla/"
          
          maintainer="checkmark.bugzilla@checkmark.in"
>

    <bug>
          <bug_id>19921</bug_id>
          
          <creation_ts>2026-06-17 17:26:33 +0530</creation_ts>
          <short_desc>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.</short_desc>
          <delta_ts>2026-06-24 15:51:41 +0530</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>Unclassified</classification>
          <product>PR 32-bit W&amp;M - 2026</product>
          <component>State Taxes Report</component>
          <version>26.0.12 Ver-04</version>
          <rep_platform>All</rep_platform>
          <op_sys>All</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>Medium</priority>
          <bug_severity>Medium</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="pavan">cpavankumar</reporter>
          <assigned_to name="Lalitha">tlalitha</assigned_to>
          
          

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>76159</commentid>
    <comment_count>0</comment_count>
    <who name="pavan">cpavankumar</who>
    <bug_when>2026-06-17 17:26:33 +0530</bug_when>
    <thetext>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</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>76163</commentid>
    <comment_count>1</comment_count>
    <who name="psajith">psajith</who>
    <bug_when>2026-06-17 17:47:01 +0530</bug_when>
    <thetext>The Same was existing in Mac also</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>76248</commentid>
    <comment_count>2</comment_count>
    <who name="Suresh">skatragadda</who>
    <bug_when>2026-06-18 17:08:44 +0530</bug_when>
    <thetext>Fixed in Win / Mac, available in version 04</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>76546</commentid>
    <comment_count>3</comment_count>
    <who name="Lalitha">tlalitha</who>
    <bug_when>2026-06-24 12:38:41 +0530</bug_when>
    <thetext>[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</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>76591</commentid>
    <comment_count>4</comment_count>
    <who name="Suresh">skatragadda</who>
    <bug_when>2026-06-24 15:51:41 +0530</bug_when>
    <thetext>Fixed in NC state for Win/Mac, available in version 05</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>