Batch number selector bug fix (#12346)
* fix bug in batch number selector. fetch and display batch numbers only for the given item code.
* remove print statement
* Fix error on selecting Chattisgarh in address
Fix error on selecting Chattisgarh in address because of spelling mistake
* Revert "Fix error on selecting Chattisgarh in address"
diff --git a/erpnext/controllers/queries.py b/erpnext/controllers/queries.py
index a71a08e..dd95026 100644
--- a/erpnext/controllers/queries.py
+++ b/erpnext/controllers/queries.py
@@ -418,6 +418,6 @@
'where (`tabBatch`.expiry_date >= CURDATE() or `tabBatch`.expiry_date IS NULL)'
if filters and filters.get('item_code'):
- query += 'where item = %(item_code)s' % filters
+ query += 'and item = %(item_code)s'
- return frappe.db.sql(query)
+ return frappe.db.sql(query, filters)
diff --git a/erpnext/public/js/utils/serial_no_batch_selector.js b/erpnext/public/js/utils/serial_no_batch_selector.js
index e21caad..a974b99 100644
--- a/erpnext/public/js/utils/serial_no_batch_selector.js
+++ b/erpnext/public/js/utils/serial_no_batch_selector.js
@@ -215,7 +215,7 @@
in_list_view:1,
get_query: function() {
return {
- filters: {item: me.item_code },
+ filters: {item_code: me.item_code },
query: 'erpnext.controllers.queries.get_batch_numbers'
};
},
@@ -357,4 +357,4 @@
}
];
}
-});
\ No newline at end of file
+});