details: /erp/devel/pi/rev/3b6e4f163a47
changeset: 8842:3b6e4f163a47
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Tue Nov 09 17:09:29 2010 +0530
summary: Fixes issue 14946: Possible to delete manage requisition line when
manage requisition is completed
Condition has been added that will not allow lines to be deleted if document
status is completed
diffstat:
src-db/database/model/triggers/M_REQUISITIONLINE_TRG.xml | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diffs (14 lines):
diff -r 38bc1ad2e842 -r 3b6e4f163a47
src-db/database/model/triggers/M_REQUISITIONLINE_TRG.xml
--- a/src-db/database/model/triggers/M_REQUISITIONLINE_TRG.xml Tue Nov 09
12:32:11 2010 +0530
+++ b/src-db/database/model/triggers/M_REQUISITIONLINE_TRG.xml Tue Nov 09
17:09:29 2010 +0530
@@ -46,6 +46,10 @@
IF (v_DocStatus = 'CO' AND INSERTING) THEN
RAISE_APPLICATION_ERROR(-20525, 'It is not possible insert a new line in a
completed requisition');
END IF;
+
+ IF (v_DocStatus = 'CO' AND DELETING) THEN
+ RAISE_APPLICATION_ERROR(-20501, 'Document processed/posted');
+ END IF;
IF (v_ReqStatus = 'P') THEN
RAISE_APPLICATION_ERROR(-20526, 'It is not possible to modify planned
requisition lines');
------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a
Billion" shares his insights and actions to help propel your
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
