web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Vendor's contact i...
Microsoft Dynamics AX (Archived)

Vendor's contact information (E-mail) not visible in All Vendors list page

(0) ShareShare
ReportReport
Posted on by Johnny 6,478

Hi,

The problem is that when contact information (e-mail addresses - table LogisticsElectronicAddress, field Locator) are filled for all vendors and are visible if we open vendor card, but not all these e-mail addresses are visible in Vendors list page.

What can be a reason and how it can be solved?

Thanks.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,146 Super User 2025 Season 2 on at

    Hi Joni,

    Out of the box there is no Email field on the vendor list page. Can you confirm this is a customization?

    Probably it tries to find a primary email. Can you verify if the Primary field is enabled on the Email record?

  • Johnny Profile Picture
    Johnny 6,478 on at

    Hi Andre,

    I have added it via Personalize  --> Add fields --> Global address book --> E-mail address.

    Yes, Primary field is enabled.

    What I see now is: If I open Vendor card, uncheck the Primary checkbox and close the form and then again open it and enable primary checkbox back, then I can see the e-mail in list page.

    But there are many vendors and I can't go through them one by one to disable and enable the checkbox again.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,146 Super User 2025 Season 2 on at

    Hi Joni,

    Probably by updating the field on the vendor card, some information is being saved in another way. Can you probably check if this changing will also update some other fields/tables? Did you import the vendors with the email details? Or were they entered manually?

  • Johnny Profile Picture
    Johnny 6,478 on at

    Hi Andre,

    details also were imported with vendors.

    described steps above updates "PrivateForParty" field of LogisticsElectronicAddress table, which is 0 if I check.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,146 Super User 2025 Season 2 on at

    Hi Joni,

    I can't verify this as I don't have a reproducible example. If this is your difference, you could try to create a correction script to update all records related to the emails of your vendors.

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    I've seen this problem before.

    There are two ways to start from a DirPartyTable record (which is immediately joined to VendTable on the VendTableListPage form query).  That form's query jumps from DirPartyTable directly to a LogisticsElectronicAddress record by using the DirPartyTable.PrimaryContactPhone field for the phone number,  and I suspect using the DirPartyTable.PrimaryContactEmail field for the e-mail address.

    It's quite easy when importing vendor master data to create all the correct records (DirPartyTable, DirPartyLocation, LogisticsLocation, and finally LogisticsElectronicAddress), and check the IsPrimary field on the LogisticsElectronicAddress record, and forget to set the PrimaryContactEmail field on DirPartyTable.  I've done it.

    Unchecking the IsPrimary checkbox and checking it again updates the PrimaryContactEmail (or PrimaryContactPhone, or whichever) record on DirPartyTable, so I suspect that's why it solves your problem.

    Test the theory by selecting a single VendTable record where the e-mail address fails to show, and inspect the DirPartyTable record, noting the PrimaryContactEmail field (which is probably 0), and then uncheck and re-check the IsPrimary checkbox, and inspect again.

    If this is in fact the problem, then a little SQL can fix your issue across all vendors quite easily.

    Hope this helps.

  • Vishalb_DAX Profile Picture
    Vishalb_DAX 85 on at

    I was asked to send a report with all vendors and their email id's: created on sql query:

    select v.ACCOUNTNUM, d.NAMEALIAS, lea.TYPE, lea.LOCATOR

    , v.DATAAREAID from VENDTABLE v

    inner join DIRPARTYTABLE d on v.PARTY=d.RECID

    inner join DIRPARTYLOCATION dpl on d.RECID=dpl.PARTY

    inner join LOGISTICSLOCATION ll on dpl.LOCATION=ll.RECID

    inner join LOGISTICSELECTRONICADDRESS lea on ll.RECID=lea.LOCATION

    where lea.LOCATOR like '%@%'

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans