Excel Import of Chart of Accounts into Axapta

kanchan.chatterjee
kanchan.chatterjee Member Posts: 17
edited 2006-04-13 in Dynamics AX
I am trying to import a Chart of Accounts into MBS Axapta using the Data Import Template and Defintion Group.

However, I am faced with a typical problem.

My Account Codes are like 1000.10 , 11000.20 etc. In Excel even if I format this column as Text column, while importing the data it does not import the data and gives me a error.

What I could find is that when I put an apostophe mark in front of these codes the format turns into a Number Stored as Text and it lets me import these codes only.

Can someone help me with some information as to how to format the Account Codes so that I can import the Chart of Accounts.

Regards,
Kanchan

Comments

  • Harish
    Harish Member Posts: 172
    Hi Kanchan,

    Can you import the CoA by code? Some barebone code for importing this could be found here -

    http://www.harishm.com/Navision/Code.html

    If you are a developer, you will find this quick and easy.

    Regards,

    Harish Mohanbabu
    Harish Mohanbabu
    Long way to go before I sleep..
  • arnypoo
    arnypoo Member Posts: 1
    It should be possible to save the import file as a csv and get to load correctly. Try saving is as a csv in Excel and then opening it in Notepad to verify it is formatted correctly. If you need more help, please send me a private message and I can send you a specimen file.

Categories