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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0016832
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajoralways2011-04-15 15:142011-05-03 10:48
ReporterjonalegriaesarteView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version2.50MP29
StatusclosedFix in branchpiFixed in SCM revisione6bb116f2a6c
ProjectionnoneETAnoneTarget Version2.50MP29
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP28SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016832: A trigger condition in c_orderline has been added and can cause problems in special conditions

DescriptionThis piece of code has been added to src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml:
IF(UPDATING OR INSERTING) THEN
    IF (:NEW.C_BPARTNER_ID IS NOT NULL AND :NEW.C_BPARTNER_LOCATION_ID IS NULL) THEN
      RAISE_APPLICATION_ERROR(-20000, '@LocationNotNullConstraint@');
    END IF;
END IF;

This piece of code is trying to simulate the old behavior when the line is not a discount. This piece of code is wrong because in some special conditions the user can not insert lines or modify existing lines where this field is null. The original bug is solved without this change in the trigger.

Steps To ReproduceRemove the Business Partner Address field from the purchase order line windows.
Create a purchase order; fill in all the necessary fields.
Create a line for the order; fill in all the necessary fields.
Save the line.
Trigger restriction makes the save to fail.
Proposed SolutionThis piece of code must be deleted.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to backport 00155942.50MP27 closedadrianromero Not possible to modify available fields of Discount line when order is processed 
blocks defect 00168312.50MP29 closeddalsasua A trigger condition in c_orderline has been added and can cause problems in special conditions 

-  Notes
(0035994)
hgbot (developer)
2011-04-15 15:22

Repository: erp/stable/2.50
Changeset: 31fa3266b55b52960f051c727d44708c4a73634a
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Apr 15 15:21:32 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/31fa3266b55b52960f051c727d44708c4a73634a [^]

Fixes 16832: A trigger condition in c_orderline has been added.
The condition in the trigger has been removed

---
M src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml
---
(0036141)
jonalegriaesarte (reporter)
2011-04-27 18:43

Verified
(0036235)
hgbot (developer)
2011-04-29 19:32

Repository: erp/stable/2.50
Changeset: e6bb116f2a6cf983628fcf18d8253fd5a940675a
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Apr 15 15:21:32 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/e6bb116f2a6cf983628fcf18d8253fd5a940675a [^]

Fixes 16832: A trigger condition in c_orderline has been added.
The condition in the trigger has been removed

---
M src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml
---
(0036297)
jonalegriaesarte (reporter)
2011-05-03 10:48

Verified

- Issue History
Date Modified Username Field Change
2011-04-15 15:18 dalsasua Type defect => backport
2011-04-15 15:18 dalsasua fix_in_branch => 2.50
2011-04-15 15:22 hgbot Checkin
2011-04-15 15:22 hgbot Note Added: 0035994
2011-04-15 15:22 hgbot Status scheduled => resolved
2011-04-15 15:22 hgbot Resolution open => fixed
2011-04-15 15:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/31fa3266b55b52960f051c727d44708c4a73634a [^]
2011-04-15 15:41 dalsasua Status resolved => new
2011-04-15 15:41 dalsasua Resolution fixed => open
2011-04-15 15:41 dalsasua Relationship added related to 0015594
2011-04-15 15:41 dalsasua Status new => scheduled
2011-04-15 15:41 dalsasua fix_in_branch 2.50 => pi
2011-04-15 15:41 dalsasua Status scheduled => resolved
2011-04-15 15:41 dalsasua Resolution open => fixed
2011-04-15 16:43 dalsasua Status resolved => new
2011-04-15 16:43 dalsasua Resolution fixed => open
2011-04-15 16:43 dalsasua fix_in_branch pi =>
2011-04-15 16:43 dalsasua Description Updated View Revisions
2011-04-15 16:43 dalsasua Steps to Reproduce Updated View Revisions
2011-04-15 16:43 dalsasua Status new => scheduled
2011-04-15 16:43 dalsasua fix_in_branch => pi
2011-04-15 16:44 dalsasua Status scheduled => resolved
2011-04-15 16:44 dalsasua Resolution open => fixed
2011-04-27 18:43 jonalegriaesarte Note Added: 0036141
2011-04-27 18:43 jonalegriaesarte Status resolved => closed
2011-04-27 18:43 jonalegriaesarte Fixed in Version => 2.50MP29
2011-04-29 19:32 hgbot Checkin
2011-04-29 19:32 hgbot Note Added: 0036235
2011-04-29 19:32 hgbot Status closed => resolved
2011-04-29 19:32 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.50/rev/31fa3266b55b52960f051c727d44708c4a73634a [^] => http://code.openbravo.com/erp/stable/2.50/rev/e6bb116f2a6cf983628fcf18d8253fd5a940675a [^]
2011-05-03 10:48 jonalegriaesarte Note Added: 0036297
2011-05-03 10:48 jonalegriaesarte Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker