0021949: Intrastat line created for an invoice with a shipment to a non-european country

Description

Intrastat line created for an invoice with a shipment to a non-european country.

Steps To Reproduce

As 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 Solution

In 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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0053370) ngarcia (developer) 2012-10-16 12:08	support ticket: 17482 resolution time: 27/12/2012

(0055305) hgbot (developer) 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 (manager) 2013-01-23 10:42	Verified

Issue History
Date Modified	Username	Field	Change
2012-10-16 12:06	ngarcia	New Issue
2012-10-16 12:06	ngarcia	Assigned To	=> jonalegriaesarte
2012-10-16 12:06	ngarcia	Issue Monitored: networkb
2012-10-16 12:08	ngarcia	Note Added: 0053370
2012-11-14 14:05	jonalegriaesarte	Assigned To	jonalegriaesarte => ngarcia
2013-01-02 16:32	hgbot	Checkin
2013-01-02 16:32	hgbot	Note Added: 0055305
2013-01-02 16:32	hgbot	Status	new => resolved
2013-01-02 16:32	hgbot	Resolution	open => fixed
2013-01-02 16:32	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat/rev/6e28b55ab6d5743a0f1af245043fe536e1a52090 [^]
2013-01-23 10:42	caristu	Review Assigned To	=> caristu
2013-01-23 10:42	caristu	Note Added: 0055752
2013-01-23 10:42	caristu	Status	resolved => closed