details: https://code.openbravo.com/erp/devel/pi/rev/9bc482b13d1c changeset: 18129:9bc482b13d1c user: Naiara Garcia <naiara.garcia <at> openbravo.com> date: Wed Oct 03 10:18:37 2012 +0200 summary: Fixed issue 21837: The generate average cost process should not take into account 'incoming/outcoming shipments'
details: https://code.openbravo.com/erp/devel/pi/rev/575ede56584b changeset: 18130:575ede56584b user: Naiara Garcia <naiara.garcia <at> openbravo.com> date: Fri Oct 05 08:27:15 2012 +0200 summary: Related to issue 21695: Generate Commission button not visible for inactive commissions diffstat: src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml | 4 ++-- src-db/database/sourcedata/AD_TAB.xml | 3 +++ 2 files changed, 5 insertions(+), 2 deletions(-) diffs (36 lines): diff -r 844a839ef0ac -r 575ede56584b src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml --- a/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Thu Oct 04 18:18:58 2012 +0200 +++ b/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Fri Oct 05 08:27:15 2012 +0200 @@ -118,7 +118,7 @@ AND M_INOUT.ISSOTRX='N' AND M_INOUT.PROCESSED='Y' AND M_INOUTLINE.MOVEMENTQTY>0 - AND M_INOUT.DOCSTATUS <> 'DR' AND M_INOUT.DOCSTATUS <> 'RE' AND M_INOUT.DOCSTATUS <> 'VO' + AND M_INOUT.DOCSTATUS <> 'DR' AND M_INOUT.DOCSTATUS <> 'RE' AND M_INOUT.DOCSTATUS <> 'VO' AND ISLOGISTIC = 'N' AND M_INOUT.AD_CLIENT_ID = v_Client AND NOT EXISTS (SELECT 1 FROM M_COSTING WHERE M_INOUTLINE_ID=M_INOUTLINE.M_INOUTLINE_ID); @@ -359,7 +359,7 @@ AND M_INOUT.ISSOTRX='N' AND M_INOUT.PROCESSED='Y' AND M_INOUTLINE.MOVEMENTQTY>0 - AND M_INOUT.DOCSTATUS <> 'DR' AND M_INOUT.DOCSTATUS <> 'RE' AND M_INOUT.DOCSTATUS <> 'VO' + AND M_INOUT.DOCSTATUS <> 'DR' AND M_INOUT.DOCSTATUS <> 'RE' AND M_INOUT.DOCSTATUS <> 'VO' AND ISLOGISTIC = 'N' AND M_INOUT.AD_CLIENT_ID = v_Client AND M_INOUT.MOVEMENTDATE >= v_MinDateCosting AND NOT EXISTS diff -r 844a839ef0ac -r 575ede56584b src-db/database/sourcedata/AD_TAB.xml --- a/src-db/database/sourcedata/AD_TAB.xml Thu Oct 04 18:18:58 2012 +0200 +++ b/src-db/database/sourcedata/AD_TAB.xml Fri Oct 05 08:27:15 2012 +0200 @@ -4285,8 +4285,11 @@ <!--355--> <HASTREE><![CDATA[N]]></HASTREE> <!--355--> <PROCESSING><![CDATA[N]]></PROCESSING> <!--355--> <ISSORTTAB><![CDATA[N]]></ISSORTTAB> +<!--355--> <FILTERCLAUSE><![CDATA[C_Commission.IsActive='Y']]></FILTERCLAUSE> <!--355--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--355--> <UIPATTERN><![CDATA[STD]]></UIPATTERN> +<!--355--> <HQLFILTERCLAUSE><![CDATA[e.active='Y']]></HQLFILTERCLAUSE> +<!--355--> <FILTERNAME><![CDATA[Active commissions]]></FILTERNAME> <!--355--> <SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS> <!--355--> <EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD> <!--355--> <EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE> ------------------------------------------------------------------------------ Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
