Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011933Openbravo ERP04. Warehouse managementpublic2010-01-11 18:472010-04-09 07:28
Reporternetworkb 
Assigned Toadrianromero 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP11 
Target Version2.40MP16Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011933: It is not possible to delete a Header in Goods Movements
DescriptionIt 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 ReproduceGo to Warehouse Management > Transactions > Goods Movement.
Create a new record.
Try to delete it.
Proposed SolutionModify 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
Additional Information
TagsNo tags attached.
Relationships
related to defect 00126932.50MP17 closed adrianromero Review on delete triggers 
blocks defect 00102122.50MP5 closed balamurugan It is not possible to delete a Header in Goods Movements 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-11 18:47rafarodaNew Issue
2010-01-11 18:47rafarodaAssigned To => rafaroda
2010-01-11 18:47rafarodaOBNetwork customer => Yes
2010-01-11 18:47rafarodaIssue generated from0010212
2010-01-11 18:47rafarodaRelationship addedblocks 0010212
2010-01-11 18:48rafarodaReporterrafaroda => networkb
2010-01-11 18:48rafarodaPriorityhigh => immediate
2010-01-11 18:48rafarodafix_in_branch => 2.40
2010-01-12 09:13networkbversion => 2.40MP11
2010-01-12 10:42rafarodaPriorityimmediate => high
2010-01-12 10:42rafarodaStatusnew => scheduled
2010-01-13 12:38rafarodaStatusscheduled => resolved
2010-01-13 12:38rafarodaFixed in SCM revision => bbb
2010-01-13 12:38rafarodaResolutionopen => fixed
2010-01-13 12:39rafarodaNote Added: 0023384
2010-01-13 12:39rafarodaStatusresolved => new
2010-01-13 12:39rafarodaFixed in SCM revisionbbb =>
2010-01-13 12:39rafarodaStatusnew => scheduled
2010-01-13 12:39rafarodafix_in_branch2.40 => pi
2010-01-13 12:39rafarodafix_in_branchpi => 2.40
2010-01-25 10:13rafarodaResolutionfixed => open
2010-01-25 10:13rafarodaTarget Version => 2.40MP16
2010-02-11 11:07rafarodaAssigned Torafaroda => adrianromero
2010-03-16 09:26networkbNote Added: 0025524
2010-03-16 09:38networkbNote Deleted: 0025524
2010-03-17 12:55adrianromeroRelationship addedrelated to 0012693
2010-03-17 12:58rafarodaIssue Monitored: rafaroda
2010-03-19 06:07hgbotCheckin
2010-03-19 06:07hgbotNote Added: 0025615
2010-03-19 06:07hgbotStatusscheduled => resolved
2010-03-19 06:07hgbotResolutionopen => fixed
2010-03-19 06:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/1736b5f3d6480a85dc06e30243e8ff31677a1a6c [^]
2010-03-19 06:10sivaramanNote Added: 0025616
2010-04-09 07:28arunkumarNote Added: 0026013
2010-04-09 07:28arunkumarStatusresolved => closed

Notes
(0023384)
rafaroda   
2010-01-13 12:39   
Re-opened
(0025615)
hgbot   
2010-03-19 06:07   
Repository: erp/stable/2.40
Changeset: 1736b5f3d6480a85dc06e30243e8ff31677a1a6c
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo>
Date: Fri Mar 19 10:44:13 2010 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/1736b5f3d6480a85dc06e30243e8ff31677a1a6c [^]

Fixes issue 11933: It is not possible to delete a Header in Goods Movements

---
M src-db/database/model/triggers/M_MOVEMENT_TRG.xml
---
(0025616)
sivaraman   
2010-03-19 06:10   
Steps to test:

1. Log on to Openbravo
2. Change role to Openbravo Admin
3. Go to Warehouse Management > Transactions > Goods Movement
4. Create new record & Save it
5. Delete the same
(0026013)
arunkumar   
2010-04-09 07:28   
Tested & working fine