cancel
Showing results for 
Search instead for 
Did you mean: 

Importing chart of accounts using DTW

Former Member
0 Kudos

Sir,

I ve problem While importing chart of accounts i get error, illegal parent number

Im using SAP B1 2005 patch level 5

Kindly provide solution as early as possible

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

The error relates to value in the FatherAccountKey column.

Please make sure you use the Account Code of the Account one level above the current account as the FatherAccountKey

Example of Hierarchy

Example

FatherAccountKey.....................FormatCode

100000000000000.....................Current Assets

Current Assets .........................Cash

Cash.........................................11100

Cash.........................................11200

Suda

Former Member
0 Kudos

Dear madam,

I ve used father account key which is used as parent but now i get "invalid code applicaion defined or object defined error".I m using user defined a/c,how i can define the parent account code.Kindly send the solution for the same

Thanking you,

sundar

former_member583013
Active Contributor
0 Kudos

Sundar,

If you send me the template I could take a look and reply you back

sudasampath.sapb1@gmail.com

Wishes

Suda

Former Member
0 Kudos

Suda,

I'm also facing with the same error while importing COA using DTW.

Can you please tel me in which way I've to format the data to upload the COA data.

I mean what are the fields should be filled up.

or else

Can I send the template which I had prepared for COA to the gmail given by you.

I would be obliged if you would do the needful at the earliest.

regards,

Murali

former_member583013
Active Contributor
0 Kudos

Murali,

Please do send me your COA template and I will take a look. Though your problem is similar to the the one faced by sundar, I would ask you to post your question seperately so that I would help me answer independently.

The reason I am saying this if Sandar issue is resolved he can close this question while your question can still be open.

Suda

Former Member
0 Kudos

Sir,

Im thankful to u,I ve solved that issue in COA.

In the Finanacial Report Templetes using Segementation

i ve to generate accounts for each plant(say p1,p2,p3,Head off).

Here i see checkboxes Text title,sub total,reversal sign,Dummy title) wat these functions are?

In balace sheet i can select Individual plant and view only corresponding transaction.

For head office i need to view HO transaction separately and also HO with plant transactions.

Answers (0)