Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019718Openbravo ERP07. Sales managementpublic2012-02-10 04:332012-09-26 17:19
Reporterboris 
Assigned ToSandrahuguet 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version3.0MP7.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tonaiaramartinez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019718: Uncatched exception when changing 'Complete' sales invoice
DescriptionDeleting a order line from a sales invoice that has been set to complete will produce this error:

Error
ERROR: Document processed/posted - 100000.00 - 0.00 - 0.00 - 0.00 - 8CD6182E151346B1AF4D3056DB2E4188 - 8CD6182E151346B1AF4D3056DB2E4188 Where: SQL statement "UPDATE C_INVOICETAX SET TAXAMT = (CASE WHEN $1 ='D' THEN ROUND((TAXBASEAMT - $2 ) * $3 /100, $4 ) ELSE (TAXAMT - $5 ) END), TAXBASEAMT=TAXBASEAMT - $6 WHERE C_INVOICE_ID = $7 AND C_TAX_ID = $8 AND Recalculate = 'Y'" PL/pgSQL function "c_invoicelinetax_trg" line 84 at SQL statement
Steps To ReproduceCreate sales invoice. Set to Complete. Delete the invoice line.
Proposed SolutionCatch the exception and show the message: This invoice is set to complete and cannot be changed.
Additional Information
TagsVMA-Reviewed
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-02-10 04:33borisNew Issue
2012-02-10 04:33borisAssigned To => jonalegriaesarte
2012-02-10 04:33borisModules => Core
2012-04-03 12:20jonalegriaesarteAssigned Tojonalegriaesarte => vmromanos
2012-04-11 09:41vmromanosTag Attached: VMA-Reviewed
2012-05-10 12:12gorka_gilAssigned Tovmromanos => mirurita
2012-05-17 17:12SandrahuguetAssigned Tomirurita => Sandrahuguet
2012-05-17 17:12SandrahuguetStatusnew => scheduled
2012-05-17 17:12Sandrahuguetfix_in_branch => pi
2012-05-21 09:16SandrahuguetNote Added: 0048792
2012-09-14 10:20hgbotCheckin
2012-09-14 10:20hgbotNote Added: 0052111
2012-09-14 10:20hgbotStatusscheduled => resolved
2012-09-14 10:20hgbotResolutionopen => fixed
2012-09-14 10:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ed8fe55b2a082c7dc2473e4a7691b3bc454e780f [^]
2012-09-14 10:21naiaramartinezClosed by => naiaramartinez
2012-09-14 10:21naiaramartinezNote Added: 0052112
2012-09-14 10:21naiaramartinezStatusresolved => closed
2012-09-26 17:19hudsonbotCheckin
2012-09-26 17:19hudsonbotNote Added: 0052753

Notes
(0048792)
Sandrahuguet   
2012-05-21 09:16   
Test Plan:
-Go to sales invoive, and select a complete sales invoice.
-Select a line, and delete it.
-Notice than now the error message is: Document posted/processed.
(0052111)
hgbot   
2012-09-14 10:20   
Repository: erp/devel/pi
Changeset: ed8fe55b2a082c7dc2473e4a7691b3bc454e780f
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon May 21 10:44:36 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ed8fe55b2a082c7dc2473e4a7691b3bc454e780f [^]

Fixed bug 19718 Catched exception when delete a line in complete sales invoice

---
M src-db/database/model/triggers/C_INVOICELINETAX_TRG.xml
---
(0052112)
naiaramartinez   
2012-09-14 10:21   
Code review + testing OK
(0052753)
hudsonbot   
2012-09-26 17:19   
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/b780e90c6452 [^]

Maturity status: Test