Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Excel to dynamics import

Posted on by Microsoft Employee

Hello,

My purchasing departments biggest issue (at the moment) is that they really hate entering new items and editing existing ones in gp. We have many SKUs and a lot of new ones coming and going every month, so it takes up a large amount of their time.

Their biggest request then is a single window they can open that would have every field needed to create or edit an item vs. having to go to navigate to and from multiple windows.

Is there such a thing? Like an excel sheet that can import and more importantly export info directly to all the required fields?

Thank you.

*This post is locked for comments

  • mm123 Profile Picture
    mm123 2,535 on at
    RE: Excel to dynamics import

    Hi, We have done similar solution to our client to Export / import excel based Inventory list ( Exact GP fields)  with new SKUs  & price changes that comes every week.If you are interested please reach me to learn more.

    samr(at)expsoltech(dot)com  

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Excel to dynamics import

    I would look into SmartConnect from eOneSolutions to import these items into GP. You could create a template spreadsheet and then use SC to import these items into GP.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans