D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Adding Vendor Address to All Vendors Form

  • 1.  Adding Vendor Address to All Vendors Form

    Posted Jul 12, 2019 02:15 PM
    I am attempting to add the vendors address to the all vendors form.

    I have selected the personilize form option add field but for the life of me cant see ADDRESS, I thought maybe location ID but thats not available either.

    Short of selecting all the extra fields anyone have any idea on what the right one is?

    Chad Smith
    Franklin Covey
    Salt Lake City UT

  • 2.  RE: Adding Vendor Address to All Vendors Form

    Posted Jul 12, 2019 02:31 PM
    Hi Chad,

    Talking from a D365FO perspective here: I am pretty sure that addresses are stored in a different table that you can't call from the "all vendors" screen, meaning it would require customization to add that information to that screen. I could be way off here...

    Can I ask why you want the address in that screen? You could click on Related information on the very right of your screen, primary address is one of the fields it would show there.

    Kerstin Newman
    London ON


  • 3.  RE: Adding Vendor Address to All Vendors Form

    Posted Jul 12, 2019 02:43 PM

    Just trying to create a quicker dump of vendors vs running the inquiry for my end users.

    I figured it was cross tables.

    Was hoping someone might be more familiar with the joins and had that request before.

    I was leaning towards it being a customization but was still hopeful.

    Appreciate the quick and insightful reply.

    ***sent from my cellular device. please excuse all spelling, punctuation and brevity***


  • 4.  RE: Adding Vendor Address to All Vendors Form

    Posted Jul 14, 2019 05:13 PM
    Hello Chad,

    Not sure what version you are running but the you could use the data entities to dump the information out if that is all you are after.  Depending on what address you need the primary is dumped out on VendorsV2

    If you still need it on the listing page you will need to considered customization as mentioned above.  The primary address is in the related information tab on the right of the screen.  Would that also work?

    Neill Riordan
    Dynamics 365 Solution Architect


  • 5.  RE: Adding Vendor Address to All Vendors Form

    Posted Jul 16, 2019 02:07 PM
    Hi, Kerstin is correct. Address are not stored directly in the  Customer or Vendor tables so you will not be able to personalize. If this is D365FO, try the data entity: Vendor postal addresses

    Andrew Lencsak
    Solution Architect


  • 6.  RE: Adding Vendor Address to All Vendors Form

    Posted Jul 17, 2019 07:51 AM
    you might also pull a report that you create with Power BI or using something like Atlas. The Atlas tool is very easy to use to take advantage of existing relationships and if none exist then you can do a join to get the info you need in one report.  Andrew is correct, addresses are stored in different tables and those tables are rarely included for personalization.

    Paul Martin
    Production Program Manager
    Elite Comfort Solutions, LLC
    Rutherfordton NC


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