Merge lp:~unifield-team/unifield-server/us-1657 into lp:unifield-server

[jftempo]

=== modified file 'bin/addons/stock/stock.py'
--- bin/addons/stock/stock.py	2016-08-26 12:47:12 +0000
+++ bin/addons/stock/stock.py	2016-09-06 13:26:39 +0000
@@ -436,7 +436,7 @@
                           WHERE location_dest_id=%s AND
                                 location_id<>%s AND
                                 product_id=%s AND
-                                state='done' AND (expired_date is null or expired_date >= now())
+                                state='done' AND (expired_date is null or expired_date >= CURRENT_DATE)
                           GROUP BY product_uom
                        """,
                        (id, id, product_id))
@@ -447,7 +447,7 @@
                                 location_dest_id<>%s AND
                                 product_id=%s AND
                                 state in ('done', 'assigned')
-                                AND (expired_date is null or expired_date >= now())
+                                AND (expired_date is null or expired_date >= CURRENT_DATE)
                           GROUP BY product_uom
                        """,
                        (id, id, product_id))