web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Import tools for Dynamics GP

(0) ShareShare
ReportReport
Posted on by 215

Are there any free tools for importing into GP

*This post is locked for comments

I have the same question (0)
  • steveendow Profile Picture
    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.

  • Suggested answer
    sandipdjadhav Profile Picture
    18,306 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

  • Suggested answer
    Mahmoud Saadi Profile Picture
    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

  • L Vail Profile Picture
    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans