Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to Import Inventor...
Microsoft Dynamics GP (Archived)

How to Import Inventory Data to Dynamics GP

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have been asked to add functionality to an existing program that will take the data entered into it and export it to Dynamic GP. The problem is that I cannot find any documentation that tells me the information on how to do this. Everything just seems to be a link to more links that list more links that list more links that list more links...

So, let's say that I want to create an Excel file that will be used to import data about inventory into GP. What will that Excel file look like? What headers do I need in each column to correspond with specific attributes of the inventory in GP?

Example:

inventory_item_name, inventory_item_number, quantity_available, cost_per_unit

"blarg item", "1002432", "42","$2.98"

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Import Inventory Data to Dynamics GP

    Hi,

    I am using eone smart connect to upload the inventory into GP.

    But I want to confirm the format of excel sheet, which columns are mandatory while uploading inventory.

    Thanks.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: How to Import Inventory Data to Dynamics GP

    Importing items is one thing, importing item quantities is another. Is this something that is going to be done on a regular basis? Do you have inventory locations? Do these items come form multiple vendors? If you are going to be bringing in quantities you will need to import item transactions as well as the items themselves. Integration Manager and SmartConnect, both of which can use eConnect, are good choices to start. As far as the columns go, the more you can provide the better. Item number and description are a start but then you have item class, weight, cost, tax schedules, sell price, sites, etc. I would go to Cards->Inventory->Item and look at the item card screen and then click on the GoTo button and check out all the options there as well. Almost all of those fields can be imported so I would ask your IT staff what fields can they provide.

  • GovindDevda Profile Picture
    GovindDevda 615 on at
    RE: How to Import Inventory Data to Dynamics GP

    Robin you can use the Vkonnact software also ,there mapping facility available.

    www.Vkonnact.com

    Regards,

    Govind Devda

  • Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: How to Import Inventory Data to Dynamics GP

    Integration Manager is my go-to option for importing data into Inventory. If you take a look at the sample integrations which come with IM there is a sample file you can use as-is or customise further (and also change the mapping on the integration).

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 6 on at
    RE: How to Import Inventory Data to Dynamics GP

    Robin,

    You can import inventory in few options.  The following is my list.

    1) Import through macro into GP  my all time favourite

    2) Import using econnect

    3) Import using copy excel paste from Dynamics Innovations addon product

    4) Import using integration manager

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans