[Tutorial] How to add a Shortcut to get Item Balance with Warehouses in Sales invoice

youssef · May 7, 2020, 12:18am

Put this code in custom script for Sales Invoice and then use “CTRL + Q” shortcut to open the dialog box when you are in the item field, and you can choose from it the warehouse and it will update it to the item.

frappe.ui.keys.add_shortcut({
    shortcut: 'ctrl+q',
    action: () => { 
            const current_doc = $('.data-row.editable-row').parent().attr("data-name");
            const item_row = locals["Sales Invoice Item"][current_doc];
            frappe.call({
                method: 'erpnext.stock.dashboard.item_dashboard.get_data',
                args: {
                    item_code: item_row.item_code,
                },
                callback: function(r) {
                    if (r.message.length > 0){
                        const d = new frappe.ui.Dialog({
                            title: __('Item Balance'),
                            width: 400
                        });
                        $(`<div class="modal-body ui-front">
                            <h2>${item_row.item_code}</h2>
                            <p>Choose Warehouse and click Select :</p>
                            <table class="table table-bordered">
                            <thead>
                                <tr>
                                <th>Check</th>
                                <th>Warehouse</th>
                                <th>Qty</th>
                                <th>UOM</th>
                                </tr>
                            </thead>
                            <tbody>
                            </tbody>
                            </table>
                        </div>`).appendTo(d.body);
                        r.message.forEach(element => {
                            const tbody = $(d.body).find('tbody');
                            const tr = $(`
                            <tr>
                                <td><input type="checkbox" class="check-warehouse" data-warehouse="${element.warehouse}"></td>
                                <td>${element.warehouse}</td>
                                <td>${element.actual_qty}</td>
                                <td>${item_row.stock_uom }</td>
                            </tr>
                            `).appendTo(tbody)
                            tbody.find('.check-warehouse').on('change', function() {
                                $('input.check-warehouse').not(this).prop('checked', false);  
                            });
                        });
                        d.set_primary_action("Select", function() {
                            $(d.body).find('input:checked').each(function(i, input) {
							frappe.model.set_value(item_row.doctype, item_row.name, 'warehouse', $(input).attr('data-warehouse'));
                            });
                            cur_frm.rec_dialog.hide();
                            cur_frm.refresh_fields();
                        });
                        cur_frm.rec_dialog = d;
                        d.show();  
                    }
                }
            });     
    },
    page: this.page,
    description: __('Get Item INFO'),
    ignore_inputs: true,
    
});

fkardame · May 7, 2020, 12:37am

Lovely,
One of our client had such a requirement but for last sales price of the item sold to the selected customer instead of item quantity.

Nice work and thanks for sharing the codes.

szufisher · May 7, 2020, 1:00am

Good sharing!

olamide_shodunke · May 7, 2020, 6:44am

Good show, works as aadvertised.

Looks like you can use this for any doctype with an item table. I tested it on Purchase Receipt and it works

Regards

Eli · May 7, 2020, 12:00pm

@youssef

Thanks a million for sharing this!

Its greatly appreciated

Just thought to share the code below which is compatible with Version 11 for anyone that might benefit.

frappe.ui.keys.on('ctrl+q', function(e) {
    	 {
    		
    		  { 
                const current_doc = $('.data-row.editable-row').parent().attr("data-name");
                const item_row = locals["Sales Invoice Item"][current_doc];
                frappe.call({
                    method: 'erpnext.stock.dashboard.item_dashboard.get_data',
                    args: {
                        item_code: item_row.item_code,
                    },
                    callback: function(r) {
                        if (r.message.length > 0){
                            const d = new frappe.ui.Dialog({
                                title: __('Item Balance'),
                                width: 400
                            });
                            $(`<div class="modal-body ui-front">
                                <h2>${item_row.item_code}</h2>
                                <p>Choose Warehouse and click Select :</p>
                                <table class="table table-bordered">
                                <thead>
                                    <tr>
                                    <th>Check</th>
                                    <th>Warehouse</th>
                                    <th>Qty</th>
                                    <th>UOM</th>
                                    </tr>
                                </thead>
                                <tbody>
                                </tbody>
                                </table>
                            </div>`).appendTo(d.body);
                            r.message.forEach(element => {
                                const tbody = $(d.body).find('tbody');
                                const tr = $(`
                                <tr>
                                    <td><input type="checkbox" class="check-warehouse" data-warehouse="${element.warehouse}"></td>
                                    <td>${element.warehouse}</td>
                                    <td>${element.actual_qty}</td>
                                    <td>${item_row.stock_uom }</td>
                                </tr>
                                `).appendTo(tbody)
                                tbody.find('.check-warehouse').on('change', function() {
                                    $('input.check-warehouse').not(this).prop('checked', false);  
                                });
                            });
                            d.set_primary_action("Select", function() {
                                $(d.body).find('input:checked').each(function(i, input) {
    							frappe.model.set_value(item_row.doctype, item_row.name, 'warehouse', $(input).attr('data-warehouse'));
                                });
                                cur_frm.rec_dialog.hide();
                                cur_frm.refresh_fields();
                            });
                            cur_frm.rec_dialog = d;
                            d.show();  
                        }
                    }
                });     
        }
    		
    	}
    });

youssef · May 7, 2020, 8:13pm

I think this what you need

ESH_FZC · February 16, 2021, 7:26am

Dear Bro ,

Would you let me know for which file I have to edit and add this Script ?

Many Thanks

Yassin

TurkerTunali · February 16, 2021, 4:32pm

Search for “Custom Script” in the awesomebar. Create new script and select Sales Invoices in the document type.

TurkerTunali · February 16, 2021, 4:33pm

You may need to change this line for other doctypes.

const item_row = locals["Sales Invoice Item"][current_doc];

ESH_FZC · February 21, 2021, 9:50am

many many thanks Bro , great Job

ashraf_brzy1 · September 30, 2021, 9:31am

many thanks for sharing @youssef

dann · October 7, 2021, 11:21pm

This might oot from the op but this helped me:

erpnext.stock.doctype.stock_reconciliation.stock_reconciliation.get_items
This will returns all your items with actual qty to date, but for now with no pagination nor filters added…

Thank you…