Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017242Openbravo ERP07. Sales managementpublic2011-05-18 13:492011-05-26 07:45
Reportermirurita 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target Version3.0RC7Fixed in Version3.0RC7 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017242: Not possible to update the Invoice Terms in a processed Order
DescriptionWhen modifying the Invoice Terms field in a processed Order you get an error:
ERROR: Document processed/posted
it should be possible to update this field.

The update statement is wrong:
update C_Order set Updated='2011-05-18 13:44:36.807000 +02:00:00', InvoiceRule='O', TotalLines='12.730000000000000426325641456060111522674560546875', GrandTotal='13.2400000000000002131628207280300557613372802734375' where C_Order_ID='FF8080813002016201300209454B0029'

because it's trying to update more fields and the trigger is preventing these fields to be updated.




Caused by: java.sql.BatchUpdateException: Batch entry 0 update C_Order set Updated='2011-05-18 13:44:36.807000 +02:00:00', InvoiceRule='O', TotalLines='12.730000000000000426325641456060111522674560546875', GrandTotal='13.2400000000000002131628207280300557613372802734375' where C_Order_ID='FF8080813002016201300209454B0029' was aborted. Call getNextException to see the cause.
    at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
    ... 42 more
4418361 [TP-Processor7] INFO org.openbravo.erpCommon.utility.ErrorTextParserPOSTGRE - did not find constraint name for error message: ERROR: Document processed/posted
Steps To Reproduce1) Go to Sales Order
2) Create a new Sales Order an complete
3) Try to modify the Invoice Terms and click on save button
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng InvoiceTerms_SalesOrder.png (75,010) 2011-05-18 13:49
https://issues.openbravo.com/file_download.php?file_id=4044&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-05-18 13:49miruritaNew Issue
2011-05-18 13:49miruritaAssigned To => adrianromero
2011-05-18 13:49miruritaFile Added: InvoiceTerms_SalesOrder.png
2011-05-18 13:49miruritaModules => Core
2011-05-18 13:49miruritaOBNetwork customer => No
2011-05-18 13:51psarobePriorityurgent => immediate
2011-05-18 13:51psarobeStatusnew => scheduled
2011-05-18 14:04psarobeAssigned Toadrianromero => alostale
2011-05-18 18:30iperdomoAssigned Toalostale => iperdomo
2011-05-19 09:10iperdomoAssigned Toiperdomo => alostale
2011-05-19 09:49hgbotCheckin
2011-05-19 09:49hgbotNote Added: 0037191
2011-05-19 09:49hgbotStatusscheduled => resolved
2011-05-19 09:49hgbotResolutionopen => fixed
2011-05-19 09:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/316dfc2e8c16847a438ceed41a5dfe1eb4bf381a [^]
2011-05-19 10:40psarobeNote Added: 0037196
2011-05-19 10:40psarobeStatusresolved => closed
2011-05-19 10:40psarobeFixed in Version => 3.0RC7
2011-05-26 07:45hudsonbotCheckin
2011-05-26 07:45hudsonbotNote Added: 0037500

Notes
(0037191)
hgbot   
2011-05-19 09:49   
Repository: erp/devel/pi
Changeset: 316dfc2e8c16847a438ceed41a5dfe1eb4bf381a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu May 19 09:49:04 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/316dfc2e8c16847a438ceed41a5dfe1eb4bf381a [^]

fixed bug 17242: Not possible to update the Invoice Terms in a processed Order

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewFormComponent.java
---
(0037196)
psarobe   
2011-05-19 10:40   
works fine
(0037500)
hudsonbot   
2011-05-26 07:45   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/728387046be6 [^]

Maturity status: Test