Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odpovědět
4189 Zobrazení

hello,
is there a way to set group_operator as SUM(DISTINCT column) in reporting :
I have the following view :

```

SELECT   

      sale_id,   

     COUNT( product_id),

    SUM(DISTINCT sale_qty) sale_qty ,

    SUM(delivered_qty) deliveryed_qty

FROM sale_delivery

WHERE sale_id=3063

GROUP BY sale_id

```

Avatar
Zrušit
Nejlepší odpověď

Salamu alaikum,

You will be obliged to create custom reports.

Start with the documentation part explaining Custom Reports and explore the Source Code of the "Account" module

Wish you all the best!

Avatar
Zrušit
Autor

Alaikom salam, I already working in a custom report but in odoo cannot pass group_operation='sum distinct' on the fild sale_qty

Related Posts Odpovědi Zobrazení Aktivita
1
lis 22
5581
1
říj 21
3255
2
lis 18
10167
4
srp 16
5679
4
bře 15
5215