The aforesaid error may appear while importing data from Excel to Tally in the following situations :


Case 1

The Company Name in Tally ERP contains special characters viz Linefeed [#13] and carriage return [#10] at the end of Company Name. To check whether the Company Name is correct or not, please follow the underneath steps :


  1. Open your Company in Tally ERP
  2. Press Ctrl+F3 to select the "Company Info" 
  3. Next, select the option "Alter"
  4. In the Company alteration screen, press END-key while in the the Company Name field. If there is space between the last character and the cursor (as shown in this snapshot), press BACKSPACE to remove the special characters at the end of Company Name and save it.



Solution

ALTER the Company and remove the special characters (blank spaces) if any from the end of the Company Name. 



Case 2

The Company Name in Tally ERP contains & (i.e. ampersand sign). Example, the Company Name is "ABC & Co"


Solution

A. Upgrade to the latest version of udiMagic; 

or 

B. Change the Company name in Tally ERP. Example: "ABC and Co"