odoo 16 sales reports. can we add customer adres field in the reports?

Question

Hi All,

When i go to the sales module and go to reports i can filter the reports on Products, and Customer.

I Then see the Customers name only. Is there a way to add the adres also within the reports?

kind regards,

Chris

Niyas Raphy (Walnut IT) · Answer

Hi,
As this is not possible directly from the ui using developer mode tools or using the studio, it has to be done from the code side via custom module.
You have to inherit the corresponding model , ie, sale.report model and add the new fields to it and adjust the select query to bring the necessary info from the partner of that order.

In order to customize the sale report model from code, you can refer this video explaining the same:  How To Add New Field To Sale Report Model In Odoo [1]
Thank

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
In
Odoo 16, there's no option to filter the sales report based on the
customer address. But you can filter the sales report based on the
customer's country by adding a custom filter.
Hope it helps

This question has been flagged

Enjoying the discussion? Don't just read, join in!