Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 08. Project and service managementmajorhave not tried2013-11-19 05:422013-12-02 09:21
ReporterpramakrishnanView Statuspublic 
Assigned Topramakrishnan 
PriorityurgentResolutionfixedFixed in Version3.0MP30
StatusclosedFix in branchFixed in SCM revisionc4b23df10e10
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Tojonalegriaesarte
Web browserGoogle Chrome
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0025177: API Change: Add Constraint to update C_InvoiceLine_ID to null when deleting the invoice line

DescriptionPurchase invoice created through Create Invoice from Expenses can not be deleted. It is created in draft status but the user can not delete it, because the expense sheet line is linked to the invoice line. Without this constraint, this will end up in a dead lock situation since the invoice could not be deleted because it is linked to expense sheet and the expense sheet cannot be unprocessed or deleted since it has related invoice. Adding the constraint will resolve this and the risk is low since the invoice could be deleted only when the invoice is in 'draft' status.
Steps To Reproduce- Expense sheet, create a new one with one line and process it.
- Create invoice from expenses
- Access to the purchase invoice and try to delete it
This record cannot be deleted because it is associated with other existing elements. Please see Linked Items

Check that the invoice line is linked to expense line
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00248843.0MP30 closedpramakrishnan Purchase invoice created through Create Invoice from Expenses can not be deleted 

-  Notes
iciordia (manager)
2013-11-19 08:23


hgbot (developer)
2013-11-19 09:24

Repository: erp/devel/api-checks
Changeset: c4b23df10e109acc2461d00fd9576fad35d2130b
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at>>
Date: Tue Nov 19 13:44:12 2013 +0530
URL: [^]

Fixes Issue 25177: Add Constraint to update C_InvoiceLine_ID to null when deleting the invoice line

M model/src-db/database/model/tables/S_TIMEEXPENSELINE.xml
jonalegriaesarte (reporter)
2013-12-02 09:21


- Issue History
Date Modified Username Field Change
2013-11-19 05:42 pramakrishnan New Issue
2013-11-19 05:42 pramakrishnan Assigned To => iciordia
2013-11-19 05:42 pramakrishnan Web browser => Google Chrome
2013-11-19 05:42 pramakrishnan Modules => Core
2013-11-19 05:42 pramakrishnan Triggers an Emergency Pack => No
2013-11-19 05:44 pramakrishnan Relationship added related to 0024884
2013-11-19 08:23 iciordia Note Added: 0062215
2013-11-19 08:23 iciordia Assigned To iciordia => pramakrishnan
2013-11-19 09:24 pramakrishnan Review Assigned To => jonalegriaesarte
2013-11-19 09:24 pramakrishnan Web browser Google Chrome => Google Chrome
2013-11-19 09:24 pramakrishnan Status new => scheduled
2013-11-19 09:24 hgbot Checkin
2013-11-19 09:24 hgbot Note Added: 0062216
2013-11-19 09:24 hgbot Status scheduled => resolved
2013-11-19 09:24 hgbot Resolution open => fixed
2013-11-19 09:24 hgbot Fixed in SCM revision => [^]
2013-12-02 09:21 jonalegriaesarte Note Added: 0062475
2013-12-02 09:21 jonalegriaesarte Status resolved => closed
2013-12-02 09:21 jonalegriaesarte Fixed in Version => 3.0MP30

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker