Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012091
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2010-01-29 18:082010-03-10 18:29
ReportermaiteView Statuspublic 
Assigned Toharikrishnan 
PriorityhighResolutionfixedFixed in Version2.50MP12
StatusclosedFix in branchpiFixed in SCM revisioncf51a7043a88
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP11SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012091: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0012187 closedsivaraman Is not possible to modify the price of a sales order line if it has been delivered 
causes defect 0031115 closeddmiguelez Ordered Quantity can be modified in delivered but not invoiced sales order line if the price is also changed 

-  Notes
(0023871)
maite (developer)
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 (reporter)
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 (reporter)
2010-02-12 12:11

Tested & Working fine.
(0024311)
hudsonbot (developer)
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 [^]

- 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 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker