Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0014070 | Openbravo ERP | 07. Sales management | public | 2010-07-27 17:26 | 2010-08-07 00:00 |
|
| Reporter | networkb | |
| Assigned To | sivaraman | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 2.50MP20 | |
| Target Version | 2.50MP21 | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| 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 |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| 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-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 |
|
Notes |
|
|
(0029814)
|
|
hgbot
|
|
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
---
|
|
|
|
|
Steps to test:
Kindly follow the steps as given in the Steps To Reproduce section. |
|
|
|
|
|
|
|
|
|