← Back to team overview

openerp-expert-accounting team mailing list archive

rounding issues stock product qty

 

Hello!
please could some of you check 

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); 

for 1 product I get

 product_id |    sum    |   round   
------------+-----------+-----------
         36 | 336708.38 | 336708.38

Thanks

Best Regards

ChriCar Beteiligungs- und Beratungs- GmbH
http://www.chricar.at/ChriCar/index.html
Dr. Ferdinand Gassauer
Official Tiny Partner

Follow ups