Open Forum

Expand all | Collapse all

Vendor Address IDs

Jump to Best Answer
  • 1.  Vendor Address IDs

    TOP CONTRIBUTOR
    Posted 15 days ago
    Hello,

    I'm looking for a report I can run that would show me all the different Address IDs we have setup for each Vendor. Is there a SmartList that would work as I don't have experience in SQL? We are currently using this function to setup different addresses to mail checks to. We are contemplating creating new vendors for these instead since we have thousands of vendors we manage. If anyone has any experience with this and has any ideas that would be great. Thanks!

    ------------------------------
    Amber Schmoll
    Accounting Supervisor
    Milk Source LLC
    Kaukauna WI
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Vendor Address IDs
    Best Answer

    GPUG ALL STAR
    Posted 15 days ago
    Hello, again, @Amber Schmoll!

    Yes, you can use the ​Vendor Addresses SmartList. You just need to add the [Address Code] column to the SmartList to tell which address code is which; and the SmartList will show every address for each vendor.

    Regards,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List as of June 10, 2020
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Vendor Address IDs

    TOP CONTRIBUTOR
    Posted 15 days ago
    Thanks @Steve Erbach that was the field I was looking for!

    Thanks @Steve Erbach that's the field I was looking for!



    ------------------------------
    Amber Schmoll
    Accounting Supervisor
    Milk Source LLC
    Kaukauna WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


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