openerp-expert-accounting team mailing list archive

[Davide Corio <davide.corio@xxxxxxxxxxxx>]

Il giorno mer, 15/09/2010 alle 13.08 +0200, "Borja López Soilán
(Pexego)" ha scritto:
> select product_id ,sum(product_qty), round(sum(product_qty),2) from 
> > stock_move group by product_id having sum(product_qty) != 
> > round(sum(product_qty),4); 

i think that's just a casting problem.
try this way:

select product_id ,sum(product_qty), round(sum(product_qty),2) from 
stock_move group by product_id having sum(product_qty) != 
round(sum(product_qty),4);


regards,
-- 
Davide Corio
email: davide.corio<at>domsense.com
web: http://www.domsense.com