Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0017242 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | always | 2011-05-18 13:49 | 2011-05-26 07:45 | |||
| Reporter | mirurita | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0RC7 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 316dfc2e8c16 | ||||
| Projection | none | ETA | none | Target Version | 3.0RC7 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | pi | 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 | 0017242: Not possible to update the Invoice Terms in a processed Order | |||||||
| Description | When 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 Reproduce | 1) Go to Sales Order 2) Create a new Sales Order an complete 3) Try to modify the Invoice Terms and click on save button | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  InvoiceTerms_SalesOrder.png [^] (75,010 bytes) 2011-05-18 13:49
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0037191) hgbot (developer) 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 (viewer) 2011-05-19 10:40 |
works fine |
|
(0037500) hudsonbot (viewer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-05-18 13:49 | mirurita | New Issue | |
| 2011-05-18 13:49 | mirurita | Assigned To | => adrianromero |
| 2011-05-18 13:49 | mirurita | File Added: InvoiceTerms_SalesOrder.png | |
| 2011-05-18 13:49 | mirurita | Modules | => Core |
| 2011-05-18 13:49 | mirurita | OBNetwork customer | => No |
| 2011-05-18 13:51 | psarobe | Priority | urgent => immediate |
| 2011-05-18 13:51 | psarobe | Status | new => scheduled |
| 2011-05-18 14:04 | psarobe | Assigned To | adrianromero => alostale |
| 2011-05-18 18:30 | iperdomo | Assigned To | alostale => iperdomo |
| 2011-05-19 09:10 | iperdomo | Assigned To | iperdomo => alostale |
| 2011-05-19 09:49 | hgbot | Checkin | |
| 2011-05-19 09:49 | hgbot | Note Added: 0037191 | |
| 2011-05-19 09:49 | hgbot | Status | scheduled => resolved |
| 2011-05-19 09:49 | hgbot | Resolution | open => fixed |
| 2011-05-19 09:49 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/316dfc2e8c16847a438ceed41a5dfe1eb4bf381a [^] |
| 2011-05-19 10:40 | psarobe | Note Added: 0037196 | |
| 2011-05-19 10:40 | psarobe | Status | resolved => closed |
| 2011-05-19 10:40 | psarobe | Fixed in Version | => 3.0RC7 |
| 2011-05-26 07:45 | hudsonbot | Checkin | |
| 2011-05-26 07:45 | hudsonbot | Note Added: 0037500 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |