Skip to Content
avatar image
Former Member

Single quote issue in COA using DTW

Hi

I am using DTW to import Chat of accounts in to the test Database.

i just fill 2 rows, 1 for title account and 2nd for active account.

the "fatheraccountkey" is automatically converted in to exponential form even i had put single quote. pls help

Regards,

Ankit

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 05:11 PM

    dear Rakesh Pati,

    I searched 888905 in SAP Notes but not able to find.

    could u pls provide the link or path for the same.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ankit,

      The note has no solution info regarding your issue. What you can do is:

      1. Enter a single quote first following the number. It should be displayed as text and left aligned. If not, you need to edit the cell to add a single quote in front of the number.

      2. Save the file as TXT (Tab Delimited) type. This format is the best for DTW use.

      3. Before DTW, always open the text file by notebook to check. You can correct any format within notebook in case nothing works by handling within excel.

      Thanks,

      Gordon

  • avatar image
    Former Member
    Sep 02, 2008 at 12:26 PM

    Ankit,

    In your excel template, please add a exclamation before the parent number and Excel will then treat it as a char

    Example: '40000000000

    Please also look at this Wiki e-book

    https://wiki.sdn.sap.com/wiki/display/B1/SAPBusinessOne...ToGo-10.DataTransfer+Workbench

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 12:30 PM

    hi suda,

    i had already done that, but when i reopen the saved file it again displayed in Exponential form.

    i had already mail you the same query with screen shots.

    ankit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 12:56 PM

    suda,

    i had tried that also.

    i make the changes in xls and later i save the file as CSV and used for DTW.

    result is same. "error 65171"

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Ankit,

      Please follow all the steps as per the SAP note : 888905.

      If still you have the same issue, please provide us the details information

      about the data that you have entered in the template.

      Regards,

      Rakesh Pati

      SAP Business One Forum Team