Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021949ModulesIntrastatpublic2012-10-16 12:062013-01-23 10:42
Reporterngarcia 
Assigned Tongarcia 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version1.0.10Fixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tocaristu
Support ticket
OBNetwork customer
Regression introduced in release
Summary0021949: Intrastat line created for an invoice with a shipment to a non-european country
DescriptionIntrastat line created for an invoice with a shipment to a non-european country.
Steps To ReproduceAs group admin role:
   Configure the Intrastat for F&B España, S.A.
   Create a Business Partner as Customer
   Configure two locations to it:
      Shipping address: USA
      Invoice address: Germany
   Create a goods shipment for that BP and realize that the shipping address is selected in the header. Complete it. Check that no lines are created in the Intrastat tab
   Create a sales invoice from it. Notice that the invoice address is selected in the header. Complete it. Notice that a line is created in the Intrastat tab without any value in the fields related to Intrastat. This line should not be created
Proposed SolutionIn the INTR_C_INVOICELINE_TRG trigger:

In line 232 (WHEN NO_DATA_FOUND THEN), NULL value is assigned to all variables and then, in line 291 (INSERT INTO intr_c_invoiceline) this values are inserted. It should be checked if the previous data was not null before inserting the line, for example, assigning a value to a variable after line 232 and checking it before line 291.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-16 12:06ngarciaNew Issue
2012-10-16 12:06ngarciaAssigned To => jonalegriaesarte
2012-10-16 12:06ngarciaIssue Monitored: networkb
2012-10-16 12:08ngarciaNote Added: 0053370
2012-11-14 14:05jonalegriaesarteAssigned Tojonalegriaesarte => ngarcia
2013-01-02 16:32hgbotCheckin
2013-01-02 16:32hgbotNote Added: 0055305
2013-01-02 16:32hgbotStatusnew => resolved
2013-01-02 16:32hgbotResolutionopen => fixed
2013-01-02 16:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat/rev/6e28b55ab6d5743a0f1af245043fe536e1a52090 [^]
2013-01-23 10:42caristuReview Assigned To => caristu
2013-01-23 10:42caristuNote Added: 0055752
2013-01-23 10:42caristuStatusresolved => closed

Notes
(0053370)
ngarcia   
2012-10-16 12:08   
support ticket: 17482
resolution time: 27/12/2012
(0055305)
hgbot   
2013-01-02 16:32   
Repository: erp/pmods/org.openbravo.module.intrastat
Changeset: 6e28b55ab6d5743a0f1af245043fe536e1a52090
Author: Naiara Garcia <naiara.garcia <at> openbravo.com>
Date: Wed Jan 02 13:59:15 2013 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat/rev/6e28b55ab6d5743a0f1af245043fe536e1a52090 [^]

Fixed issue 21949: Intrastat line created for an invoice with a shipment to a
non-european country

---
M src-db/database/model/triggers/INTR_C_INVOICELINE_TRG.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_PROCESS.xml
---
(0055752)
caristu   
2013-01-23 10:42   
Verified