0010212: It is not possible to delete a Header in Goods Movements

Description

It is not possible to delete a Header in Goods Movements (without lines).
Trying to delete the application shows:

ERROR: record "new" is not assigned yet Detail: The tuple structure of a not-yet-assigned record is indeterminate.

Steps To Reproduce

Go to Warehouse Management > Transactions > Goods Movement.
Create a new record.
Try to delete it.

Proposed Solution

Modify m_movement_trg:

DECLARE

/*************************************************************************
* The contents of this file are subject to the Openbravo Public License
* Version 1.0 (the "License"), being the Mozilla Public License
* Version 1.1 with a permitted attribution clause; you may not use this
* file except in compliance with the License. You may obtain a copy of
* the License at http://www.openbravo.com/legal/license.html [^]
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SL
* All portions are Copyright (C) 2007 Openbravo SL
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
v_DateNull TIMESTAMP := TO_DATE('01-01-1900', 'DD-MM-YYYY');

BEGIN

IF AD_isTriggerEnabled()='N' THEN IF TG_OP = 'DELETE' THEN RETURN OLD; ELSE RETURN NEW; END IF;
END IF;

IF TG_OP = 'DELETE' THEN
IF (old.PROCESSED = 'Y') THEN
RAISE EXCEPTION '%', 'Document processed/posted' ; --OBTG:-20501--
END IF;
END IF;

IF TG_OP = 'UPDATE' THEN
IF (old.PROCESSED = 'Y' AND(
(COALESCE(old.MOVEMENTDATE, v_DateNull) <> COALESCE(new.MOVEMENTDATE, v_DateNull))
OR (COALESCE(old.AD_ORGTRX_ID, '0') <> COALESCE(new.AD_ORGTRX_ID, '0'))
OR (COALESCE(old.DOCUMENTNO, '.') <> COALESCE(new.DOCUMENTNO, '.'))
OR(COALESCE(old.AD_ORG_ID, '0') <> COALESCE(new.AD_ORG_ID, '0'))
OR(COALESCE(old.AD_CLIENT_ID, '0') <> COALESCE(new.AD_CLIENT_ID, '0')))) THEN
RAISE EXCEPTION '%', 'Document processed/posted' ; --OBTG:-20501--
END IF;
END IF;
IF TG_OP = 'DELETE' THEN RETURN OLD; ELSE RETURN NEW; END IF;

END

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

backport

0011933

2.40MP16

closed

adrianromero

It is not possible to delete a Header in Goods Movements

Notes
(0019064) hgbot (developer) 2009-08-19 15:49	Repository: erp/devel/pi Changeset: 24379ebdd2262f25dbb7fece2a3eac82d0d6b596 Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com> Date: Wed Aug 19 19:17:01 2009 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/24379ebdd2262f25dbb7fece2a3eac82d0d6b596 [^] Fixed Issue 0010212: It is not possible to delete a Header in Goods Movements. --- M src-db/database/model/triggers/M_MOVEMENT_TRG.xml ---

(0019099) sureshbabu (reporter) 2009-08-20 13:30	Tested, able to delete the Goods movement record

Issue History
Date Modified	Username	Field	Change
2009-08-07 10:59	networkb	New Issue
2009-08-07 10:59	networkb	Assigned To	=> rafaroda
2009-08-12 10:19	networkb	Target Version	=> 2.50MP5
2009-08-13 17:37	psarobe	Priority	immediate => high
2009-08-13 17:37	psarobe	Status	new => scheduled
2009-08-19 15:00	rafaroda	Assigned To	rafaroda => balamurugan
2009-08-19 15:49	hgbot	Checkin
2009-08-19 15:49	hgbot	Note Added: 0019064
2009-08-19 15:49	hgbot	Status	scheduled => resolved
2009-08-19 15:49	hgbot	Resolution	open => fixed
2009-08-19 15:49	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/24379ebdd2262f25dbb7fece2a3eac82d0d6b596 [^]
2009-08-20 13:30	sureshbabu	Status	resolved => closed
2009-08-20 13:30	sureshbabu	Note Added: 0019099
2009-08-20 13:30	sureshbabu	Fixed in Version	=> pi
2009-08-21 00:00	anonymous	sf_bug_id	0 => 2841461
2010-01-11 18:47	rafaroda	Issue cloned	0011933
2010-01-11 18:47	rafaroda	Relationship added	depends on 0011933