Automatic update Item Price from Purchase Invoice

Frappe Framework Custom Script
#1

Need to create a Custom Script to update Item Price as per Purchase Invoice Item price_list_rate value

Please check the script

frappe.ui.form.on("Purchase Invoice Item", {
	item_code: function(frm, cdt, cdn) {
		child = locals[cdt][cdn];
		me.frm.call({
			method: "frappe.client.get_value",
			args: {
				doctype: "Item Price",
				fieldname: "price_list_rate",
				filters: { item_code: child.item_code, price_list_rate: child.price_list_rate },
			},
			callback: function(r, rt) {
				if(r.message) {
					frappe.model.set_value(cdt, cdn, 'price_list_rate', r.message.price_list_rate)
				}
			}
		});
	}
})

–
Skedia

#2

Should be

frappe.ui.form.on("Purchase Invoice ", { 
} )

Seems wrong filter price_list_rate: child.price_list_rate
You have to pass price list name

#3

Script not working

Price list = MRP

I want to update price list rate of item purchase as per the price list rate in Purchase Invoice.

frappe.ui.form.on("Purchase Invoice", { item_code: function(frm, cdt, cdn) { child = locals[cdt][cdn]; me.frm.call({ method: "frappe.client.get_value", args: { doctype: "Item Price", fieldname: "price_list_rate", filters: { item_code: child.item_code, price_list : "MRP" }, }, callback: function(r, rt) { if(r.message) { frappe.model.set_value(cdt, cdn, 'price_list_rate', r.message.price_list_rate) } } }); } })

#4

I wanted to have the same functionality. Has anyone figured out how to achieve this?