Microsoft Dynamics NAV (Archived)

Importing Chart of accounts

(0) Share

Report

Posted on by babubaskaran@outloo...

Dear All,

Can you please help me with the following.

1) We have 4 segment GL chart of accounts how to create this GL format in NAV 2015

details of my GL structure as follows.

01-001-1000-0200

01 - Company

001 - Department

1000 - Account

0200- Business Unit

2) Is there anyway I can import GL from excel into NAV.

Thanks,

babu

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (2)

babubaskaran@outloo... 12 on at

Like (0)

Report

Dear NAV Experts anybody there to help me please.

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (1)

Report

Hi Babu,

There are 3 options for you:

1. Copy and paste data from Excel to NAV directly: remember to arrange columns before copy and paste data. You can refer to this link.

2. Use Configuration Package: create package, table (15 - G/L Account), configure fields, export template, prepare data in exported template, import data from template file. You can refer to this link.

3. Use our solution "Universal Excel Import": you can refer to this link.

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

Just copy&paste :-p (of course, you should arrange your columns before). The easiest way is export, modify, copy and paste.

Good luck!

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Khoa & Miguel,

Thanks a lot for your kind reply. Can you please let me know or advice where to get the format or columns required. Also will I able to achieve this on NAV 4 segment account structure on GL. In dynamics GP its widely used.

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

Just export to Excel :-)

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Miguel,

Sorry I am new to NAV and not sure where to start. I am on the following window so please let me know how to export excel.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

In order to get the Export to Excel icon you need to customize ribbon and add Print & Send action group. For more info : https://msdn.microsoft.com/en-us/library/hh879067%28v=nav.71%29.aspx?f=255&MSPPError=-2147217396

Steps : Right click on the ribbon and from the menu click on Customize Ribbon.

Select the Print & Send action group and then click on the Add >> button.

Then click ok.

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Tharanga,

Thanks for your kind reply and excel icon added as per your instructions. however I am not sure how to fill the GL structure on the following excel format. can you please help me where can i add my following details.

1) GL Account ??-???-????-???? (first 2 segment for company, 2nd 3 segment department or balance sheet items, 3rd 4 segments is for Accounts and 4th 4 segment for business unit. Also account description and Account type & category.

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

Hi Babu, try copying directly and paste to Excel, modify and copy from Excel to NAV.

Good luck!

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Sorry Miguel,

Where do I do the copy, do I have to test company and copy a GL itself from there. I am sorry but I just getting confused, where to enter GL account, description, and account type.

Was this reply helpful? Yes No