How to add column in Script Report?

Carlo_Benitez1 · September 25, 2017, 5:16am

how to add column in Script Report?

jithendra · September 25, 2017, 6:18am

frappe/erpnext/blob/develop/erpnext/accounts/report/item_wise_sales_register/item_wise_sales_register.py#L73


      
          			"item_group": item_record.item_group if item_record else d.item_group,
          			"description": d.description,
          			"invoice": d.parent,
          			"posting_date": d.posting_date,
          			"customer": d.customer,
          			"customer_name": customer_record.customer_name,
          			"customer_group": customer_record.customer_group,
          		}
          
          
		if additional_query_columns:
          			for col in additional_query_columns:
          				row.update({col: d.get(col)})
          
          
		row.update(
          			{
          				"debit_to": d.debit_to,
          				"mode_of_payment": ", ".join(mode_of_payments.get(d.parent, [])),
          				"territory": d.territory,
          				"project": d.project,
          				"company": d.company,
          				"sales_order": d.sales_order,

You can add your columns after “Customer Name”.
like this _("Customer Name") + "::120", _("Branch") + "::120"]

Pawan · September 25, 2017, 6:18am

You will have to modify server side code for this. Refer to the following link for more details.

Carlo_Benitez1 · September 25, 2017, 6:29am

tnx sir @Pawan i’ll try .

Carlo_Benitez1 · September 25, 2017, 9:42am

thanks sir @Pawan

Pawan · September 25, 2017, 10:02am