details: https://code.openbravo.com/erp/devel/pi/rev/d749340d037e changeset: 17813:d749340d037e user: Ioritz Cia <ioritz.cia <at> openbravo.com> date: Thu Aug 30 10:51:12 2012 +0200 summary: Fixes issue 21431: Exchange Rate tab readonly logic modified. Set Exchange Rate at Invoice level when @HASREVERSEDINVOICESO@='Y' but original invoice does NOT have Exchange Rate defined.
diffstat: src-db/database/sourcedata/AD_AUXILIARINPUT.xml | 14 ++++++++++++-- 1 files changed, 12 insertions(+), 2 deletions(-) diffs (31 lines): diff -r 2b882d173e1f -r d749340d037e src-db/database/sourcedata/AD_AUXILIARINPUT.xml --- a/src-db/database/sourcedata/AD_AUXILIARINPUT.xml Thu Aug 30 13:39:45 2012 +0200 +++ b/src-db/database/sourcedata/AD_AUXILIARINPUT.xml Thu Aug 30 10:51:12 2012 +0200 @@ -2193,7 +2193,12 @@ <!--FF80818130F526CB0130F5A6BCC70003--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--FF80818130F526CB0130F5A6BCC70003--> <AD_TAB_ID><![CDATA[FF808181308EA4230130901AB2C60090]]></AD_TAB_ID> <!--FF80818130F526CB0130F5A6BCC70003--> <NAME><![CDATA[HASREVERSEDINVOICEPO]]></NAME> -<!--FF80818130F526CB0130F5A6BCC70003--> <CODE><![CDATA[@SQL=SELECT 'Y' FROM DUAL WHERE EXISTS (SELECT 1 FROM C_INVOICE_REVERSE WHERE C_INVOICE_ID = @C_Invoice_ID@ )]]></CODE> +<!--FF80818130F526CB0130F5A6BCC70003--> <CODE><![CDATA[@SQL=SELECT 'Y' +FROM DUAL +WHERE EXISTS (SELECT 1 FROM C_INVOICE_REVERSE WHERE C_INVOICE_ID = @C_Invoice_ID@ ) +AND EXISTS (SELECT 1 FROM C_CONVERSION_RATE_DOCUMENT WHERE C_INVOICE_ID = (SELECT REVERSED_C_INVOICE_ID + FROM C_INVOICE_REVERSE + WHERE C_INVOICE_ID = @C_Invoice_ID@))]]></CODE> <!--FF80818130F526CB0130F5A6BCC70003--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--FF80818130F526CB0130F5A6BCC70003--></AD_AUXILIARINPUT> @@ -2204,7 +2209,12 @@ <!--FF80818130F526CB0130F5A7BC430006--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--FF80818130F526CB0130F5A7BC430006--> <AD_TAB_ID><![CDATA[FF808181308EA4230130901D313D00A5]]></AD_TAB_ID> <!--FF80818130F526CB0130F5A7BC430006--> <NAME><![CDATA[HASREVERSEDINVOICESO]]></NAME> -<!--FF80818130F526CB0130F5A7BC430006--> <CODE><![CDATA[@SQL=SELECT 'Y' FROM DUAL WHERE EXISTS (SELECT 1 FROM C_INVOICE_REVERSE WHERE C_INVOICE_ID = @C_Invoice_ID@ )]]></CODE> +<!--FF80818130F526CB0130F5A7BC430006--> <CODE><![CDATA[@SQL=SELECT 'Y' +FROM DUAL +WHERE EXISTS (SELECT 1 FROM C_INVOICE_REVERSE WHERE C_INVOICE_ID = @C_Invoice_ID@ ) +AND EXISTS (SELECT 1 FROM C_CONVERSION_RATE_DOCUMENT WHERE C_INVOICE_ID = (SELECT REVERSED_C_INVOICE_ID + FROM C_INVOICE_REVERSE + WHERE C_INVOICE_ID = @C_Invoice_ID@) )]]></CODE> <!--FF80818130F526CB0130F5A7BC430006--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--FF80818130F526CB0130F5A7BC430006--></AD_AUXILIARINPUT> ------------------------------------------------------------------------------ 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
