cancel
Showing results for 
Search instead for 
Did you mean: 

Uploading of Chart of Accounts through DTW

Former Member
0 Kudos

Hi All,

Please explain which fields needs to be filled in oChart of Accounts Template.

Accepted Solutions (1)

Accepted Solutions (1)

former_member187989
Active Contributor
0 Kudos

Pl check this links which explain

"How to import and update the Chart of Accounts using DTW"

https://websmp201.sap-ag.de/~sapidb/011000358700000117862008E/SYS_CW05_Chart_of_DTW.pdf

https://websmp201.sap-ag.de/~sapidb/011000358700000117862008E/SYS_CW05_Chart_of_DTW.wrf

Please also look at this Wiki e-book

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

Jeyakanthan

Former Member
0 Kudos

Hi Jeyakanthan,

You have given usefull information.Thanks for that.I have one dout .you have given importing of chart of accounts through DTW in sap b1 2005A Version.Is it applicable for SAP B1 2007B Version.please Replay me.

Former Member
0 Kudos

The same document can be used for importing COA using DTW in SAP B1 2007B also.

Former Member
0 Kudos

Hi Jeyakanthan,

I have tried according to following wiki Book.But i got error "The field is too small to accept the Data".please explain how to do that.

former_member583013
Active Contributor
0 Kudos

Silpa,

Could you look which row you are getting the error on and could you paste that row here for me to take a look.

It should be easy to figure out....

Suda

Former Member
0 Kudos

Hi Suda Sampath,

I am sending my COA Template.

AccountType AcctCurrency ActiveAccount CashAccount

tNO tNO

tNO tNO

at_Other USD tYES tYES

at_Other USD tYES tYES

FatherAccontKey FormatCode Name

'100000000000000 Current Assets Current Assets

Current Assets Cash Cash Bank Cash 11100 Cash at Bank

Cash 11200 Checking Account

I have uploaded this template . But it is saying error"The field is too small to accept the Data".

Answers (2)

Answers (2)

former_member187989
Active Contributor
0 Kudos

You have filled up a column in DTW which is larger than it

size,Check & find out in DTW template.

Jeyakanthan

Former Member
0 Kudos

Dear Silpa,

It really depends on whether the COA is segmented or not.

I would suggest you install SDK and refer to the SDK help file and it will give you the column description, values, types and which fields are mandatory.

Further more, if you refer to the DTW templates, they will also have an example of COA import. You can fill an COA with the columns names below.

Code AccountType AcctCurrency ActiveAccount CashAccount FatherAccountKey FormatCode LockManualTransaction Name

It really does depend on the scale of detail you would like the COA to be.

Kind regards,

Indraj.