Thank @kennethsequeira @szufisher
I am using the SaaS of ErpNext, have added the scan_bar_code in Customize Form > Sales Invoice
Secondly following is the code I added in Custom Script as below:
frappe.ui.form.on('Sales Invoice', {
validate: function(frm) {
var grouped_list = []
var already_filtered = [];
// Loops through all items of array
for(var i = 0, len1=frm.doc.items.length; i < len1; i++) {
// Skip rest of the loop if the item has been grouped with some previous item
if(already_filtered.indexOf(i) != -1) {
continue;
}
// Split item name by - , to separate name color size
var item_name_formats = frm.doc.items[i].item_name.split(' - ');
// Create an object with item color as key and item size as value
var item_variance = {};
item_variance[item_name_formats[2]] = [item_name_formats[3]];
// Object to hold item temporary before grouping
var grouped_item = {
idx : i,
item_code : frm.doc.items[i].item_variant_of,
item_name : [item_name_formats[0] + ' - ' + item_name_formats[1]],
gst_hsn_code: frm.doc.items[i].gst_hsn_code,
qty : frm.doc.items[i].qty,
uom : frm.doc.items[i].uom,
net_rate : frm.doc.items[i].net_rate,
net_amount: frm.doc.items[i].net_amount
};
// Loop to check the current item with rest of the items
for(var j = i+1; j < len1; j++) {
// Skip this loop if the current item has been grouped with some previous item.
if(already_filtered.indexOf(j) != -1) {
continue;
}
// Check if item_variant_of and net_rate is equal of 2 items.
if(frm.doc.items[i].item_variant_of === frm.doc.items[j].item_variant_of && frm.doc.items[i].net_rate === frm.doc.items[j].net_rate) {
// Add item quantity
grouped_item.qty += frm.doc.items[j].qty;
// Add net amount
grouped_item.net_amount += frm.doc.items[j].net_amount;
// Split item name by - , to separate name color size
var next_item_name_formats = frm.doc.items[j].item_name.split(' - ');
// if this color is already present, add 1 more size to it
// else create another key for another color
if(item_variance[next_item_name_formats[2]]) {
item_variance[next_item_name_formats[2]].push(next_item_name_formats[3]);
}
else {
item_variance[next_item_name_formats[2]] = [next_item_name_formats[3]]
}
// Push the item to already_filtered array so it can be skipped later while comparing with rest of the items
already_filtered.push(j);
}
}
// Loop through all colors and join sizes by ,
var variances = '';
for(var key in item_variance) {
variances += "<br >" + key + ' - ' + item_variance[key].join(', ')
}
// Join item names with each variance
grouped_item.item_name = grouped_item.item_name + variances;
// Add the grouped item to the final output list
grouped_list.push(grouped_item);
}
frm.set_value('grouped_items', JSON.stringify(grouped_list));
},
scan_bar_code: function(frm, cdt, cdn){
if (frm.doc.scan_bar_code!==undefined){
frappe.db.get_value(‘Item’, {barcode: frm.doc.scan_bar_code}, ‘item_code’, ( r ) => {
if(r !==undefined){
var row_count=frm.grids[0].grid.grid_rows.length;
var cur_grid= frm.grids[0].grid
var find_exist_row = “no”;
for (var i = 0; i < row_count; i++) {
if (cur_grid.grid_rows[i].doc.item_code ===undefined) {
find_exist_row = “empty”;
break;
}
else if (cur_grid.grid_rows[i].doc.item_code ===r.item_code) {
find_exist_row = “yes”;
break;
}
}
if (find_exist_row === “no”){
var new_row= cur_grid.add_new_row()
if (new_row !==undefined){
frappe.model.set_value(cur_grid.doctype, new_row.name, “item_code”, r.item_code);
};
}
else if (find_exist_row === “empty”){
frappe.model.set_value(cur_grid.doctype, cur_grid.grid_rows[i].doc.name, “item_code”, r.item_code);
}
else{
if (cur_grid.grid_rows[i].doc.qty !=undefined){
frappe.model.set_value(cur_grid.doctype, cur_grid.grid_rows[i].doc.name, “qty”, cur_grid.grid_rows[i].doc.qty + 1);
}
}
}
});
frm.set_value(‘scan_bar_code’,’’);
}
return false;
}
})
I am getting the following error:
SyntaxError: Invalid or unexpected token
at Class.setup (https://pratham.erpnext.com/assets/js/form.min.js?ver=1529656413.0:2691:18)
at _f.Frm.setup (https://pratham.erpnext.com/assets/js/form.min.js?ver=1529656413.0:172:22)
at _f.Frm.refresh (https://pratham.erpnext.com/assets/js/form.min.js?ver=1529656413.0:446:9)
at Class.load (https://pratham.erpnext.com/assets/js/form.min.js?ver=1529656413.0:87:33)
at https://pratham.erpnext.com/assets/js/form.min.js?ver=1529656413.0:73:10
at Object.callback (https://pratham.erpnext.com/assets/js/desk.min.js?ver=1529656413.0:5516:6)
at Object.callback [as success_callback] (https://pratham.erpnext.com/assets/js/desk.min.js?ver=1529656413.0:1437:16)
at _ (https://pratham.erpnext.com/assets/js/desk.min.js?ver=1529656413.0:1461:34)
at Object. (https://pratham.erpnext.com/assets/js/desk.min.js?ver=1529656413.0:1562:5)
at i (https://pratham.erpnext.com/assets/frappe/js/lib/jquery/jquery.min.js:2:27151)
Please help me with this error.
I really appreciate the efforts by @szufisher
