details: /erp/devel/pi/rev/e9b0a01aa669
changeset: 10968:e9b0a01aa669
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Wed Mar 02 11:40:14 2011 +0100
summary: Fixes issue 0016045: It is not possible to void an invoice with
conversion rate
It has been applied the function TRUNC to remove the hours and minutes to the
conversion date and also it has been removed the raise exception instruction
that hid the error conversion message
diffstat:
src-db/database/model/functions/C_CURRENCY_RATE.xml | 2 +-
src-db/database/model/functions/C_INVOICE_POST.xml | 1 -
2 files changed, 1 insertions(+), 2 deletions(-)
diffs (23 lines):
diff -r 1c5978b0d8c4 -r e9b0a01aa669
src-db/database/model/functions/C_CURRENCY_RATE.xml
--- a/src-db/database/model/functions/C_CURRENCY_RATE.xml Wed Mar 02
09:42:58 2011 +0100
+++ b/src-db/database/model/functions/C_CURRENCY_RATE.xml Wed Mar 02
11:40:14 2011 +0100
@@ -88,7 +88,7 @@
WHERE C_Currency_ID = v_CurrencyFrom
AND C_Currency_ID_To = v_CurrencyTo
AND ConversionRateType = v_RateType
- AND v_ConvDate BETWEEN ValidFrom AND ValidTo
+ AND TRUNC(v_ConvDate) BETWEEN ValidFrom AND ValidTo
AND AD_Client_ID IN ('0', p_Client_ID)
AND AD_Org_ID IN ('0', p_Org_ID)
AND IsActive = 'Y'
diff -r 1c5978b0d8c4 -r e9b0a01aa669
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Wed Mar 02
09:42:58 2011 +0100
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Wed Mar 02
11:40:14 2011 +0100
@@ -626,7 +626,6 @@
END IF;
END_PROCESSING:=TRUE;
END IF;
- EXCEPTION WHEN OTHERS THEN RAISE NO_DATA_FOUND;
END; -- FOR COMMIT
END IF;--FINISH_PROCESS
IF (NOT FINISH_PROCESS AND NOT END_PROCESSING) THEN
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
