details: https://code.openbravo.com/erp/devel/pi/rev/f2e13b05a16c changeset: 28073:f2e13b05a16c user: Atul Gaware <atul.gaware <at> openbravo.com> date: Mon Nov 30 17:55:31 2015 +0530 summary: Fixes Issue 31563:BOM production report is not showing the whole information
Where clause excluded the BOM record on To Date of report filter. Now it is updated to consider such records. details: https://code.openbravo.com/erp/devel/pi/rev/d55b978161d6 changeset: 28074:d55b978161d6 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Tue Dec 01 10:16:54 2015 +0100 summary: Related to issue 31563: code review improvements Truncated MovementDate to be sure the <= and >= comparations work fine with the datetime field diffstat: src/org/openbravo/erpCommon/ad_reports/productionSubReport.jrxml | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diffs (14 lines): diff -r 873c8764054e -r d55b978161d6 src/org/openbravo/erpCommon/ad_reports/productionSubReport.jrxml --- a/src/org/openbravo/erpCommon/ad_reports/productionSubReport.jrxml Thu Nov 26 14:08:38 2015 +0100 +++ b/src/org/openbravo/erpCommon/ad_reports/productionSubReport.jrxml Tue Dec 01 10:16:54 2015 +0100 @@ -36,8 +36,8 @@ AND M_PRODUCTION.AD_ORG_ID IN ($P!{USER_ORG}) AND M_PRODUCTION.PROCESSED = 'Y' AND M_PRODUCTIONLINE.MOVEMENTQTY > 0 - AND M_PRODUCTION.MOVEMENTDATE >= $P{DATE_FROM} - AND M_PRODUCTION.MOVEMENTDATE < $P{DATE_TO} + AND TRUNC(M_PRODUCTION.MOVEMENTDATE) >= $P{DATE_FROM} + AND TRUNC(M_PRODUCTION.MOVEMENTDATE) <= $P{DATE_TO} AND M_PRODUCTION.ISSOTRX = 'Y' GROUP BY M_PRODUCT.NAME, C_UOM.NAME HAVING SUM(ROUND(M_PRODUCTIONLINE.MOVEMENTQTY,2)) > 0]]> ------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
