Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0014070 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | always | 2010-07-27 17:26 | 2010-08-07 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | sivaraman | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 719c3bbbf9f5 | ||||
| Projection | none | ETA | none | Target Version | 2.50MP21 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP20 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0014070: You can not reactivate a sales order if it has a discount | |||||||
| Description | You can not reactivate a sales order if it has a discount and if it has a good shipment (Void) related. You can reactivate the order if it has no a discount | |||||||
| Steps To Reproduce | - As Openbravo Admin go to Sales Management || Transactions || Sales Order - Create a new record (Transaction document: standard order)and go to Discounts. - Create a new record (discount 03%) - Complete the order. - Go to Sales Management || Transactions || Create Shipments from Orders - Go to the good shipment created, void it. - Go back to the order - Realize that you can not reactivate it | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0029814) hgbot (developer) 2010-08-05 10:14 |
Repository: erp/devel/pi Changeset: 719c3bbbf9f5441cde8339a02086327897e49758 Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com> Date: Thu Aug 05 13:44:10 2010 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/719c3bbbf9f5441cde8339a02086327897e49758 [^] Fixes issue 14070: You can not reactivate a sales order if it has a discount Root cause: In C_ORDER_POST1, we delete C_ORDERLINE but there is a foreign key constrain in M_INOUTLINE.C_ORDERLINE_ID. Thus, it throws exception in order to prevent C_ORDERLINE. Fix: When a sales order with discount is reactivated, null value is updated to it's corresponding m_inoutline.c_orderline_id field before deleting C_ORDERLINE. Thus, foreign key violation is avoided. Also m_inoutline trigger is changed in order to allow to modify c_orderline_id column for voided documents even after processed. Impacts: It has been verified that there is no impacts except resolving the issue --- M src-db/database/model/functions/C_ORDER_POST1.xml M src-db/database/model/triggers/M_IOLINE_CHK_RESTRICTIONS_TRG.xml --- |
|
(0029815) sivaraman (viewer) 2010-08-05 10:18 |
Steps to test: Kindly follow the steps as given in the Steps To Reproduce section. |
|
(0029831) hudsonbot (viewer) 2010-08-05 15:05 |
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/719c3bbbf9f5 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7afc506f5f93 [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18021.obx [^] |
|
(0029843) sureshbabu (viewer) 2010-08-06 19:38 |
verified |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-07-27 17:26 | networkb | New Issue | |
| 2010-07-27 17:26 | networkb | Assigned To | => adrianromero |
| 2010-07-27 17:26 | networkb | OBNetwork customer | => Yes |
| 2010-08-03 11:26 | sivaraman | Assigned To | adrianromero => sivaraman |
| 2010-08-05 10:14 | hgbot | Checkin | |
| 2010-08-05 10:14 | hgbot | Note Added: 0029814 | |
| 2010-08-05 10:14 | hgbot | Status | new => resolved |
| 2010-08-05 10:14 | hgbot | Resolution | open => fixed |
| 2010-08-05 10:14 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/719c3bbbf9f5441cde8339a02086327897e49758 [^] |
| 2010-08-05 10:18 | sivaraman | Note Added: 0029815 | |
| 2010-08-05 15:05 | hudsonbot | Checkin | |
| 2010-08-05 15:05 | hudsonbot | Note Added: 0029831 | |
| 2010-08-06 19:38 | sureshbabu | Note Added: 0029843 | |
| 2010-08-06 19:38 | sureshbabu | Status | resolved => closed |
| 2010-08-07 00:00 | anonymous | sf_bug_id | 0 => 3040896 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |