Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025177Openbravo ERP08. Project and service managementpublic2013-11-19 05:422013-12-02 09:21
Reporterpramakrishnan 
Assigned Topramakrishnan 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Version 
Target VersionFixed in Version3.0MP30 
Merge Request Status
Review Assigned Tojonalegriaesarte
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025177: 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
Error:
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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00248843.0MP30 closed pramakrishnan Purchase invoice created through Create Invoice from Expenses can not be deleted 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-11-19 05:42pramakrishnanNew Issue
2013-11-19 05:42pramakrishnanAssigned To => iciordia
2013-11-19 05:42pramakrishnanWeb browser => Google Chrome
2013-11-19 05:42pramakrishnanModules => Core
2013-11-19 05:42pramakrishnanTriggers an Emergency Pack => No
2013-11-19 05:44pramakrishnanRelationship addedrelated to 0024884
2013-11-19 08:23iciordiaNote Added: 0062215
2013-11-19 08:23iciordiaAssigned Toiciordia => pramakrishnan
2013-11-19 09:24pramakrishnanReview Assigned To => jonalegriaesarte
2013-11-19 09:24pramakrishnanWeb browserGoogle Chrome => Google Chrome
2013-11-19 09:24pramakrishnanStatusnew => scheduled
2013-11-19 09:24hgbotCheckin
2013-11-19 09:24hgbotNote Added: 0062216
2013-11-19 09:24hgbotStatusscheduled => resolved
2013-11-19 09:24hgbotResolutionopen => fixed
2013-11-19 09:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/c4b23df10e109acc2461d00fd9576fad35d2130b [^]
2013-12-02 09:21jonalegriaesarteNote Added: 0062475
2013-12-02 09:21jonalegriaesarteStatusresolved => closed
2013-12-02 09:21jonalegriaesarteFixed in Version => 3.0MP30

Notes
(0062215)
iciordia   
2013-11-19 08:23   
Approved.

Ismael
(0062216)
hgbot   
2013-11-19 09:24   
Repository: erp/devel/api-checks
Changeset: c4b23df10e109acc2461d00fd9576fad35d2130b
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Tue Nov 19 13:44:12 2013 +0530
URL: http://code.openbravo.com/erp/devel/api-checks/rev/c4b23df10e109acc2461d00fd9576fad35d2130b [^]

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
---
(0062475)
jonalegriaesarte   
2013-12-02 09:21   
Closed