Custom Report Using Query

ERPNext Customize ERPNext
2

Hi @FMDO,

If the country is available in Item doctype then apply it.

SELECT
    `tabItem`.`name` AS `Item:Link/Item:200`,
    `tabItem`.`item_name` AS `Item Name:Data:200`
FROM
    `tabItem`
WHERE
    `tabItem`.`country` = "US"

Reference:

Thank You!

1 Like