Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020638Openbravo ERP03. Procurement managementpublic2012-05-30 12:412012-05-31 21:38
Reporterjecharri 
Assigned ToioritzCia 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP12Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression levelCode review
Regression date2012-05-30
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/d68ebd3dd2fd926f2bad25327ae96ea6c3031ef0 [^]
Triggers an Emergency PackNo
Summary0020638: Is imposible to delete lines in Good Receipts
DescriptionIs imposible to delete lines in Goods Receipts without any order line related.

Steps To ReproduceAs "Group Admin" go to window "Goods Receipts"
-Create a header and go to tab lines.
-Create a line and save it.
-Try to delete the line

You will get next error:
ERROR: el registro «new» no ha sido asignado aún Detail: La estructura de fila de un registro aún no asignado no está determinado. Where: función PL/pgSQL «m_inoutline_trg» en la línea 170 en sentencia SQL
Proposed SolutionThe problem is in trigger m_inoutline_trg line 168.

The SQL sentence try to catch the value from new.C_OrderLine_ID and this fails when line has not got an order line related.
Additional Information
TagsRegression QA
Relationships
related to defect 00203333.0MP12 closed ioritzCia Possible mismatch between the product at Goods Shipment Line and Sales Order Line 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-30 12:41jecharriNew Issue
2012-05-30 12:41jecharriAssigned To => ioritzCia
2012-05-30 12:41jecharriWeb browser => Google Chrome
2012-05-30 12:41jecharriModules => Core
2012-05-30 12:41jecharriTag Attached: Regression QA
2012-05-30 12:42jecharriRelationship addedrelated to 0020333
2012-05-30 13:00jecharriWeb browserGoogle Chrome => Google Chrome
2012-05-30 13:00jecharriRegression level => Code review
2012-05-30 13:00jecharriRegression date => 2012-05-30
2012-05-30 13:00jecharriRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/d68ebd3dd2fd926f2bad25327ae96ea6c3031ef0 [^]
2012-05-30 16:27hgbotCheckin
2012-05-30 16:27hgbotNote Added: 0049491
2012-05-30 16:27hgbotStatusnew => resolved
2012-05-30 16:27hgbotResolutionopen => fixed
2012-05-30 16:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e99deb6bf819899938837c435a1939885f9ceb03 [^]
2012-05-30 16:33ioritzCiaNote Added: 0049492
2012-05-30 18:19jecharriNote Added: 0049514
2012-05-30 18:19jecharriStatusresolved => closed
2012-05-31 21:38hudsonbotCheckin
2012-05-31 21:38hudsonbotNote Added: 0049568

Notes
(0049491)
hgbot   
2012-05-30 16:27   
Repository: erp/devel/pi
Changeset: e99deb6bf819899938837c435a1939885f9ceb03
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Wed May 30 13:29:23 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e99deb6bf819899938837c435a1939885f9ceb03 [^]

Fixes issue 20638: Is imposible to delete lines in Good Receipts.

---
M src-db/database/model/triggers/M_INOUTLINE_TRG.xml
---
(0049492)
ioritzCia   
2012-05-30 16:33   
Testing plan:

- Create an order either sales or purchase.
- Create a shipment either sales or purchase creating lines from previous order.
- Try to insert, update and delete lines from the lines of the shipment.
(0049514)
jecharri   
2012-05-30 18:19   
Verified code and functionality
(0049568)
hudsonbot   
2012-05-31 21:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/3ac036c08ee6 [^]

Maturity status: Test