Add Filter to Sales Analysis Pivot

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Add Filter to Sales Analysis Pivot

searchview inherited pivot v14

1 Odpowiedz

6666 Widoki

Bernardo

Hello, its hard to find useful and detailed documentation for Odoo, thats why i have the next question:

How can I add a custom field to the Sales Analysis dropdown filter?

I've created an inhertied report view like:
```<record id="view_order_product_search_inherit" model="ir.ui.view">

<field name="name">sale.report.search.extend</field>

<field name="model">sale.report</field>

</search>

</field>

</record>```

And its corresponding model like:
```

class SaleReportExtended(models.Model):

_inherit = "sale.report"

is_paid = fields.Boolean(string='Is Paid?', readonly=True)

```

and the field now appears on the dropdown, but when i click on it i get:
```

psycopg2.ProgrammingError: column sale_report.is_paid does not exist
LINE 2: ...t"."price_subtotal") AS "price_subtotal",coalesce("sale_repo..

```

AFAIK the column should be added when you install the module, but looks like it isn't the case

Also I'm not sure, how should i link the `is_paid` field from the report model to the `is_paid` field from the Sale.Order

thanks

Bernard Anyan - Mensah

Hi,

I am facing the same problem, followed your solution but I keep getting

in _query
    return super(SaleReportBranch, self)._query(with_clause, fields, groupby, from_clause)
TypeError: SaleReport._query() takes 1 positional argument but 5 were given

Any suggestions ?

Cybrosys Techno Solutions Pvt.Ltd

Hi,

For adding a custom field to the Sales Analysis drop down filter, first you have to add the same custom field in the model sale.order and sale.report.
Then modify the existing query to add the new groupby feature in sales analysis.

def _query(self, with_clause='', fields={}, groupby='', from_clause=''):
    fields['custom_field'] = ", s. custom_field as custom_field"
    groupby += ', s.custom_field '
    return super(ClassName, self)._query(with_clause, fields, groupby, from_clause)

Regards

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How to add new field into pivot table? pivot v14 account.invoice.report	2 paź 23	7358
ver.14: inherited view, problem appearance of custom field Rozwiązane many2many inherited v14	2 mar 21	4000
How to create a pivot view with every employee employee pivot v14 timeoff	1 maj 23	7871
show measures for specific group in pivot and graph views graph groups measure pivot v14	1 lis 22	2961
Sending Attendances List View to Speadsheet in Odoo Documents V14 Enterprise pivot checkout v14 Attendances Checkin	1 sie 21	2418

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!