Import ChartOfAccounts

[Former Member]

Hello

I get a error when trying to import ChartOfAccounts whith SAP's objects. Does someone maybe know the reason for this error and a solution for it???

Count : 1700001 -2028 Not allowed superior number

thanks

Carmen Fuente

[former_member185703 · Accepted solution]

Hello Carmen,

Please post a sample of the data you are trying to import + the number of accounts etc.

Thanks,

Frank

[Former Member]

hello Frank

1)I use a predefined account template, but I need add some counts

2) "5.2.1" is level 4, type "Tittle", main level is passive

4) SAP BUSINESS ONE 2004A -- SP00 - PL18

5) I report my problem to SAP Support, but they did not even answer

thanks

Carmen Fuente

[former_member185703]

Hello Carmen,

I could test it successfully with the current build of version 2005 - without encountering any problem - using exactly that little piece of code we talk about...

I think this is really a bug in the version you have.

Thanks for logging a message on SAP Service Marketplace (SMP) for this.

Re 5)

Unfortunately the message you created is not visible in the internal SAP Support system!

Are you sure you have used the "<b>Send to SAP</b>" button?

I can see only one message from your company (that has been created by a colleague in support...) in the system at all.

Thus it's no surprise that you didn't get any reply.

Please check the "End User Documentation" - or call the appropriate SAP hotline number (In the SMB Portal on SMP go to "Service & SUpport" / "SAP Business One" / "Hotline Numbers"...) to get help to get your message really sent to SAP Support.

Thanks + sorry,

Frank

[former_member185703]

Hello Carmen,

Just FYI:

Your message is still not visible for Support

Regards,

Frank

[former_member185703]

Until now just the same...

Please press the "<b>Send to SAP</b>" button!

[Former Member]

Hello Frank,

I`m not working with account segmentation.

I think that I dont need the FormatCode, I only need Code

Thanks,

Carmen

[former_member185703]

OK, if you don't use segmentation, I have some more questions:

1) Did you create the CoA from scratch - or did you use a predefined account template?

2) How did you define account "5.2.1"?

3) On which level is "5.2.1"?

4) Which version / patch level of SAP Business One do you use?

5) Did you report your problem to SAP Support?

Regards,

Frank

[Former Member]

Hello Frank

this is my code:

Dim vCTB As SAPbobsCOM.ChartOfAccounts

Set vCTB = oCompanyB.GetBusinessObject(oChartOfAccounts)

vCTB.Code = "170001"

vCTB.FatherAccountKey = "5.2.1"

If (vCT.Add <> 0) Then

oCompany.GetLastError lErrCode, sErrMsg

MsgBox "CUENTA:" & vCT.Code & " --> " & (lErrCode) &

sErrMsg

End If

thanks

Carmen Fuente

[former_member185703]

Hello Carmen,

I only encounter such kind of an error when trying to use your code to add an account to the Chart of Accounts when segmentation is used (like e.g. in the SBODemo_US database...).

Please note that the helpfile states:

"Mandatory fields in SAP Business One: Code or <b>FormatCode (when working with account segmentation)</b>, and FatherAccountKey."

I hope this information helps you to get the accounts imported...

Thanks,

Frank

PS: Always try to do what you want to do through DI API in the application as well when encountering such problems (and please don't forget to read the SDK helpfiles (+ eventually the help for the application) carefully...).