Import on hand inventory to D365 by using Excel

(0) Share

Report

Posted on by Community Member

I want to migrate on hand inventory to a newly set up company in D365. Preferably, i would like to use a counting journal or inventory adjustment.The problem is that i have 8000 lines and dont want to do this manually in D365, i want to use the excel add in function. I can open counting journal lines in Excel and update, but i cannot add cost to the lines. In the inventory adjustment journal the cost is easier to add to the line, but i can't find a way to open inventory adjustment lines in Excel.

So my question is: Is there a journal (or entity) that i can open in Excel, where i can add cost, location and batch?

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report

RE: Import on hand inventory to D365 by using Excel

Hi Satish,

Thank you! This works perfectly
Verified answer

Satish Panwar 14,653 Moderator on at

Like (0)

Report

RE: Import on hand inventory to D365 by using Excel

Hi Halvard Usrin,

Please use entity "Inventory movement journal headers and lines" to import the on-hand inventory. You should be able to enter all the details here.

Agree that entering 8000 lines manually doesn't make sense. Instead of opening in excel, leverage data management workspace and import the excel from there.