Add option , Group By at Reports

Ahmedyousef15 · May 29, 2023, 10:07am

I want to add option group by ( some fields ) like the group by at item wise sales register.

because i want to show data by different views.

NCP · May 29, 2023, 10:34am

That for, you should develop the new custom server script report.

Then collect the base script and added your option in js and py files like:
First, add the custom field (having a master field) in the below line.

"options": ["Customer Group", "Customer", "Item Group", "Item", "Territory", "Invoice", "Custom Field"]

Reference:

github.com

frappe/erpnext/blob/develop/erpnext/accounts/report/item_wise_sales_register/item_wise_sales_register.js#L61-L61


      
          			"options": ["Customer Group", "Customer", "Item Group", "Item", "Territory", "Invoice"]

Then add the custom field-related scenario in the report py file.
wherever used in the territory in the report, use the custom field after territory.

github.com

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

# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
# License: GNU General Public License v3. See license.txt


import frappe
from frappe import _
from frappe.model.meta import get_field_precision
from frappe.utils import cstr, flt
from frappe.utils.xlsxutils import handle_html

from erpnext.accounts.report.sales_register.sales_register import get_mode_of_payments
from erpnext.selling.report.item_wise_sales_history.item_wise_sales_history import (
	get_customer_details,
	get_item_details,
)


def execute(filters=None):
	return _execute(filters)

This file has been truncated. show original

I hope this helps.

Thank You!

Ahmedyousef15 · May 29, 2023, 11:45am

i don’t have permission to get py files at server , can i insert the server script from browser (user interface)?

NCP · May 29, 2023, 11:52am

that for developing the custom app.
In the user interface view to server script report develops, it is complex.