String or binary data would be truncated

TDS Correction || Add/EDIT PAN Status → Import from Employee Master → String or binary data would be truncated.

      

Root cause of the error →
This issue typically occurs when an incorrect PAN format is entered in the original Employee Master, or if incorrect information is mistakenly entered in place of the PAN number.

Solution →
To correct the Employee/Deductee Master data, follow these steps:
  1. Navigate to Master → Employee/Deductee Master.

      

  1. For small data sets :
  2. Review each record individually.
  3. If any incorrect information is identified, modify the master record accordingly.
  1. For large data sets :
  1. Export the data to Excel by selecting the appropriate option from the Excel Export dropdown (either Export Employee Master or Export Deductee Master).
  1. Review the exported records to identify any incorrect entries.
      
  1. You can either correct the data directly in the software, or update the Excel sheet and then re-import the corrected data using the "Excel Import" option.
      
  1. Once all records have been updated, verify the import process to ensure accuracy.
This should resolve the issue.

    • Related Articles

    • ExpressTDS || Add/Edit Deductee in correction

      Deductee Correction Process in ExpressTDS To perform corrections for deductees in ExpressTDS, follow these steps based on whether you’re making a single deductee correction or a bulk correction. Access the Correction Section Navigate to the ...

    • ZenTds || Offline Correction process for TDS return

      Process for offline correction for 24Q, 26Q, 27Q & 27EQ from TDS software: The correction from the TDS software can be processed once you have the consolidated file (.tds file). How to request and download the consolidated file through the software: ...

    • TDS || Deductor's Master Creation and Edit Deductor's Master Process

      The initial phase in software involves setting up foundational elements known as masters, which include entities like Deductor, Deductee, Employee, DDO master, etc. Now, let's delve into the step-by-step process for creating the Deductor master: ...

    • TDS || Deductee/Employee Master → Import from Excel

      To import the Deductee/Employee Master through an Excel sheet, follow these steps: Download the "Deductee/Employee Master Excel Template": Navigate to "Master" → "Deductee/Employee Master". In the "Excel Import" dropdown menu, click on "Template ...

    • TDS || Deductee/Employee Master → Import From Other Deducter

      To correctly import Deductee/Employee Master from another Deducter, follow these steps: Start by accessing the "Master" menu in your system. Select "Deductee/Employee Master" from the options provided. Within the "Deductee/Employee Master" interface, ...