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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0024125
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementminoralways2013-06-18 17:192013-06-28 22:51
ReporterlioscView Statuspublic 
Assigned Topramakrishnan 
PrioritylowResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision6cc6f26c36d6
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava versionJava 6 openjdk amd64
OS VersionUbuntu 12.04Database version9.1Ant version1.8.2
Product Version3.0MP23SCM revision 
Review Assigned ToSandrahuguet
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0024125: Bad error message trying to delete a complete purchase order line

DescriptionWhen you try to delete a complete purchase order line, in addition to the right error message a SQL code istruction appears.
"Documento postato/processato. Where: SQL statement "UPDATE C_ORDERTAX SET TAXAMT = (CASE WHEN v_DocTaxAmount='D' THEN ROUND((TAXBASEAMT - OLD.TAXBASEAMT) * v_Rate/100, v_Prec) ELSE (TAXAMT - OLD.TAXAMT) END), TAXBASEAMT=TAXBASEAMT - OLD.TAXBASEAMT WHERE C_ORDER_ID = OLD.C_Order_ID AND C_TAX_ID = OLD.C_TAX_ID" PL/pgSQL function "c_orderlinetax_trg" line 97 at SQL statement"
Steps To ReproduceCreate a purchase order with at least one row. Complete it. Try to delete a row
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0024243 closedpramakrishnan You cannot close a completed order. 

-  Notes
(0059770)
hgbot (developer)
2013-06-28 11:39

Repository: erp/devel/pi
Changeset: 6cc6f26c36d65beb7988be48624b426b0956f925
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Mon Jun 24 11:29:17 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/6cc6f26c36d65beb7988be48624b426b0956f925 [^]

Fixes Issue 24125: Bad error message trying to delete a complete purchase order line

---
M src-db/database/model/triggers/C_ORDERLINETAX_TRG.xml
---
(0059771)
Sandrahuguet (developer)
2013-06-28 11:41

Code review + testing OK
(0059788)
hudsonbot (developer)
2013-06-28 22:51

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/afdf98dd7db9 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2013-06-18 17:19 liosc New Issue
2013-06-18 17:19 liosc Assigned To => dmiguelez
2013-06-18 17:19 liosc Web browser => Google Chrome
2013-06-18 17:19 liosc Modules => Core
2013-06-18 17:19 liosc Triggers an Emergency Pack => No
2013-06-20 08:32 pramakrishnan Assigned To dmiguelez => pramakrishnan
2013-06-20 08:33 pramakrishnan Status new => scheduled
2013-06-20 08:33 pramakrishnan fix_in_branch => pi
2013-06-28 11:39 hgbot Checkin
2013-06-28 11:39 hgbot Note Added: 0059770
2013-06-28 11:39 hgbot Status scheduled => resolved
2013-06-28 11:39 hgbot Resolution open => fixed
2013-06-28 11:39 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6cc6f26c36d65beb7988be48624b426b0956f925 [^]
2013-06-28 11:41 Sandrahuguet Review Assigned To => Sandrahuguet
2013-06-28 11:41 Sandrahuguet Note Added: 0059771
2013-06-28 11:41 Sandrahuguet Status resolved => closed
2013-06-28 22:51 hudsonbot Checkin
2013-06-28 22:51 hudsonbot Note Added: 0059788
2013-07-02 10:52 ioritzCia Relationship added related to 0024243


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker