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 _______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-accounting Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
