Addition Column Delivery Note Date in Get From Delivery Note

2002 · February 25, 2016, 11:39am

Sir,

I want to display a filed delivery note date when I click, Get Item from Delivery Note then one link filed appears with delivery Note Number.

Sangram · February 25, 2016, 12:58pm

@2002
you have to make changes in queries.py > get_delivery_notes_to_be_billed method

github.com

frappe/erpnext/blob/develop/erpnext/controllers/queries.py#L216


      
          
          
	if isinstance(filters, str):
          		filters = json.loads(filters)
          
          
	# Get searchfields from meta and use in Item Link field query
          	meta = frappe.get_meta(doctype, cached=True)
          	searchfields = meta.get_search_fields()
          
          
	columns = ""
          	extra_searchfields = [field for field in searchfields if not field in ["name", "description"]]
          
          
	if extra_searchfields:
          		columns += ", " + ", ".join(extra_searchfields)
          
          
	if "description" in searchfields:
          		columns += """, if(length(tabItem.description) > 40, \
          			concat(substr(tabItem.description, 1, 40), "..."), description) as description"""
          
          
	searchfields = searchfields + [
          		field
          		for field in [searchfield or "name", "item_code", "item_group", "item_name"]

replace with this >

return frappe.db.sql("""select `tabDelivery Note`.name, `tabDelivery Note`.customer_name,`tabDelivery Note`.posting_date

2002 · February 25, 2016, 1:04pm

Great Sir!!!

But please tell me that how can I change source code? Can I do with custom script.?

Thanks
Mithilesh

Sangram · February 25, 2016, 1:07pm

@2002

Just replace line no 216 from queries.py with below code . Save file and try

return frappe.db.sql("""select `tabDelivery Note`.name, `tabDelivery Note`.customer_name,`tabDelivery Note`.posting_date