Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

AP VENDOR SETUP

Posted on by Microsoft Employee

I need to set up 400 vendors for a/p payments, is there a fast upload for GP 2015?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP VENDOR SETUP

    You could also use a Macro if you would be more comfortable with that.

    Harry Lee has a great blog about how to create those.

    redbeardblogging.blogspot.com/.../how-to-create-and-run-simple-macro-in.html

    Thanks,

    Justin

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: AP VENDOR SETUP

    There is a justification for explanation provided by Bill,

    Consider Data Import for Salesperson ID, if you see IM, you don't find any Integration Adapter, so it is ideal to use Table Import.

    But in the case of Vendor Import, it is traditional way to do using IM.

    Thanks,

    Praveen

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: AP VENDOR SETUP

    Mohammed I would agree it is the least recalled tool there - but it has it uses - especially great when you want to update data to a table where Microsoft developers have not built a connector in Integration Manager and or you do not have the programming knowledge to build in eConnect.

    I use Table import often - but it is the lack of interface that makes if tough for a new user to use.

  • Mohammed Vayalil Profile Picture
    Mohammed Vayalil 150 on at
    RE: AP VENDOR SETUP

    Both SC and IM will do your job, I just want to remind about forgotten tool "Table Import".

    I think it's a great tool too.

    Microsoft Dynamics GP>Tools>Integrate> Table Import

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: AP VENDOR SETUP

    I like both suggestions and I believe it comes down to the matter of comfort.  What tool are you most comfortable with?

    Are you planning to do this a number of times ?  If so, then SmartConnect might be the way to go - build the integration right to the data.

    If this is a one time - list of vendors in excel ( example ) then IM  is quick and easy.

    But both will work, I use IM more than anything else - comfort is main reason.

    Hope this helps.

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: AP VENDOR SETUP

    Integration Manager is effective to do this.

    Hope you are familiar with IM, if not happy to provide you steps to do this.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP VENDOR SETUP

    SmartConnect

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans