Openbravo Issue Tracking System - Modules
View Issue Details
0034484ModulesIntrastatpublic2016-11-14 11:582016-11-15 11:08
psanjuan 
vmromanos 
urgentmajoralways
closedfixed 
20Professional Appliance
 
 
aferraz
0034484: Not possible to select either "Year" and "Period" in Intrastat Launcher window.
Not possible to select either "Year" and "Period" in Intrastat Launcher window.
In an enviroment updated to last Openbravo core changes, install Intrastat module

Go to Fiscal Calendar and set F&B España calendar as "Intrastat Calendar".

Select that calendar for the organization F&B España in "Organization" window.

Create some records in Intrastat tab for "Shipment" declaration, year 2016 and 100.00 as limit.

Create a sales invoice for a customer located in France, for any product and a total gross of 1000.00 €. Verify that the tax rate used is "Entregas Intracomunitarias Exentas".

Complete and Post the invoice.

Go to Intrastat Launcher window. Select the organization.

Verify it is not possible to select the year and the period in that window.
No tags attached.
related to defect 0029384 closed rqueralta Statical Value is not transferred from Invoice Lines to Intrastat Declaration Lines 
related to defect 0034895 closed vmromanos Tax Report Launcher window not working since 16Q4 
Issue History
2016-11-14 11:58psanjuanNew Issue
2016-11-14 11:58psanjuanAssigned To => Triage Finance
2016-11-14 12:00psanjuanRelationship addedrelated to 0029384
2016-11-14 13:24vmromanosStatusnew => scheduled
2016-11-14 13:24vmromanosAssigned ToTriage Finance => vmromanos
2016-11-14 13:40hgbotCheckin
2016-11-14 13:40hgbotNote Added: 0091457
2016-11-14 13:40hgbotStatusscheduled => resolved
2016-11-14 13:40hgbotResolutionopen => fixed
2016-11-14 13:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat/rev/8557ed6ab1134eea505569059e405fd9b505ecdb [^]
2016-11-14 13:48vmromanosNote Added: 0091459
2016-11-14 14:46hgbotCheckin
2016-11-14 14:46hgbotNote Added: 0091461
2016-11-14 15:01hgbotCheckin
2016-11-14 15:01hgbotNote Added: 0091462
2016-11-14 15:02vmromanosNote Added: 0091463
2016-11-15 10:24psanjuanNote Added: 0091536
2016-11-15 10:24psanjuanNote Added: 0091537
2016-11-15 11:08aferrazReview Assigned To => aferraz
2016-11-15 11:08aferrazNote Added: 0091545
2016-11-15 11:08aferrazStatusresolved => closed
2017-01-10 13:39vmromanosRelationship addedrelated to 0034895

Notes
(0091457)
hgbot   
2016-11-14 13:40   
Repository: erp/pmods/org.openbravo.module.intrastat
Changeset: 8557ed6ab1134eea505569059e405fd9b505ecdb
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Nov 14 13:36:12 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat/rev/8557ed6ab1134eea505569059e405fd9b505ecdb [^]

Fixed bug 34484: Not possible to select either "Year" and "Period" in Intrastat Launcher

In 16Q4 the callout mapping is not included in web.xml file anymore.
The manual window Intrastat Launcher has a non-standard call to a declared callout. Since the mapping is not generated anymore, the java code is never executed and the user is unable to launch the Intrastat.

The fix declares the callout (servlet) in Form window, so a mapping is generated, and thus the java code is properly invoked.
This changeset requires a new major version compatible from 3.0.16Q4 (or above). In previous versions this issue is not reproducible.
Note that Openbravo 2.50 is not oficially supported anymore, so that's why we can force the dependency to 3.0.16Q4

---
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
A src-db/database/sourcedata/AD_FORM.xml
---
(0091459)
vmromanos   
2016-11-14 13:48   
Fixed in 3.0.0 (or above).

Please note that a new major version is required to force Core's dependency from 16Q4, where this issue starts to be reproducible.
Previous 1.X versions were compatible with Openbravo 2.50 too.
(0091461)
hgbot   
2016-11-14 14:46   
Repository: erp/pmods/org.openbravo.module.intrastat.spain
Changeset: 6e81edecf8b07731f4d00b30341a8f8b2f1b279a
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Nov 14 14:47:08 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat.spain/rev/6e81edecf8b07731f4d00b30341a8f8b2f1b279a [^]

Related to issue 34484: Set dependency enforcement to none

---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0091462)
hgbot   
2016-11-14 15:01   
Repository: erp/pmods/org.openbravo.module.intrastat.es_ES
Changeset: 9191db4a12ddc7e38898bbe6d849e02bb86afe7e
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Nov 14 15:02:14 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.intrastat.es_ES/rev/9191db4a12ddc7e38898bbe6d849e02bb86afe7e [^]

Related to issue 34484: Set dependency enforcement to none

---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0091463)
vmromanos   
2016-11-14 15:02   
Released new minor version of "Intrastat for Spain" and "Intrastat – Spanish translation" with dependency enforcement = None, so both are compatible with new major version too.
(0091536)
psanjuan   
2016-11-15 10:24   
Test Plan

In an enviroment updated to last Openbravo core changes, install Intrastat module.

Go to Fiscal Calendar and set F&B España calendar as "Intrastat Calendar".

Select that calendar for the organization F&B España in "Organization" window.

Create some records in Intrastat tab for "Shipment" declaration, year 2016, 2017 and a given limit amount.

Repeat same as above for "Acquisiton" declaration.

Create a sales invoice for a customer located in France, for any product and an invoice total gross of 1000.00 €. Verify that the tax rate used is "Entregas Intracomunitarias Exentas".

Complete and Post the invoice.

Create a purchase invoice for a vendor located in Italy, for any product and an invoice total gross of 5000.00 €. Verify that the tax rate used is "Adquisiciones Intracomunitarias 21%".

Complete and Post the invoice.

Go to Intrastat Launcher window. Select the organization.

Verify it is possible to select a year and a period.
Select Year = 2016, Perido = Nov-16, as that is the date of the invoices booked.

Select "Shipments" and "Normal Declaration".

Verify a "shipment" Intrastat Declaration type is created and can be reviewed in Intrastat Declaration window.

Run Intrastat declaration for Acquisitions.

Verify an "acquisition" Intrastat Declaration type is created and can be reviewed in Intrastat Declaration window.
(0091537)
psanjuan   
2016-11-15 10:24   
Issue can be closed.
(0091545)
aferraz   
2016-11-15 11:08   
Code review OK