Merge pull request #4481 from nabinhait/develop

[fix] Ignore user permission in target warehouse in SO
diff --git a/erpnext/stock/doctype/item/item.py b/erpnext/stock/doctype/item/item.py
index 489b1bd..0fc0faa 100644
--- a/erpnext/stock/doctype/item/item.py
+++ b/erpnext/stock/doctype/item/item.py
@@ -89,23 +89,29 @@
 			auto_set_website_image = True
 			self.website_image = self.image
 
-		if self.website_image:
-			file = frappe.db.get_value("File", filters={
-				"file_url": self.website_image,
-				"attached_to_doctype": self.doctype,
-				"attached_to_name": self.name
-			}, fieldname=["name", "is_private"], as_dict=True)
+		if not self.website_image:
+			return
 
-			if not file:
-				if not auto_set_website_image:
-					frappe.msgprint(_("Website Image {0} attached to Item {1} cannot be found")
-						.format(self.website_image, self.name))
-				self.website_image = None
+		# find if website image url exists as public
+		file = frappe.get_all("File", filters={
+			"file_url": self.website_image
+		}, fields=["name", "is_private"], order_by="is_private asc", limit_page_length=1)
 
-			elif file.is_private:
-				self.website_image = None
-				if not auto_set_website_image:
-					frappe.msgprint(_("Website Image should be a public file or website URL"))
+		if file:
+			file = file[0]
+
+		if not file:
+			if not auto_set_website_image:
+				frappe.msgprint(_("Website Image {0} attached to Item {1} cannot be found")
+					.format(self.website_image, self.name))
+
+			self.website_image = None
+
+		elif file.is_private:
+			if not auto_set_website_image:
+				frappe.msgprint(_("Website Image should be a public file or website URL"))
+
+			self.website_image = None
 
 	def make_thumbnail(self):
 		"""Make a thumbnail of `website_image`"""