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

All responses (20)

Answers (2)

4BzSoftware 6,071 on at

Like (0)

Report

RE: Importing Chart of accounts

You are welcome, cheers!
babubaskaran@outloo... on at

Like (0)

Report

RE: Importing Chart of accounts

Thanks Khoa for your kind help.
Verified answer

4BzSoftware 6,071 on at

Like (0)

Report

RE: Importing Chart of accounts

Hi All,

I supported Babu to import data to system with our Universal Excel Import Export product. Thanks you all!
babubaskaran@outloo... on at

Like (0)

Report

RE: Importing Chart of accounts

Hi Tharanga,

I have seen this already, but it doesn't explain how to import master data like GL, Customer, Vendor, Inventory item. Can you please help me.
babubaskaran@outloo... on at

Like (0)

Report

RE: Importing Chart of accounts

Hi Khoa,

I followed all the steps mentioned by you as follows.

after I press yes on the above its given message saying Importing GL 100% went on green and finish. However when I went to chart of accounts its all empty. What I am missing please help me.
Suggested answer

TharangaC 23,116 on at

Like (0)

Report

RE: Importing Chart of accounts

Please watch this 9 min long video for get the idea about rapidstart : https://www.youtube.com/watch?v=AuRQGitHfJw
Suggested answer

4BzSoftware 6,071 on at

Like (0)

Report

RE: Importing Chart of accounts

Hi Babu,

The wizard process is our customization to speed up user interaction, it is not in your system. However, you can do it manually:

- In Configuration Packages list page, click New button to create new package.

- In General group of Package card page, Type in Code, Package Name for new package.

- In Tables group, select Table ID 15 - G/L Account.

- To configure fields, place cursor on Table ID 15 line, click Table -> Fields (in Tables group). Include fields that you need (system includes all fields by default). Click OK when finish.

- To export Excel template, place cursor on Table ID 15 line, click Excel -> Export to Excel (in Tables group).

- Edit data in exported Excel file.

- To import Excel file, place cursor on Table ID 15 line, click Excel -> Import from Excel (in Tables group).
babubaskaran@outloo... on at

Like (0)

Report

RE: Importing Chart of accounts

Dear All,

Can anyone tell me how to create template of customer, vendor, inventory from rapid start so that I can fill the data and import back. I am new to NAV so any help will be much appreciated.
babubaskaran@outloo... on at

Like (0)

Report

RE: Importing Chart of accounts

Thanks a lot Koha,

I am not able to find the excel import/export wizard as per below screen shot from your link. can you please tell me how to get the same.
Suggested answer

4BzSoftware 6,071 on at

Like (0)

Report

RE: Importing Chart of accounts

Hi Babu,

You're so new to NAV and welcome to NAV :-) Below Youtube links can help you:

- How to find the Chart of Accounts.

- Setting Up the Chart of Accounts.

Basically, there 2 page types for master data:

- Card page: display information of one object, such as "G/L Account Card" shows information of one G/L Account.

- List page: display list of objects, one line is information of one object. The list of G/L Account is "Chart of Accounts".

I just checked "Chart of Accounts" list page, you cannot edit the list directly (mean you cannot copy and paste from Excel). You should go through my 2 and 3 suggestions.