Microsoft Dynamics NAV (Archived)

Import Inventory with Excel and import stock quantité on new DB

(0) Share

Report

Posted on by Community Member

I need to import from excel quantity to migrate stock on new database NAV16.

I think the best way is to make Inventory and import the excel.

so my qestions is :

How can i import Inventory from excel (need tutorial).

and if there is a best way to migration stock for the first time?

Kind regards,

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (3)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Import Inventory with Excel and import stock quantité on new DB

You need to import data in Item Journal and then post it as this is standard way of posting

Never ever import data directly in Item ledger entry.

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: Import Inventory with Excel and import stock quantité on new DB

The best option for you is to use Rapid Start for that purpose. You can search for tutorials of using that, as there are plenty, e.g.: msdn.microsoft.com/.../dn848428.aspx .

As AJ Ansari suggested, you will need to import your opening item balances with quantities and amounts into Item Journal and then post it - it will produce corresponding transactions in General Ledger. Ensure you use correct technical account for balancing your stock item accounts.

Was this reply helpful? Yes No
Verified answer

AJAnsari 5,754 on at

Like (1)

Report

RE: Import Inventory with Excel and import stock quantité on new DB

Do not import directly into Item Ledger Entry. It is never advisable to import something directly into a "posted" table (generally speaking, a table that has the word "Ledger" in its name). This will result in all sorts of issues, such as your General Ledger and your subledger not matching.

The proper way is to Import all the data into a batch on the Item Journal (by using RapidStart or copying and pasting from Excel using the Paste Rows functionality), and then Post the entries from the Item Journal. This will create Item Ledger Entries AS WELL AS post details to other important tables in NAV that manage valuation of the item, etc.

I hope this helps. If my response has answered your question, please Verify by clicking Yes next to "Did this answer your question?"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Import Inventory with Excel and import stock quantité on new DB

thank's for your feedback.

I am not very strong in xmlport so i will try with rapidstart to importa data on Item Ledger Entry

Was this reply helpful? Yes No
Verified answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Import Inventory with Excel and import stock quantité on new DB

There are options you can use

1) You can create XMLPORT and import the inventory using .CSV or TXT file

2) You can create excel file and copy in Item Joural directly. Need to arrange column as per excel or vice versa.

Was this reply helpful? Yes No