Skip to main content



No record found.

Supply Chain Management forum

Import on hand inventory to D365 by using Excel

Posted on by Microsoft Employee

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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import on hand inventory to D365 by using Excel

    Hi Satish,

    Thank you! This works perfectly

  • Verified answer
    Satish Panwar Profile Picture
    Satish Panwar 14,639 on at
    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans