Can I search via brand and view stock in the item list of Sales Invoice?

zeeeeeeeero · September 18, 2023, 6:01am

I would like to be able to search via brand and see how much stock is available here

Safvan_Ph · September 18, 2023, 12:41pm

Hi @zeeeeeeeero
Yes, you can search for items by brand. To do that, you need to add the ‘brand’ field to the ‘Search Fields’ in the customized form of the ‘Item’ doctype.

zeeeeeeeero · September 19, 2023, 4:48am

Okay this worked. Thankyou! Any idea on how to show stock in the search like I showed?

Safvan_Ph · September 19, 2023, 5:17am

Hi @zeeeeeeeero ,
I’m not sure but I think you need to override the add multiple function to include the available stock of the item, or you may only require this function in the sales invoice. In that case, it would be better to add a custom button, such as add multiple, using the MultiSelectDialog Dialog API.
You Can refer the add multiple function:

github.com

frappe/frappe/blob/8c91e46563aacd0e04d5d12ebe0e004f8f162afb/frappe/public/js/frappe/form/grid.js

// Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
// MIT License. See license.txt

import GridRow from "./grid_row";

frappe.ui.form.get_open_grid_form = function() {
	return $(".grid-row-open").data("grid_row");
}

frappe.ui.form.close_grid_form = function() {
	var open_form = frappe.ui.form.get_open_grid_form();
	open_form && open_form.hide_form();

	// hide editable row too
	if(frappe.ui.form.editable_row) {
		frappe.ui.form.editable_row.toggle_editable_row(false);
	}
}

This file has been truncated. show original

You Can refer the MultiSelectDialog:
https://frappeframework.com/docs/user/en/api/dialog#frappe-ui-form-multiselectdialog

zeeeeeeeero · September 19, 2023, 5:18am

Can I add this code from the GUI without changing the source code of my custom app?

Safvan_Ph · September 19, 2023, 5:44am

I think you need this in the Sales Invoice only, so it’s better to hide this button and create your own using the Dialog API. Have mentioned the link already.