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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0019718
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminorhave not tried2012-02-10 04:332012-09-26 17:19
ReporterborisView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisioned8fe55b2a08
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version3.0MP7.1SCM revisionactually 7.2 
Review Assigned Tonaiaramartinez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019718: 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.
TagsVMA-Reviewed
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0048792)
Sandrahuguet (developer)
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 (developer)
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 (developer)
2012-09-14 10:21

Code review + testing OK
(0052753)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2012-02-10 04:33 boris New Issue
2012-02-10 04:33 boris Assigned To => jonalegriaesarte
2012-02-10 04:33 boris Modules => Core
2012-04-03 12:20 jonalegriaesarte Assigned To jonalegriaesarte => vmromanos
2012-04-11 09:41 vmromanos Tag Attached: VMA-Reviewed
2012-05-10 12:12 gorka_gil Assigned To vmromanos => mirurita
2012-05-17 17:12 Sandrahuguet Assigned To mirurita => Sandrahuguet
2012-05-17 17:12 Sandrahuguet Status new => scheduled
2012-05-17 17:12 Sandrahuguet fix_in_branch => pi
2012-05-21 09:16 Sandrahuguet Note Added: 0048792
2012-09-14 10:20 hgbot Checkin
2012-09-14 10:20 hgbot Note Added: 0052111
2012-09-14 10:20 hgbot Status scheduled => resolved
2012-09-14 10:20 hgbot Resolution open => fixed
2012-09-14 10:20 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ed8fe55b2a082c7dc2473e4a7691b3bc454e780f [^]
2012-09-14 10:21 naiaramartinez Closed by => naiaramartinez
2012-09-14 10:21 naiaramartinez Note Added: 0052112
2012-09-14 10:21 naiaramartinez Status resolved => closed
2012-09-26 17:19 hudsonbot Checkin
2012-09-26 17:19 hudsonbot Note Added: 0052753


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker