details: https://code.openbravo.com/erp/devel/pi/rev/bf3f4a3acfda
changeset: 22931:bf3f4a3acfda
user: Carlos Aristu <carlos.aristu <at> openbravo.com>
date: Fri May 02 08:31:26 2014 +0200
summary: fixes issue 25721: Should be possible to set 349 corrective flag
in Manual Reversed Invoices already processed
diffstat:
src-db/database/model/triggers/C_INVOICE_REVERSE_TRG.xml | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)
diffs (18 lines):
diff -r 6d818cd5ed38 -r bf3f4a3acfda
src-db/database/model/triggers/C_INVOICE_REVERSE_TRG.xml
--- a/src-db/database/model/triggers/C_INVOICE_REVERSE_TRG.xml Wed Apr 30
17:38:05 2014 +0200
+++ b/src-db/database/model/triggers/C_INVOICE_REVERSE_TRG.xml Fri May 02
08:31:26 2014 +0200
@@ -53,7 +53,13 @@
WHERE C_INVOICE_ID=:NEW.REVERSED_C_INVOICE_ID;
IF ((v_isposted='Y') OR (v_isprocessed='Y' AND v_docstatus<>'VO')) THEN
- RAISE_APPLICATION_ERROR(-20000, '@20501@') ;
+ IF (UPDATING) THEN
+ IF (:NEW.REVERSED_C_INVOICE_ID <> :OLD.REVERSED_C_INVOICE_ID) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@20501@') ;
+ END IF;
+ ELSE
+ RAISE_APPLICATION_ERROR(-20000, '@20501@') ;
+ END IF;
END IF;
IF (UPDATING) THEN
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
