Try ERPNext Buy Support Partners Foundation

Query Script for Supplier Address


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,

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

Maybe this can help you.