G/L import exporting

Hello 

Just want to know how to import a .xls G/L entries in the Charts of Accounts

thanks

  • 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. Cool

  • 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:

    Hello Modris

    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.

    Regards

    Michael

  • 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.

     

     


    Jonathan.

    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:

    Hello,

    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?

     

    Thanks,

    Teena

     

Related