Excel Import of Chart of Accounts into Axapta

kanchan.chatterjee

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

Harish

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

arnypoo

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.