Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016057Openbravo ERP03. Procurement managementpublic2011-02-25 12:302017-05-29 13:45
Reporteradrianromero 
Assigned ToTriage Omni OMS 
PriorityurgentSeveritytrivialReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016057: Is it possible able to add a discount in an order completed
DescriptionA new discount can be added in an order completed, but are not able to delete it.
Steps To Reproduce-As Openbravo Admin go to Procurement Management || Transactions || Purchase Order
-Create a new order and complete it
-go to Header >> Discounts
- Create a new record and save
- realize that it is possible to save it
- Try to delete it
- realize that it is not possible to delete it
Proposed SolutionThe problem is that there is a dead lock between the triggers in the C_ORDER table and C_ORDER_DISCOUNTS table because the C_ORDER trigger in some situations creates new records in the C_ORDER_DISCOUNTS table and the C_ORDERS_DISCOUNTS TRIGGERS reads the C_ORDER table.

One possible solution is to add a new especial field in the C_ORDER_DISCOUNTS table in order to be able to detect in the C_ORDER_DISCOUNTS trigger who is trying to insert values and do not perform the usual verifications if it is the C_ORDER trigger who is trying to add new records.
Additional Information
TagsVMA-Reviewed
Relationships
related to backport 00156402.50MP27 closed adrianromero you are able to add a discount in an order completed 
depends on feature request 0020475 new Triage Platform Base Implement onInsert, onUpdate, onDelete logic for a tab/table 
Not all the children of this issue are yet resolved or closed.
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-02-25 12:30adrianromeroNew Issue
2011-02-25 12:30adrianromeroAssigned To => adrianromero
2011-02-25 12:30adrianromeroModules => Core
2011-02-25 12:30adrianromeroOBNetwork customer => No
2011-02-25 12:30adrianromeroIssue generated from0015640
2011-02-25 12:30adrianromeroRelationship addedrelated to 0015640
2011-06-03 10:58dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:16dalsasuaAssigned Todalsasua => jonalegriaesarte
2012-02-15 19:05iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-16 15:52vmromanosTag Attached: VMA-Reviewed
2012-05-10 12:13gorka_gilAssigned Tovmromanos => mirurita
2012-05-11 10:20SandrahuguetAssigned Tomirurita => Sandrahuguet
2012-05-11 10:20SandrahuguetStatusnew => scheduled
2012-05-11 10:20Sandrahuguetfix_in_branch => pi
2012-05-11 12:59SandrahuguetRelationship addeddepends on 0020475
2012-05-11 12:59SandrahuguetTypedefect => design defect
2012-05-11 12:59Sandrahuguetfix_in_branchpi =>
2017-05-29 13:45SandrahuguetAssigned ToSandrahuguet => Triage Finance

There are no notes attached to this issue.