Try ERPNext Buy Support Partners Foundation

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

#1

image-20200507021355749
image-202005070213557491111×602 26.7 KB

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,
    
});
14 Likes
Stock quantity on hand
#2

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.

1 Like
#3

Good sharing!

1 Like
#4

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

1 Like
#5

@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();  
                        }
                    }
                });     
        }
    		
    	}
    });
4 Likes
#6

I think this what you need

2 Likes
#7

Dear Bro ,

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

Many Thanks

Yassin

image
image1182×848 192 KB

#8

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

1 Like
#9

You may need to change this line for other doctypes.

const item_row = locals["Sales Invoice Item"][current_doc];
1 Like
#10

many many thanks Bro , great Job

Frappé Technologies Pvt Ltd, Mumbai