Add Update Cost Button for Custom Doctype

nilpatel42 · May 13, 2024, 10:29am

I want add Custom Button to my custom doctype to update price field (child table field) like BOM

NCP · May 13, 2024, 10:35am

Please check the bom code:

frappe/erpnext/blob/develop/erpnext/manufacturing/doctype/bom/bom.js#L99-L101


      
          			frm.add_custom_button(__("Update Cost"), function () {
          				frm.events.update_cost(frm, true);
          			});

github.com

frappe/erpnext/blob/develop/erpnext/manufacturing/doctype/bom/bom.js#L385-L400


      
          	update_cost(frm, save_doc = false) {
          		return frappe.call({
          			doc: frm.doc,
          			method: "update_cost",
          			freeze: true,
          			args: {
          				update_parent: true,
          				save: save_doc,
          				from_child_bom: false,
          			},
          			callback(r) {
          				refresh_field("items");
          				if (!r.exc) frm.refresh_fields();
          			},
          		});
          	},

github.com

frappe/erpnext/blob/develop/erpnext/manufacturing/doctype/bom/bom.py#L466-L508


      
          	@frappe.whitelist()
          	def update_cost(self, update_parent=True, from_child_bom=False, update_hour_rate=True, save=True):
          		if self.docstatus == 2:
          			return
          
          		self.flags.cost_updated = False
          		existing_bom_cost = self.total_cost
          
          		if self.docstatus == 1:
          			self.flags.ignore_validate_update_after_submit = True
          
          		self.calculate_cost(save_updates=save, update_hour_rate=update_hour_rate)
          
          		if save:
          			self.db_update()
          
          		# update parent BOMs
          		if self.total_cost != existing_bom_cost and update_parent:
          			parent_boms = frappe.db.sql_list(
          				"""select distinct parent from `tabBOM Item`

This file has been truncated. show original

explore it and develop it your own way according to the scenario.

nilpatel42 · May 13, 2024, 11:30am

instead of this long code i tried this way,
i remove all price from doctype and when i save doctype refetch the value

frappe.ui.form.on('CE Price List', {
    refresh: function(frm) {
        frm.add_custom_button(__('Clear Price Field'), function() {
            clearPriceField(frm);
        });
    }
});

function clearPriceField(frm) {
    var childTableRows = frm.doc.item_list || [];

    for (var i = 0; i < childTableRows.length; i++) {
        var childRow = childTableRows[i];
        childRow.price = ''; 
    }
    frm.refresh_fields('item_list');
    frm.dirty(true);
}

Thank You for reply @NCP