Just want to know how to import a .xls G/L entries in the Charts of Accounts
You have to :
- create a Excel template - create a new report program to import the excel data into NAV
We have succeed to create both of above to import Journals from Excel.
michael how to import a .xls G/L entries
NEVER do that! No Ledger table and ESPECIALLY GL Ledger table can't be manipulated in such a way!
Imported data MUST go trough corresponding Journals - you import data to the Journal, and then POST it to create entries in Ledger tables. Otherwise you will make your database corrupt in 5 seconds!
How to perform this task - please search the forum, there are many threads about it - I simply posted this quick answer ASAP to stop you before things haven't got too bad...
Modris Ivans MCP-Dynamics NAV Application
In reply to Modris Ivans:
Thanks for that I haven't start to do the earlier reply. I want to know actually how to import a G/L account into a COA i mean new import of COA. Coz there is no import export option in the COA. how in the world to import a .xls COA template in Navision.
During system migrations we always import data into Navisin using a General Journal.
First creat all the GL accounts that you need and the Posting Groups.
Look at the General Journal and see what fields are needed (the Journal Form will show that). It is always a good idea to enter and post a Journal to see how the system works.
Then you need a dataport that reads a txt or csv file into the general journal.
This may not have detailed answers but it is much better when you find out how the system works.
And it is especially important to understand about the data that is imported into the General Ledger.
Don't forget to the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.
In reply to michael:
I am also new to navision 2009. I would like to know how to import a chart of accounts from excel to Navision. Can someone please help me?