Warning for End of Life Products

Frappe Framework Custom Script
1

When selecting products which have passed the end of life date, the system will display a prompt to warn the users. This is my current script but it is not working.

Pasted image1151Ă—421 17.6 KB

frappe.ui.form.on("Quotation Item", "end_of_life", function(frm) { if (frm.doc.items.end_of_life < get_today()) { msgprint("You can not select past date in From Date"); validated = false; } });

end of life date is located in Quotation Item table.

Pasted image1139Ă—337 10.3 KB

please help!

2

I dont think that quotation item table has end of life fields… did you insert that field?
https://frappe.github.io/erpnext/current/models/selling/quotation_item.html

3

Yes, I have already inserted that field and the “End of Life” is field is populated as above screenshot.However, the script is not working.

4

Hi @Justin_Lu,

frm.doc.items.end_of_life

here frm.doc.items is the list of Quotation Items, you will need the object of current items then only you can get the valid end_of_life value.

please try,

frappe.ui.form.on(“Quotation Item”, “end_of_life”, function(frm, cdt, cdn) {
item = locals[cdt][cdn];
if(item.end_of_life < get_today()){
// js code
}
}

Thanks, Makarand

1 Like