Custom Field In Sales Order

ERPNext
,
1

Dear All Hope All are You Fine & Well.
I added a custom field in Sales Order Item Table Named : (Balance Qty)
I Added a custom Script to compute this field. But it’s not working.
Here is the Custom Script for Reference
Please Guide Thanks.
frappe.ui.form.on(“Sales Order Item”, “qty”, function(frm, cdt, cdn) {
var row = locals[cdt][cdn];
row.balance_qty = row.qty - row.delivered_qty;
refresh_field(“balance_qty”);
});
frappe.ui.form.on(“Sales Order Item”, “delivered_qty”, function(frm, cdt, cdn) {
var row = locals[cdt][cdn];
row.balance_qty = row.qty - row.delivered_qty;
refresh_field(“balance_qty”);
});

2

Use the code below

frappe.ui.form.on("Sales Order Item", {
    qty: function(frm,cdt, cdn){
        balance_qty(frm, cdt, cdn);
    },
    delivered_qty: function(frm, cdt, cdn){
        balance_qty(frm, cdt, cdn);
    }
});
var balance_qty = function(frm, cdt, cdn) {
    var child = locals[cdt][cdn];
    frappe.model.set_value(cdt, cdn, "balance_qty", child.qty - child.delivered_qty);
}
3

Thanks a lot, you Sir, It Works for me.

Best Regards