COA Import using DTW

[Former Member]

Hi Experts,

We are trying to Import COA using DTW to a company created using Indian COA (Adding some more accounts). Following is the sample data.

Code AccountType AcctCurrency ActiveAccount CashAccount FatherAccountKey FormatCode Name

Code AccountType AcctCurrency ActiveAccount CashAccount FatherAccountKey FormatCode Name

at_Sales INR tYES tNO 400041 410040 Sales - Product No.5

We used different file types like CSV, Tab Text etc. But the following error is the result.

"The field is too small to accept the data65171".

What gone wrong in this?

We had gone through all related threads we could find in forum and tried the solutions posted. But result is the same.

Please advice.

Also please provide some points which we need to take care while using DTW for Importing.

Thanks and Regards

Ajith G.

[Former Member · Accepted solution]

Two issues:

1. Do you leave the Code field blank?

2. Try at_Revenues instead of st_Sales.

Thanks,

Gordon

[Former Member]

The problem was with the code field and and when I replaced the code filed, It just updated. Thanks to all, who posted

[Former Member]

Hi,

1) "The field is too small to accept the data65171"

The error message may come from your text field in which have "comma" or longer than field length. Just check to find out

2) The sample you posted lack of code as Gordon said

Code AccountType AcctCurrency ActiveAccount CashAccount FatherAccountKey FormatCode Name

Code AccountType AcctCurrency ActiveAccount CashAccount FatherAccountKey FormatCode Name

410040 at_Sales INR tYES tNO 400041 410040 Sales - Product No.5

3) I always use text (tab delimited) file for importing in DTW because it is automatically add quote mask to text field which has comma mask. This is my experience.

Hope this helps.

Son.

[former_member187989]

hi ajith,

Go thru this link of wiki page,It will explain how to import COA using DTW.

Importing Chart of Accounts using DTW

https://www.sdn.sap.com/irj/scn/wiki?path=/display/b1/sapBusinessOne...ToGo-10.DataTransfer+Workbench

Jeyakanthan

[Former Member]

Hi ajith,

1. Check the Account code length

2. Try to import Tab Delemeted file. Before import

open the text file and find the any double Quotes( " ) and single

quotes ( ' ) are in text file

3.Check if any mandatory field in COA

4. Check the correct case tYES OR tNO

5. Check the following thread

https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=36438280

6.Chek the Note Number : 675960

• Close the thread when issue solved.

Regards

Jambulingam.P

Edited by: Jambulingam P on Jun 13, 2009 12:28 PM

Edited by: Jambulingam P on Jun 13, 2009 12:29 PM

Edited by: Jambulingam P on Jun 13, 2009 12:36 PM

[Former Member]

Hai,

Check this thread..

And, All 65171 errors are somehow linked to field format. Check if you have comma in the file or not first. Try using Tab Delimited Text format so that problem might be minimized.

Also make sure you have any double quotes " in the data.

Regards,

Thanga Raj.K