Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Import tools for Dynamics GP

Posted on by 215

Are there any free tools for importing into GP

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Import tools for Dynamics GP

    hi John,

    What are trying to import? For instance, an import tool for Fixed Assets is part of the module.

    Kind regards,

    Leslie

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Import tools for Dynamics GP

    In terms of free integration tools, I would recommend the Macro.It is a totally free, generic and easy to use especially with excel. It records your mouse clicks and keyboard entries. The only disadvantage of it is the slow performance.

    On the other hand, GP Excel Paste is one of the essential products that deserves some of your time to look at.

    GP Excel Paste

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Import tools for Dynamics GP

    In Master, you don't  just import customer ID or Name you import address and other information too. So it get affect another tables too. I am not big fan of table import. I think Microsoft allow 90days free trial of Integration Manager.

    Here is type of Import for Dynamics GP sandipdjadhav.blogspot.com/.../types-of-integration-method-with.html . You can try Macro it is free..

    Thanks

  • steveendow Profile Picture
    steveendow 2,281 on at
    RE: Import tools for Dynamics GP

    Hi John,

    The only free import option I'm aware of is the GP Table Import feature.  I would generally only recommend it for very simple imports, such as for master records that are very simple and don't affect multiple tables.

    support.microsoft.com/.../856667

    dynamicsgpblogster.blogspot.com/.../often-overlooked-yet-powerful-table.html

    If you want to try table import, definitely thoroughly test it on the Fabrikam database or a test database first.

    You could potentially also use direct SQL inserts or SSIS, but again, I generally wouldn't recommend those for anything other than simple master records or very specific imports that don't affect multiple tables.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans