Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029384ModulesIntrastatpublic2015-03-23 19:272016-11-14 13:12
Reporterngarcia 
Assigned Torqueralta 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket
OBNetwork customer
Regression introduced in release
Summary0029384: Statical Value is not transferred from Invoice Lines to Intrastat Declaration Lines
DescriptionStatical Value is not transferred from Invoice Lines to Intrastat Declaration Lines
Steps To ReproduceAs group admin role:
   Create two entries in the Organization - Intrastat tab for Shipments for the current and previous years
   Create a Sales Invoice for an European customer, fill at least the statical value field in Intrastat tab and complete it
   Go to Intrastat Launcher, fill the required parameters and launch it
   Check in Intrastat Declaration window that the created line does not have the statical value defined
Proposed SolutionCheck if adding the following line of code in generateNewIntrastatLines function of IntrastatLauncher class solves the problem:

iL.setStaticalAmt(intrInvoiceLine.getStaticalValue());
Additional Information
TagsNo tags attached.
Relationships
related to defect 0034484 closed vmromanos Not possible to select either "Year" and "Period" in Intrastat Launcher window. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-23 19:27ngarciaNew Issue
2015-03-23 19:27ngarciaAssigned To => jonalegriaesarte
2015-03-23 19:27ngarciaIssue Monitored: networkb
2015-07-28 13:01ngarciaAssigned Tojonalegriaesarte => Triage Finance
2015-09-14 18:45heccamIssue Monitored: heccam
2016-10-24 18:28ngarciaResolution time => 1479078000
2016-10-24 18:28ngarciaPriorityhigh => urgent
2016-10-24 18:28ngarciaSeverityminor => major
2016-10-24 18:32ngarciaProposed Solution updated
2016-10-25 18:23aferrazAssigned ToTriage Finance => markmm82
2016-10-25 21:54markmm82Statusnew => scheduled
2016-11-07 17:51rqueraltaAssigned Tomarkmm82 => rqueralta
2016-11-08 18:27rqueraltaNote Added: 0091255
2016-11-14 11:50psanjuanNote Added: 0091441
2016-11-14 12:00psanjuanNote Edited: 0091441bug_revision_view_page.php?bugnote_id=0091441#r13657
2016-11-14 12:00psanjuanRelationship addedrelated to 0034484
2016-11-14 12:00psanjuanNote Edited: 0091255bug_revision_view_page.php?bugnote_id=0091255#r13659
2016-11-14 12:01psanjuanNote Added: 0091442
2016-11-14 12:16psanjuanNote Edited: 0091442bug_revision_view_page.php?bugnote_id=0091442#r13661
2016-11-14 12:24psanjuanNote Added: 0091446
2016-11-14 13:11hgbotCheckin
2016-11-14 13:11hgbotNote Added: 0091449
2016-11-14 13:11hgbotStatusscheduled => resolved
2016-11-14 13:11hgbotResolutionopen => fixed
2016-11-14 13:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat/rev/2647113d62f37ae49f7280882bfd7cbb009c0c66 [^]
2016-11-14 13:11hgbotCheckin
2016-11-14 13:11hgbotNote Added: 0091450
2016-11-14 13:12aferrazReview Assigned To => aferraz
2016-11-14 13:12aferrazNote Added: 0091451
2016-11-14 13:12aferrazStatusresolved => closed

Notes
(0091255)
rqueralta   
2016-11-08 18:27   
(edited on: 2016-11-14 12:00)
Test plan:

As F&B International Group Admin

  - Go to Organization - Intrastat tab
  Create two entries for Shipments for the current and previous years
  - Go to Sales Invoice
  Create a Sales Invoice for an European customer, fill at least the statical value field in Intrastat tab and complete it
  - Go to Intrastat Launcher
  Fill the required parameters and launch it
  Check in Intrastat Declaration window that the created line does have the statical value defined
(0091441)
psanjuan   
2016-11-14 11:50   
(edited on: 2016-11-14 12:00)
Issue verified.

While verifying this issue another one is found. See issue related 34484.
(0091442)
psanjuan   
2016-11-14 12:01   
(edited on: 2016-11-14 12:16)
Test Plan

Test Case 1

Install Intrastat and Intrastat for Spain modules. Apply Intrastat dataset to F&B España org.

As F&B International Group Admin

Go to Organization window.
Select F&B España organization. Select Calendario España in the field "Intrastat Calendar". For doing so "Calendario España" needs to be set as Intrastat calendar.

Go to Intrastat tab and create below to records:
Organization = F&B España
Intrastat File Format = Intrastat para España
Year = 2016
Intrastat Declaration = Shipments
Limit Amount = 10.00
Incoterms = CIF
Transaction Type = Compra/Venta en Firme
Transportation Type = Road Transport
Statistical Regime = Salida de mercancias tras transformación.

Repeat same setup as above for Year 2017


Go to Intrastat tab and create below to records:
Organization = F&B España
Intrastat File Format = Intrastat para España
Year = 2016
Intrastat Declaration = Acquisitions
Limit Amount = 10.00
Incoterms = EXW
Transaction Type = Compras por particulares
Transportation Type = Rail Transport.

Repeat same setup as above for Year 2017

Go to Product window and select a product, for instance Cerveza Ale 0.5L. Make sure it is related to both a purchase and a sales price list.
Go to Intrastat tab and enter below info:

Commodity Code = 101010

Create a Sales Invoice for F&B España, for a customer located in France, for instance.
Go to Lines and select Cerveza Ale 0.5L product. Enter 150 units.
Save.
Go to Intrastat tab. Check it does have below data:

Commodity Code = 10101010
Net Mass = 150
Enter an Statistical Value = 855

Complete and post the invoice.

Go to Instrastat launcher and launch it for F&B España, 2016, November, Shipments and Normal Declaration.

Go to "Intrastat Declaration" window and check that there is one line in there having below information:
Invoice line Amount = 276.00 (total gross amount of the invoice)
Statistical value = 855
Commodity Code = 10101010
Net mass (Kg = 150 (invoiced quantity).


Repeat same test as above for a Purchase Invoice and therefore "Acquisition" Intrastat declaration.
(0091446)
psanjuan   
2016-11-14 12:24   
Test Plan above verified.

Issue can be code reviewed and closed.
(0091449)
hgbot   
2016-11-14 13:11   
Repository: erp/pmods/org.openbravo.module.intrastat
Changeset: 2647113d62f37ae49f7280882bfd7cbb009c0c66
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Tue Nov 08 12:08:28 2016 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat/rev/2647113d62f37ae49f7280882bfd7cbb009c0c66 [^]

Fixes issue 29384: Statical Value is not transferred from Invoice Lines

Fixed Statical Value is not transferred from Invoice Lines to Intrastat Declaration Lines

---
M src/org/openbravo/module/intrastat/IntrastatLauncher.java
---
(0091450)
hgbot   
2016-11-14 13:11   
Repository: erp/pmods/org.openbravo.module.intrastat
Changeset: 1b25fd2aec94d8ca4896d8b0b6f3faa7e2fb9212
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Nov 14 13:09:14 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat/rev/1b25fd2aec94d8ca4896d8b0b6f3faa7e2fb9212 [^]

Related to issue 29384: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0091451)
aferraz   
2016-11-14 13:12   
Code review OK