Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012091Openbravo ERP07. Sales managementpublic2010-01-29 18:082010-03-10 18:29
Reportermaite 
Assigned Toharikrishnan 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP11 
Target VersionFixed in Version2.50MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012091: Is not possible to modify the price of a sales order line if it has been delivered
DescriptionYou 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 Reproduce1. 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0012187 closed sivaraman Is not possible to modify the price of a sales order line if it has been delivered 
causes defect 0031115 closed dmiguelez Ordered Quantity can be modified in delivered but not invoiced sales order line if the price is also changed 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-29 18:08maiteNew Issue
2010-01-29 18:08maiteAssigned To => rafaroda
2010-01-29 18:09maiteNote Added: 0023871
2010-02-08 11:48harikrishnanAssigned Torafaroda => harikrishnan
2010-02-09 12:06rafarodaPrioritynormal => high
2010-02-09 12:06rafarodaStatusnew => scheduled
2010-02-09 12:06rafarodafix_in_branch => pi
2010-02-09 13:25hgbotCheckin
2010-02-09 13:25hgbotNote Added: 0024061
2010-02-09 13:25hgbotStatusscheduled => resolved
2010-02-09 13:25hgbotResolutionopen => fixed
2010-02-09 13:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cf51a7043a888d5b08331f3ce8a155e3236e8048 [^]
2010-02-09 13:25harikrishnanNote Added: 0024062
2010-02-12 12:11arunkumarNote Added: 0024200
2010-02-12 12:11arunkumarStatusresolved => closed
2010-02-12 12:11arunkumarFixed in Version => 2.50MP12
2010-02-13 00:00anonymoussf_bug_id0 =>
2010-02-15 17:37hudsonbotCheckin
2010-02-15 17:37hudsonbotNote Added: 0024311
2010-03-10 18:29anonymoussf_bug_id => 2967999
2015-10-08 18:48ngarciaRelationship addedcauses 0031115

Notes
(0023871)
maite   
2010-01-29 18:09   
sla date= 04/03/2010
(0024061)
hgbot   
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   
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   
2010-02-12 12:11   
Tested & Working fine.
(0024311)
hudsonbot   
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 [^]