Open Forum

Expand all | Collapse all

Is it possible to update and add new data to current vendors?

  • 1.  Is it possible to update and add new data to current vendors?

    Posted 23 days ago
    We are moving to a third party tool for AP automation. With that comes the need to add information to our current vendor setup, along with updating other information that already exists in vendor data. For example, we will need to add EFT information, some will need updated contact info, email and possible address information, along with GL account. Has anyone done something similar? If so, which route did you take and are you willing to share? What is the best way to accomplish this in a timely manner? It does not have to be in one pass, but time is limited and it does not appear this would be an easy project with Integration Manager or am I mistaken? Is there a third party tool that can handle all of this or can IM get this done for us with our developer's expertise? We have a strong in-house developer. Also, this will need to happen for 21 of our many companies. Any suggestions, tips or tricks would be great. Thank you in advance.

    Thank you,
    Angela

    ------------------------------
    Angela Morehouse
    CC Industries
    Chicago IL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Is it possible to update and add new data to current vendors?

    GOLD CONTRIBUTOR
    Posted 22 days ago
    You can certainly use IM to do this, but this sounds like it will be an ongoing process for you.  We use SmartConnect from eOne Solutions.  It's far easier to work with than IM and will allow you to schedule imports going forward.

    ------------------------------
    Jim Harris
    Director of Information Systems
    ExamWorks, Inc.
    Atlanta GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Is it possible to update and add new data to current vendors?

    Posted 22 days ago
    Thank you for the quick reply. This will be a one-time mass update. How would we go about using IM for this? I'm a little confused as I've only done basic integrations so far, but am familiar with the tool. Can you add tables that are not currently part of IM and create your own? Thank you for any tips or navigation to documentation that may be of help to me. I appreciate your time.

    ------------------------------
    Angela Morehouse
    CC Industries
    Chicago IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Is it possible to update and add new data to current vendors?

    GOLD CONTRIBUTOR
    Posted 22 days ago
    I thought the econnect adapter allowed for bringing in the bank info, but it's been a long time since I've worked with IM.  If not then you could us IM to import all of the vendor info except the bank part.  Then use table import to populate the bank info into the SY06000 table - Address Electronic Funds Master.  The table import utility just populates the target table with the info you provide.  No error checking is done.  But if this is a one-time exercise and you don't already have bank info in place for your vendors then it should be fine.

    ------------------------------
    Jim Harris
    Director of Information Systems
    ExamWorks, Inc.
    Atlanta GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Is it possible to update and add new data to current vendors?

    GPUG ALL STAR
    Posted 22 days ago
    Hi @Angela Morehouse

    Integration Manager will not update the email or EFT information, so you have a couple of options:
    1) Rent SmartConnect for 1 month to get this done, it's around $250.00 for a full month but you can get all of this done fairly quickly as you CAN map those fields with SmartConnect
    2) If renting that product is not an option, then you can always use a mail merge macro to quickly get it done.  You'd get your lists for updating them into Excel and then use Word to mail merge the info into a macro that would run in GP.  (Think of it as a custom Integration Manager)

    ​This article is by the awesome @David Musgrave and outlines how to build out a Word-Mail-Merge-Macro in GP

    https://winthropdc.wordpress.com/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/

    Best of luck, this is a very common ask to get updated, but unfortunately there is just no easy way to do it.


    ------------------------------
    Jo deRuiter
    🌟 GPUG AllStar 2019
    💫Granite Award Winner 2018,2019
    Atlanta Chapter Leader
    Credential Council Co-Chair
    Aisling Dynamics Consulting, LLC
    ERP Practice Manager
    jo.deruiter@aislingdynamics.com
    9518674366
    Alpharetta, GA
    aislingdynamics.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Is it possible to update and add new data to current vendors?

    GPUG ALL STAR
    Posted 21 days ago
    Another option is using GP Power Tools to perform the import for you. I have example code for importing data and will write a blog about it.

    Regards

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Is it possible to update and add new data to current vendors?

    Posted 21 days ago
    @David Musgrave I'd like to learn more about GP Powertools option. Is the blog post written or in the works? We're in a bit of a time crunch. ​​

    ------------------------------
    Angela Morehouse
    CC Industries
    Chicago IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Is it possible to update and add new data to current vendors?

    GPUG ALL STAR
    Posted 20 days ago
    Hi Angela

    The sample code for importing customers exists, but I have not written the blog yet.  Happy to provide the sample.

    However, you would need to adjust the code to change it to import your data and store the imported data where you want in the tables.

    This is not an import application, it is a custom script that performs the import and updating tasks and so would need altering to match your needs.

    Any developer will be able to make the changes, or I can provide some consulting time if needed.

    Regards

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 9.  RE: Is it possible to update and add new data to current vendors?

    GPUG ALL STAR
    Posted 21 days ago
    I would bet @Amber Bell could point you to a blog about how to do this update using a macro.
    Thanks
    Windi​

    ------------------------------
    Windi Epperson
    Customer Support Manager
    Njevity, Inc
    Norman OK
    720-870-9700 x104
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 10.  RE: Is it possible to update and add new data to current vendors?

    GPUG ALL STAR
    Posted 13 days ago
    @Angela Morehouse

    Amber tried to answer but for some reason it wouldn't post so she asked me to pass this along :)

    Here is a YouTube Video about using the Macro Replicator (FREE): https://www.youtube.com/watch?v=N7h9f67MEWY

    The Macro Replicator was designed by fellow GPUG member @ John Arnold. Here is where you can download: http://www.rnoldz.com/replicator/

     

    ​​

    ------------------------------
    Windi Epperson
    Customer Support Manager
    Njevity, Inc
    Norman OK
    720-870-9700 x104
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role