Skip to Content
avatar image
Former Member

DTW Error - The ' ' character, hexademical value 0x20, cannot be included in a name

I am trying to import A/R Invoices, but I keep getting the following error.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Apr 06, 2017 at 11:05 AM

    Hi,

    Please try the following:

    1. open your import file in Excel
    2. select the column with item or business partner names
    3. use Excel's find/replace function to replace all ' (quote) characters with ´ (accent) characters
    4. use Excel's find/replace function to replace all " (double quote) characters with ´´ (2 accents) characters

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2017 at 10:54 AM

    Hi Mzikabawo Dingalibala

    Can you share the template and screeen

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 06, 2017 at 11:17 AM

    Here are the files

    Add comment
    10|10000 characters needed characters exceeded

    • Fill the

      1.Price (Column G ) as per Excel instead of UnitPrice (Column CA)

      2. Whse code missing

      3. similar line total (Column BL)

      4 On vatgroup column format column to Text before loading

      5. In header sheet fill Handwritten tNO

      Regards:

      Balaji.S

  • avatar image
    Former Member
    Apr 06, 2017 at 12:28 PM

    I have managed to get rid of the error I had before, the one that I'm experiencing now is: On "Contents" tab, enter item or items 10000111 - On "Contents" tab, enter item or items65171.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2017 at 07:27 AM

    Thanks for the support, We have managed to import the template successfully. We removed the line with the special characters and we were able to import fine.

    Add comment
    10|10000 characters needed characters exceeded