How to make "Expiry" default value in "Add batch Nos" form

deepak19 · June 24, 2024, 12:19pm

Hello Everyone,

Is there a way to make “Expiry” the default value in the drop menu “fetch based on” in “Add batch Nos” form.

Thanks,
Deepak

NCP · June 24, 2024, 12:25pm

Please set the default in below file.

frappe/erpnext/blob/version-15/erpnext/public/js/utils/serial_no_batch_selector.js#L357-L364


      
          			{
          				fieldtype: "Select",
          				options: ["FIFO", "LIFO", "Expiry"],
          				default: "FIFO",
          				fieldname: "based_on",
          				label: __("Fetch Based On"),
          				onchange: () => this.get_auto_data(),
          			},

deepak19 · June 25, 2024, 4:53am

Thank you very much @NCP . I am using erpnext hosted on frappe cloud so I don’t think I’ll be able to change the js file. Can it be done through form customization from the dashboard?

NCP · June 25, 2024, 4:57am

Not possible, but you can override it in your custom app.

deepak19 · June 25, 2024, 5:03am

Okay Nihantra! Thanks again for the information.

NCP · June 25, 2024, 5:04am

Hi @deepak19,

Which doctype do you want to set this?

deepak19 · June 25, 2024, 5:12am

Hi @NCP ,

I am using Sales Invoice. While adding a product, I want the “batch no.” to be fetched based on " Expiry" of the product instead of FIFO.

NCP · June 25, 2024, 5:19am

Okay, i have an option, first copy the whole code and paste it in the client script. and set the default value.

Output:

Test it on your according.

deepak19 · June 25, 2024, 5:25am

Should I paste the code in the “your code section”
frappe.ui.form.on(‘Sales Invoice’, {
refresh(frm) {
// your code here
}
})

NCP · June 25, 2024, 5:26am

No, please check the video (end part), that i provide.

deepak19 · June 25, 2024, 5:38am

Thanks a lot @NCP . The code is working perfectly.