details: https://code.openbravo.com/erp/devel/pi/rev/acfcd2e5f752 changeset: 25220:acfcd2e5f752 user: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com> date: Fri Nov 07 22:08:50 2014 -0500 summary: Fixed bug 28069: There is no filter in the tax combo of Insert Orphan Line.
Tax combo validation rule now filters by Return From Customer window header defined organization and product's tax category. Tax combo in Insert Orphan Line pop up window will show taxes that belongs to the selected product tax category and header's organization. diffstat: src-db/database/sourcedata/AD_VAL_RULE.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diffs (12 lines): diff -r 88f346f9fcf1 -r acfcd2e5f752 src-db/database/sourcedata/AD_VAL_RULE.xml --- a/src-db/database/sourcedata/AD_VAL_RULE.xml Wed Nov 12 09:24:21 2014 +0100 +++ b/src-db/database/sourcedata/AD_VAL_RULE.xml Fri Nov 07 22:08:50 2014 -0500 @@ -1349,7 +1349,7 @@ <!--299FA667CF374AC5ACC74739C3251134--> <NAME><![CDATA[C_Tax IsSOTrx]]></NAME> <!--299FA667CF374AC5ACC74739C3251134--> <DESCRIPTION><![CDATA[Validate tax depending on is Sales or Purchase transaction]]></DESCRIPTION> <!--299FA667CF374AC5ACC74739C3251134--> <TYPE><![CDATA[S]]></TYPE> -<!--299FA667CF374AC5ACC74739C3251134--> <CODE><![CDATA[(C_TAX.SOPOTYPE =(CASE WHEN @IsSOTrx@ = 'Y' THEN 'S' ELSE 'P' END) OR C_TAX.SOPOTYPE = 'B') AND C_TAX.AD_CLIENT_ID=@AD_CLIENT_ID@ AND C_TAX.C_TAX_ID=(CASE WHEN @IsSOTrx@ = 'Y' AND EXISTS(SELECT 1 FROM AD_ORGINFO WHERE ISTAXUNDEDUCTABLE='Y' AND AD_ORG_ID=@AD_ORG_ID@) THEN (SELECT C_TAX_ID FROM AD_ORGINFO WHERE ISTAXUNDEDUCTABLE='Y' AND AD_ORG_ID=@AD_ORG_ID@) ELSE C_TAX.C_TAX_ID END)]]></CODE> +<!--299FA667CF374AC5ACC74739C3251134--> <CODE><![CDATA[(C_TAX.SOPOTYPE =(CASE WHEN @IsSOTrx@ = 'Y' THEN 'S' ELSE 'P' END) OR C_TAX.SOPOTYPE = 'B') AND C_TAX.AD_CLIENT_ID=@AD_CLIENT_ID@ AND AD_ISORGINCLUDED(@AD_ORG_ID@, C_TAX.AD_ORG_ID, @#AD_Client_ID@) <> '-1' AND C_TAX.C_TAXCATEGORY_ID = (SELECT C_TAXCATEGORY_ID FROM M_PRODUCT WHERE M_PRODUCT_ID=@M_PRODUCT_ID@) AND C_TAX.C_TAX_ID=(CASE WHEN @IsSOTrx@ = 'Y' AND EXISTS(SELECT 1 FROM AD_ORGINFO WHERE ISTAXUNDEDUCTABLE='Y' AND AD_ORG_ID=@AD_ORG_ID@) THEN (SELECT C_TAX_ID FROM AD_ORGINFO WHERE ISTAXUNDEDUCTABLE='Y' AND AD_ORG_ID=@AD_ORG_ID@) ELSE C_TAX.C_TAX_ID END)]]></CODE> <!--299FA667CF374AC5ACC74739C3251134--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--299FA667CF374AC5ACC74739C3251134--></AD_VAL_RULE> ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
