Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012091 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | always | 2010-01-29 18:08 | 2010-03-10 18:29 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | harikrishnan | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50MP12 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | cf51a7043a88 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP11 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0012091: Is not possible to modify the price of a sales order line if it has been delivered | |||||||
| Description | You have a sales order and its goods shipment. Then you realize that price of one of the lines is incorrect and you reactivate the order to modify it (as it has not been invoiced yet). When you try to save the line you get the following error: Cannot modify an order line that has deliveries or invoices ORA-06512: at "TAD_240_FULL.C_ORDLINE_CHK_RESTRICTIONS_TRG", line 62 ORA-04088: error during execution of trigger 'TAD_240_FULL.C_ORDLINE_CHK_RESTRICTIONS_TRG' | |||||||
| Steps To Reproduce | 1. Sales Management || Transactions || Sales Order: create standard order for any business partner 2. Sales Management || Transactions || Sales Order || Header >> Lines :add one line for any product and complete the order. 3. Generate its goods shipment 4. Come back to the order and reactivate it 5. Go to the line and modify its unit price 6. Try to save the line and you will get the error. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0023871) maite (viewer) 2010-01-29 18:09 |
sla date= 04/03/2010 |
|
(0024061) hgbot (developer) 2010-02-09 13:25 |
Repository: erp/devel/pi Changeset: cf51a7043a888d5b08331f3ce8a155e3236e8048 Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com> Date: Tue Feb 09 17:55:30 2010 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/cf51a7043a888d5b08331f3ce8a155e3236e8048 [^] Fixes issue 12091: Is not possible to modify the price of a sales order line if it has been delivered. --- M src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml --- |
|
(0024062) harikrishnan (viewer) 2010-02-09 13:25 |
Steps To test: *Create a sales order (Sales Management || Transactions || Sales Order || Header ) with any value in Business Partner field. *Select a product inside the line and complete the sales order. *Go to Goods Shipment (Sales Management || Transactions || Goods Shipment || Header ) and create the shipment for the above sales order using the button "Create Lines From".Complete the Goods Shipment. *Reactivate the above created sales order.And try to change the Net Unit Price of the Product and save it.Now the price can be changed.Again complete the sales order. *Create a new sales invoice for the above created sales order.And complete the sales invoice. *Again reactivate the above sales order,now the price can't be changed. |
|
(0024200) arunkumar (viewer) 2010-02-12 12:11 |
Tested & Working fine. |
|
(0024311) hudsonbot (viewer) 2010-02-15 17:37 |
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/cf51a7043a88 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2596487a564c [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16391.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-01-29 18:08 | maite | New Issue | |
| 2010-01-29 18:08 | maite | Assigned To | => rafaroda |
| 2010-01-29 18:09 | maite | Note Added: 0023871 | |
| 2010-02-08 11:48 | harikrishnan | Assigned To | rafaroda => harikrishnan |
| 2010-02-09 12:06 | rafaroda | OBNetwork customer | => No |
| 2010-02-09 12:06 | rafaroda | Priority | normal => high |
| 2010-02-09 12:06 | rafaroda | Status | new => scheduled |
| 2010-02-09 12:06 | rafaroda | fix_in_branch | => pi |
| 2010-02-09 13:25 | hgbot | Checkin | |
| 2010-02-09 13:25 | hgbot | Note Added: 0024061 | |
| 2010-02-09 13:25 | hgbot | Status | scheduled => resolved |
| 2010-02-09 13:25 | hgbot | Resolution | open => fixed |
| 2010-02-09 13:25 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/cf51a7043a888d5b08331f3ce8a155e3236e8048 [^] |
| 2010-02-09 13:25 | harikrishnan | Note Added: 0024062 | |
| 2010-02-12 12:11 | arunkumar | Note Added: 0024200 | |
| 2010-02-12 12:11 | arunkumar | Status | resolved => closed |
| 2010-02-12 12:11 | arunkumar | Fixed in Version | => 2.50MP12 |
| 2010-02-13 00:00 | anonymous | sf_bug_id | 0 => |
| 2010-02-15 17:37 | hudsonbot | Checkin | |
| 2010-02-15 17:37 | hudsonbot | Note Added: 0024311 | |
| 2010-03-10 18:29 | anonymous | sf_bug_id | => 2967999 |
| 2015-10-08 18:48 | ngarcia | Relationship added | causes 0031115 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |