Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012650
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajorhave not tried2010-03-11 12:492010-03-17 15:40
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisioncdc783c1056a
ProjectionnoneETAnoneTarget Version2.50MP14
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP13SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012650: You can not delete a good shipment line so you can not delete the good shipment

DescriptionYou can not delete a good shipment line so you can not delete the good shipment.
When trying to delete the line you get the following error:

      
ERROR: record "new" is not assigned yet Detail: The tuple structure of a not-yet-assigned record is indeterminate.
Steps To Reproduce-Go to good shipment window
-Create a shipment
-Create a line and save it
-Try to delete the line.
Proposed SolutionThis bloque of code of the m_inoutline_trg is always executed:

 IF (:NEW.C_ORDERLINE_ID IS NOT NULL) THEN
    SELECT COUNT(*) INTO V_COUNT FROM C_ORDERLINE ol
    WHERE ol.C_ORDERLINE_ID = :NEW.C_ORDERLINE_ID
    AND :NEW.MOVEMENTQTY > ol.QTYORDERED;
          IF(V_COUNT <> 0) THEN
            RAISE_APPLICATION_ERROR(-20000, '@MovementQtyCheck@');
          END IF;
  END IF;
 IF (UPDATING) THEN

When deleting is not possible to use the new.

This should be done when inserting or updating only.
TagsRegression
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00119772.50MP12 closedrafaroda It is possible to create a Good Shipment with more quantity thant Sales Order 
has duplicate defect 0012769 closedadrianromero Cannot delete goods shipment lines - error message for non-humans is presented 

-  Notes
(0025241)
hgbot (developer)
2010-03-11 16:43

 Repository: erp/devel/pi
Changeset: 90e5934baefaa2aef4dc120934786aa48a1a8cd7
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Mar 11 16:48:41 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/90e5934baefaa2aef4dc120934786aa48a1a8cd7 [^]

Fixes issue 0012650: You can not delete a good shipment line so you can not delete the good shipment

---
M src-db/database/model/triggers/M_INOUTLINE_TRG.xml
M src/org/openbravo/erpCommon/ad_callouts/SL_InOutLine_Product.java
---
(0025242)
hgbot (developer)
2010-03-11 16:49

 Repository: erp/devel/pi
Changeset: cdc783c1056a6c48aea18b1ac000d7e7ea1a581f
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Mar 11 16:55:12 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/cdc783c1056a6c48aea18b1ac000d7e7ea1a581f [^]

Fixes issue 0012650: You can not delete a good shipment line so you can not delete the good shipment
Reverting SL_InOutLine_Product.java that does not belong to this commit

---
M src/org/openbravo/erpCommon/ad_callouts/SL_InOutLine_Product.java
---
(0025243)
adrianromero (manager)
2010-03-11 16:53

 To test this issue just follow the reproduction steps and notice that now it is possible to delete good shipment lines
(0025428)
hudsonbot (developer)
2010-03-12 22:41

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/90e5934baefa [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]
(0025429)
hudsonbot (developer)
2010-03-12 22:41

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/cdc783c1056a [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]
(0025443)
arunkumar (reporter)
2010-03-15 08:14

 Tested & Working fine

- Issue History
Date Modified Username Field Change
2010-03-11 12:49 networkb New Issue
2010-03-11 12:49 networkb Assigned To => adrianromero
2010-03-11 13:09 networkb Severity critical => major
2010-03-11 13:16 networkb Proposed Solution updated
2010-03-11 16:10 rafaroda Issue Monitored: rafaroda
2010-03-11 16:17 rafaroda Relationship added related to 0011977
2010-03-11 16:43 hgbot Checkin
2010-03-11 16:43 hgbot Note Added: 0025241
2010-03-11 16:43 hgbot Status new => resolved
2010-03-11 16:43 hgbot Resolution open => fixed
2010-03-11 16:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/90e5934baefaa2aef4dc120934786aa48a1a8cd7 [^]
2010-03-11 16:49 hgbot Checkin
2010-03-11 16:49 hgbot Note Added: 0025242
2010-03-11 16:49 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/90e5934baefaa2aef4dc120934786aa48a1a8cd7 [^] => http://code.openbravo.com/erp/devel/pi/rev/cdc783c1056a6c48aea18b1ac000d7e7ea1a581f [^]
2010-03-11 16:53 adrianromero Note Added: 0025243
2010-03-12 22:41 hudsonbot Checkin
2010-03-12 22:41 hudsonbot Note Added: 0025428
2010-03-12 22:41 hudsonbot Checkin
2010-03-12 22:41 hudsonbot Note Added: 0025429
2010-03-15 08:14 arunkumar Note Added: 0025443
2010-03-15 08:14 arunkumar Status resolved => closed
2010-03-16 00:00 anonymous sf_bug_id 0 => 2970945
2010-03-17 15:40 psarobe Tag Attached: Regression
2010-03-23 17:47 adrianromero Relationship added has duplicate 0012769

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker