Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025420Openbravo ERP03. Procurement managementpublic2014-01-02 11:082014-05-27 11:19
Reporterjonalegriaesarte 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q3Fixed in Version 
Merge Request Status
Review Assigned Torafaroda
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket25612
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025420: Purchase order created from requisition can not be deleted
DescriptionPurchase order created from requisition can not be deleted
Steps To Reproduce- Create requistion with one line
- Create order from requisition
- Reactivate order
- The order can not be deleted
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 00259523.0PR14Q3 closed pramakrishnan Order from requistion can not be deleted 
related to defect 0036600 closed markmm82 Cannot close or void a purchase order related with a requisition 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-01-02 11:08jonalegriaesarteNew Issue
2014-01-02 11:08jonalegriaesarteAssigned To => jonalegriaesarte
2014-01-02 11:08jonalegriaesarteModules => Core
2014-01-02 11:08jonalegriaesarteOBNetwork customer => Yes
2014-01-02 11:08jonalegriaesarteSupport ticket => 25612
2014-01-02 11:08jonalegriaesarteTriggers an Emergency Pack => No
2014-02-19 12:47jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2014-03-11 13:43jonalegriaesarteResolution time => 1395270000
2014-03-11 13:43jonalegriaesarteTarget VersionPR14Q3 => PR14Q2
2014-03-31 16:17jonalegriaesarteTarget VersionPR14Q2 => PR14Q3
2014-03-31 16:41jonalegriaesarteResolution time1395270000 => 1396389600
2014-04-24 18:43gorkaionAssigned Topramakrishnan => gorkaion
2014-05-06 11:17hgbotCheckin
2014-05-06 11:17hgbotNote Added: 0066837
2014-05-06 11:17hgbotStatusnew => resolved
2014-05-06 11:17hgbotResolutionopen => fixed
2014-05-06 11:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cfa8ffeab1ddf945b488f4f65813c29ff678dd83 [^]
2014-05-07 18:12hudsonbotCheckin
2014-05-07 18:12hudsonbotNote Added: 0067001
2014-05-08 11:13jonalegriaesarteRelationship addedhas duplicate 0025952
2014-05-13 10:49jonalegriaesarteNote Added: 0067106
2014-05-13 10:49jonalegriaesarteStatusresolved => new
2014-05-13 10:49jonalegriaesarteResolutionfixed => open
2014-05-13 10:51jonalegriaesarteNote Added: 0067107
2014-05-20 18:27jonalegriaesarteStatusnew => scheduled
2014-05-20 18:27jonalegriaesartefix_in_branch => pi
2014-05-20 18:27jonalegriaesarteNote Added: 0067327
2014-05-20 18:27jonalegriaesarteStatusscheduled => resolved
2014-05-20 18:27jonalegriaesarteFixed in Version => PR14Q3
2014-05-20 18:27jonalegriaesarteResolutionopen => fixed
2014-05-27 11:19rafarodaReview Assigned To => rafaroda
2014-05-27 11:19rafarodaNote Added: 0067462
2014-05-27 11:19rafarodaStatusresolved => closed
2014-05-27 11:19rafarodaFixed in VersionPR14Q3 =>
2017-08-09 09:10aferrazRelationship addedrelated to 0036600

Notes
(0066837)
hgbot   
2014-05-06 11:17   
Repository: erp/devel/pi
Changeset: cfa8ffeab1ddf945b488f4f65813c29ff678dd83
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Tue Apr 29 10:19:32 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cfa8ffeab1ddf945b488f4f65813c29ff678dd83 [^]

Fixed issue 25420.Allow to reactivate a requisition to modify the order.

---
M src-db/database/model/functions/M_REQUISITIONLINE_STATUS.xml
M src-db/database/model/tables/M_REQUISITIONORDER.xml
M src-db/database/model/triggers/C_ORDERLINE2_TRG.xml
M src-db/database/model/triggers/C_ORDERLINE_TRG.xml
M src-db/database/model/triggers/M_REQUISITIONLINE_TRG.xml
M src-db/database/model/triggers/M_REQUISITIONORDER_TRG.xml
M src-db/database/model/triggers/M_REQUISITION_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0067001)
hudsonbot   
2014-05-07 18:12   
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/02ca2648bcdc [^]
Maturity status: Test
(0067106)
jonalegriaesarte   
2014-05-13 10:49   
Due to this fix, the purchase order created from requistion can not be closed. Message when closing the order:

Error:
It is not possible to modify a Requisition that is not Open or Completed.
(0067107)
jonalegriaesarte   
2014-05-13 10:51   
Apart from that, the user can reactivate the order, but once reactivated the order can not be voided. Same message is shown
(0067327)
jonalegriaesarte   
2014-05-20 18:27   
Working fine. The behaviour is correct, because when the process is going to decrese the quantity, it does not make sense to change the quantity in the requisiton.
(0067462)
rafaroda   
2014-05-27 11:19   
Fix tested successfully in Oracle and PostgreSQL http://livebuilds.openbravo.com/ [^]

Steps to test the fix:
* Create and complete a Requisition
* Use Requisition To Order to create a Purchase Order from the Requisition
* Reactivate the Purchase Order
* Try to delete the Purchase Order: correct error message is displayed "It is not possible to modify a Requisition that is not Open or Completed"
* Go to Manage Requisitions window and Change Status of the requisition line to Open
* Go back to the Purchase Order and try to delete it: you can now successfully delete the Purchase Order