跳至内容
菜单
此问题已终结
1 回复
4210 查看

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

```

形象
丢弃
最佳答案

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!

形象
丢弃
编写者

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

相关帖文 回复 查看 活动
1
11月 22
5587
1
10月 21
3265
2
11月 18
10171
4
8月 16
5698
4
3月 15
5218