details: https://code.openbravo.com/erp/devel/pi/rev/ca88d7fa6a96 changeset: 16171:ca88d7fa6a96 user: Naiara Martinez <naiara.martinez <at> openbravo.com> date: Thu Apr 19 17:30:04 2012 +0200 summary: fixed bug 9523 not display summary level in multiphase window
details: https://code.openbravo.com/erp/devel/pi/rev/da699739d61d changeset: 16172:da699739d61d user: Naiara Martinez <naiara.martinez <at> openbravo.com> date: Thu Apr 19 18:21:17 2012 +0200 summary: fixed bug 12605 In M_GENERATE_AVERAGE_COST add isactive and date validations M_PRODUCTPRICE.ISACTIVE='Y' and M_PRICELIST_VERSION.VALIDFROM<Cur_InOutLine.MOVEMENTDATE+1 diffstat: src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml | 3 ++- src-db/database/sourcedata/AD_FIELD.xml | 2 +- 2 files changed, 3 insertions(+), 2 deletions(-) diffs (27 lines): diff -r 689b23c4d359 -r da699739d61d src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml --- a/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Tue Apr 24 12:49:17 2012 +0200 +++ b/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Thu Apr 19 18:21:17 2012 +0200 @@ -463,9 +463,10 @@ ) AND M_PRICELIST_VERSION.M_PRICELIST_VERSION_ID=M_PRODUCTPRICE.M_PRICELIST_VERSION_ID AND M_PRICELIST_VERSION.ISACTIVE='Y' + AND M_PRODUCTPRICE.ISACTIVE='Y' AND M_PRODUCTPRICE.M_PRODUCT_ID=Cur_InOutLine.M_PRODUCT_ID AND M_PRICELIST.M_PRICELIST_ID = M_PRICELIST_VERSION.M_PRICELIST_ID - AND M_PRICELIST_VERSION.VALIDFROM<Cur_InOutLine.MOVEMENTDATE + AND M_PRICELIST_VERSION.VALIDFROM<Cur_InOutLine.MOVEMENTDATE+1 AND M_PRICELIST.AD_CLIENT_ID = v_Client ORDER BY M_PRICELIST_VERSION.VALIDFROM DESC ) diff -r 689b23c4d359 -r da699739d61d src-db/database/sourcedata/AD_FIELD.xml --- a/src-db/database/sourcedata/AD_FIELD.xml Tue Apr 24 12:49:17 2012 +0200 +++ b/src-db/database/sourcedata/AD_FIELD.xml Thu Apr 19 18:21:17 2012 +0200 @@ -8825,7 +8825,7 @@ <!--670--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> <!--670--> <AD_TAB_ID><![CDATA[157]]></AD_TAB_ID> <!--670--> <AD_COLUMN_ID><![CDATA[1360]]></AD_COLUMN_ID> -<!--670--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> +<!--670--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--670--> <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH> <!--670--> <ISREADONLY><![CDATA[N]]></ISREADONLY> <!--670--> <SEQNO><![CDATA[40]]></SEQNO> ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
