Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012114Openbravo ERP07. Sales managementpublic2010-02-03 12:392010-03-10 18:28
Reporterplujan 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version2.50MP12Fixed in Version2.50MP12 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012114: Error in a trigger when executing the Generate Invoice process
DescriptionWhen executing the Generate Invoice process, I got an error regarding C_INVOICELINE_TRG2 (see attached image)
Steps To Reproduce1. Create some orders for past month as stated in test case SAL0060
2. Go and launch the Generate Invoice process
3. An error is displayed and no invoice is created
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00121182.50MP12 closed eduardo_Argal In Postgres, I have an error when creating a purchase order line 
Attached Filespng 2_50_mp12_GenerateInvoiceProcess.PNG (22,497) 2010-02-03 12:39
https://issues.openbravo.com/file_download.php?file_id=2171&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-02-03 12:39plujanNew Issue
2010-02-03 12:39plujanAssigned To => eduardo_Argal
2010-02-03 12:39plujanFile Added: 2_50_mp12_GenerateInvoiceProcess.PNG
2010-02-03 12:39plujanOBNetwork customer => No
2010-02-03 12:39plujanStatusnew => scheduled
2010-02-03 12:39plujanfix_in_branch => pi
2010-02-03 16:28plujanRelationship addedrelated to 0012118
2010-02-04 20:09hgbotCheckin
2010-02-04 20:09hgbotNote Added: 0023969
2010-02-04 20:09hgbotStatusscheduled => resolved
2010-02-04 20:09hgbotResolutionopen => fixed
2010-02-04 20:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/32862cded0b512517c07ede2aa91f24bc3e2aca8 [^]
2010-02-05 17:09plujanNote Added: 0023995
2010-02-05 17:09plujanStatusresolved => closed
2010-02-05 17:09plujanFixed in Version => pi
2010-02-08 10:09arunkumarStatusclosed => new
2010-02-08 10:09arunkumarResolutionfixed => open
2010-02-08 10:09arunkumarFixed in Versionpi =>
2010-02-08 11:49eduardo_ArgalStatusnew => scheduled
2010-02-08 16:23hgbotCheckin
2010-02-08 16:23hgbotNote Added: 0024024
2010-02-08 16:23hgbotStatusscheduled => resolved
2010-02-08 16:23hgbotResolutionopen => fixed
2010-02-08 16:23hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/32862cded0b512517c07ede2aa91f24bc3e2aca8 [^] => http://code.openbravo.com/erp/devel/pi/rev/a29c59cd7cc056fd3c51c0c15548d55c9ba944a8 [^]
2010-02-15 17:36hudsonbotCheckin
2010-02-15 17:36hudsonbotNote Added: 0024295
2010-02-15 17:36hudsonbotCheckin
2010-02-15 17:36hudsonbotNote Added: 0024305
2010-02-17 12:04arunkumarNote Added: 0024478
2010-02-17 12:04arunkumarStatusresolved => closed
2010-02-17 12:04arunkumarFixed in Version => 2.50MP12
2010-02-18 00:00anonymoussf_bug_id0 =>
2010-03-10 18:28anonymoussf_bug_id => 2967928

Notes
(0023969)
hgbot   
2010-02-04 20:09   
Repository: erp/devel/pi
Changeset: 32862cded0b512517c07ede2aa91f24bc3e2aca8
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Feb 04 20:08:25 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/32862cded0b512517c07ede2aa91f24bc3e2aca8 [^]

Fixes bug 0012114: Error in a trigger when executing the Generate Invoice process

---
M src-db/database/model/functions/C_INVOICELINETAX_INSERT.xml
---
(0023995)
plujan   
2010-02-05 17:09   
Tested in PI
(0024024)
hgbot   
2010-02-08 16:23   
Repository: erp/devel/pi
Changeset: a29c59cd7cc056fd3c51c0c15548d55c9ba944a8
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Feb 08 16:21:10 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a29c59cd7cc056fd3c51c0c15548d55c9ba944a8 [^]

Fixes bug 0012114: Error in a trigger when executing the Generate Invoice process

---
M src-db/database/model/triggers/C_INVOICELINE_TRG2.xml
---
(0024295)
hudsonbot   
2010-02-15 17:36   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/32862cded0b5 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2596487a564c [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16391.obx [^]
(0024305)
hudsonbot   
2010-02-15 17:36   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/a29c59cd7cc0 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2596487a564c [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16391.obx [^]
(0024478)
arunkumar   
2010-02-17 12:04   
Tested & Working fine