Customize Sales order report

Frappe Framework Customization
1

I want to have a sales order report for my delivery, and i want to have a column with the State of address . Is very useful as i can filtrate the orders to have 1 report for each delivery with only the orders he have to make. As im having 1 delivery man per state

2

Hello,

Delivery status is updated in the Sales Order as well. You can make report on the Sales Order itself, and filter items based on it’s delivery status. For more support, check:

https://frappe.github.io/erpnext/user/videos/learn/report-builder.html

3

@Franco_Fadini,

You can add a custom field ‘State’ , select the option ‘filter’, and then use the following custom script for Sales Order to map the state from the address of the customer to your custom field:

cur_frm.add_fetch("Address", "state", "state");

Hope this is what you were looking for.

All the best!