Canada - Ontario Ottawa

Expand all | Collapse all

Bulk Update Remit to E-mail addresses

  • 1.  Bulk Update Remit to E-mail addresses

    Posted Mar 26, 2020 01:27 PM
    Edited by Peri Anderson Mar 26, 2020 01:27 PM
    Hello,

    We are using Smart connect to make changes to Vendors in GP.  We currently have all of our Employee's listed as vendors.  All of our employees recently had their e-mails changed from for eg. Peri.Anderson@abc.ca to Peri.Anderson@123.ca  We know where e-mail addresses are stored in GP, by clicking Vendor, then clicking the little globe Icon to get to the e-mail addresses. However we can't seem to figure out how to change these using a map. Has anyone had success with making mass update changes such as this?



    ------------------------------
    Peri Anderson
    MD Financial Management
    Ottawa ON
    ------------------------------


  • 2.  RE: Bulk Update Remit to E-mail addresses

    Posted Mar 27, 2020 09:35 AM
    ​Peri,

    I have not built a map to do this.

    The right Node in SmartConnect would be Company, Internet Addresses.  However, I'm not sure if this node can update addresses or only create.

    Are you able to run this?

    SELECT PVM.VENDORID,PVM.VENDNAME,INI.INET1,INI.EmailToAddress
    FROM XXX.dbo.PM00200 PVM
         INNER JOIN XXX.dbo.SY01200 INI ON INI.Master_Type='VEN' AND PVM.VENDORID=INI.Master_ID
    Where XXX is your Company Database name.

    ------------------------------
    Tim Foster
    Dynamics GP Specialist
    CAA North & East Ontario
    Ottawa ON
    ------------------------------



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