[fix] get barcode string instead of dict (#14139)
* [fix] get barcode string instead of dict
* Update pos.py
diff --git a/erpnext/accounts/doctype/sales_invoice/pos.py b/erpnext/accounts/doctype/sales_invoice/pos.py
index 4d2e7cc..0f69fac 100644
--- a/erpnext/accounts/doctype/sales_invoice/pos.py
+++ b/erpnext/accounts/doctype/sales_invoice/pos.py
@@ -285,13 +285,13 @@
itemwise_barcode = {}
for item in items_list:
barcodes = frappe.db.sql("""
- select barcode from `tabItem Barcode` where parent = '{0}'
- """.format(item.item_code), as_dict=1)
+ select barcode from `tabItem Barcode` where parent = %s
+ """, item.item_code, as_dict=1)
for barcode in barcodes:
if item.item_code not in itemwise_barcode:
itemwise_barcode.setdefault(item.item_code, [])
- itemwise_barcode[item.item_code].append(barcode)
+ itemwise_barcode[item.item_code].append(barcode.get("barcode"))
return itemwise_barcode