Try ERPNext Buy Support Partners Foundation

Query Script for Supplier Address

Hello,

I am making a report where the Supplier Address is required.

Doing a SELECT ALL on tabSupplier, I am not able to find the field supplier address.

Can anyone please confirm how to retrieve the supplier address?

Best regards,
Kartive.

SELECT sp.name as supplier, ad.*
FROM `tabDynamic Link` dl, `tabAddress` ad, `tabSupplier` sp
WHERE dl.parent = ad.name AND dl.parenttype = "Address"
  AND dl.link_doctype = "Supplier" AND dl.link_name = sp.name

Maybe this can help you.