Adding an Additional Column in Sales Analysis Page in Odoo 17.1e SaaS

Question

Hello,

We are currently using Odoo version 17.1e SaaS and need some assistance with customizing the Sales Analysis page. Specifically, we want to add an additional column (Effective Date and Invoice Date) to this page to include more detailed information in our analysis.
We have an error when trying to add a new column.
Does anyone know how this can be achieved?

Thank you.

Dinesh Pandey (dipa) · Answer

Hello,
The *Sales Analysis* (sale.report) is a custom report based on an SQL view.
Adding new fields to it requires modifying the Python code, which unfortunately isn’t possible on SaaS.
You can refer to the following documentation for more details:
Odoo 18.0 – Creating Reports [1]

[1] /documentation/18.0/developer/howtos/create_reports.html

Ajin A K · Answer

Dear  Zuhair [1] ,
In Odoo Studio, to add the "Effective Date" field to your view:
Click the "+ Add" section. Scroll down and expand the "Existing Fields" section. Search for "Effective Date" in the list of fields. Drag and drop the "Effective Date" field to the desired location on your form.

[1] https://www.odoo.com/forum/help-1/adding-an-additional-column-in-sales-analysis-page-in-odoo-17-1e-saas-253797

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Odoo 12 - Report of Sales by Month, Country, State Ratkaistu reporting Sales	2 kesäk. 21	7243
Reporting Tools analytical reporting tools	0 maalisk. 23	2303
Problem to search reporting reports receivable	0 lokak. 22	2101
What do the number in the parenthesis at the Inventory Analysis means? warehouse reporting analysis	1 huhtik. 16	3780
How to add cusome analysis on reporting Tab mrp reporting analysis	0 elok. 15	3333

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!