Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024125Openbravo ERP03. Procurement managementpublic2013-06-18 17:192013-06-28 22:51
Reporterliosc 
Assigned Topramakrishnan 
PrioritylowSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionUbuntu 12.04
Product Version3.0MP23 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024125: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0024243 closed pramakrishnan You cannot close a completed order. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-06-18 17:19lioscNew Issue
2013-06-18 17:19lioscAssigned To => dmiguelez
2013-06-18 17:19lioscWeb browser => Google Chrome
2013-06-18 17:19lioscModules => Core
2013-06-18 17:19lioscTriggers an Emergency Pack => No
2013-06-20 08:32pramakrishnanAssigned Todmiguelez => pramakrishnan
2013-06-20 08:33pramakrishnanStatusnew => scheduled
2013-06-20 08:33pramakrishnanfix_in_branch => pi
2013-06-28 11:39hgbotCheckin
2013-06-28 11:39hgbotNote Added: 0059770
2013-06-28 11:39hgbotStatusscheduled => resolved
2013-06-28 11:39hgbotResolutionopen => fixed
2013-06-28 11:39hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6cc6f26c36d65beb7988be48624b426b0956f925 [^]
2013-06-28 11:41SandrahuguetReview Assigned To => Sandrahuguet
2013-06-28 11:41SandrahuguetNote Added: 0059771
2013-06-28 11:41SandrahuguetStatusresolved => closed
2013-06-28 22:51hudsonbotCheckin
2013-06-28 22:51hudsonbotNote Added: 0059788
2013-07-02 10:52ioritzCiaRelationship addedrelated to 0024243

Notes
(0059770)
hgbot   
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   
2013-06-28 11:41   
Code review + testing OK
(0059788)
hudsonbot   
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