Income Tax || Capital Gain Excel Import → Syntax Error
Root Cause of the Error →
The error occurs when a client enters a special character (') in the Capital Gain Excel template.
Solution →
- Open the Capital Gain Excel template intended for import into the software.
- Identify and remove any instances of the special character (') from the data within the Excel sheet.
- After correcting the data in Excel, re-import the template into the software.
By following these steps, you can ensure that the data entered in the Excel sheet is imported successfully.
Related Articles
Income Tax || Import capital gain data via Excel template
Step 1: Navigate to the Transaction section and select "Capital Gain". Step 2: Choose the special Excel sheet made for Capital Gain from the options. Step 3: Fill in all the info about your capital gains into the Excel sheet. Step 4: Click the button ...
Income Tax || Data Feeding - Capital Gain
What is Capital Gains Tax in India: Capital Gains Tax is a tax on the profit or gain that an individual or a business entity earns from the sale of capital assets. The capital assets can include property, stocks, bonds, gold, or any other asset. The ...
Zen IT || Excel Import → Type Mismatch, Error in excel import
Root Cause of the Error: The error stems from either erroneous data entry in the Excel sheet or alterations to the format of the specific Excel file. Solution → Validate Date Format: Verify that dates adhere strictly to the format "dd/MM/yyyy". ...
Income Tax || You have an error in your SQL syntax
[MySQL][ODBC 3.51 Driver][mysqld-4.0.13]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BAD"',0)' at line 1 Error in cmdOK_Click Solution: Please note that this ...
Tax Audit || Import Tax Audit Report from Previous year - SYNTAX ERROR
Root Cause of the error → The error is triggered when the client inputs special characters, such as an aapostrophe (') sign or backward slash (\) sign, while entering data in the previous year's records. Solution → To resolve this issue, the data ...