0013861: Modifications in Intrastat tab at lines level are overrided when completing the document

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0013861

Modules

Intrastat

public

2010-07-01 17:32

2012-06-12 14:06

Reporter

vmromanos

Assigned To

jonalegriaesarte

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Debian 5.0

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0013861: Modifications in Intrastat tab at lines level are overrided when completing the document

Description

Modifications in Intrastat tab at lines level are overrided when completing the document

Steps To Reproduce

Create an invoice for an EU business partner
Add a line
go to Intrastat tab
Modify one field
Complete the invoice
Check the modified field has been override

Proposed Solution

Wrong code in line triggers:
IF (TG_OP = 'UPDATE') THEN
DELETE FROM INTR_C_INVOICELINE WHERE C_INVOICELINE_ID=old.C_InvoiceLine_ID;
END IF;

It affects manual modifications done by the user

Additional Information