Where does Vendor.EMailAddress come from?

The Vendor table contains a column named ‘EMailAddress’ that I can’t figure out how to populate or change from within E10. If I run a SQL query on our Suppliers, some of them contain a valid email address in that column and some do not. I have compared the E10 setup of those that have data in Vendor.EMailAddress with those that do not and I cannot find anything consistent that tells me what populates that field.

Sometimes it’s the Primary Contact’s email address, but sometimes it is not. We don’t seem to be using Purchase Points at all, so no dice there.

Can anyone help me understand? My ultimate goal is to display an email address on the Remittance Advice SSRS report.

Thank you in advance.

2 Likes