Skip to Content
This question has been flagged
analyticalreportingreceivableanalysisSales
2 Respostes
3630 Vistes
Avatar
Zuhair

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.

Avatar
Descartar
Avatar
Dinesh Pandey (dipa)
Best 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



Avatar
Descartar
Avatar
Ajin A K
Best Answer

Dear Zuhair,

In Odoo Studio, to add the "Effective Date" field to your view:

  1. Click the "+ Add" section.
  2. Scroll down and expand the "Existing Fields" section.
  3. Search for "Effective Date" in the list of fields.
  4. Drag and drop the "Effective Date" field to the desired location on your form.



Avatar
Descartar
Zuhair
Autor

Thank you for your response.

We trying to add the Effective Date in sale.report model in list view. But the Effective Date is not available in the existing field.

Related Posts Respostes Vistes Activitat
Odoo 12 - Report of Sales by Month, Country, State Solved
reporting Sales
Avatar
Avatar
Avatar
2
de juny 21
8178
Reporting Tools
analytical reporting tools
Avatar
0
de març 23
3224
Problem to search
reporting reports receivable
Avatar
0
d’oct. 22
2677
What do the number in the parenthesis at the Inventory Analysis means?
warehouse reporting analysis
Avatar
Avatar
1
d’abr. 16
4664
How to add cusome analysis on reporting Tab
mrp reporting analysis
Avatar
0
d’ag. 15
4101