Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048606ModulesIntrastatpublic2022-02-15 17:242022-02-28 16:31
Reporterpsanjuan 
Assigned Tomgonzalezh 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0048606: Correcta inclusión de operaciones de venta a distancia en Intrastat
DescriptionCorrecta inclusión de operaciones de venta a distancia en Intrastat
Steps To ReproduceN/A
Proposed Solution"Si el vendedor tiene NIF-IVA español y es sujeto pasivo del IVA en el territorio de aplicación del IVA. Si es así, deberá presentar una declaración de exportación a la UE por las ventas que realice a particulares de otros Estados miembros o Irlanda del Norte, siempre que supere los umbrales anuales de exención (400.000 euros en el flujo de exportación). Como NIF-IVA de la contraparte, al ser sus clientes particulares no sujetos pasivos del IVA, debe poner el código genérico QV999999999999."

En términos de Openbravo, los cambios a realizar son:

Si una factura de venta a cliente se incluye en el Intrastat, aquellas facturas emitidas a un cliente particular, tendrán que indicarse con un valor fijo (QV999999999999), en el campo Tax ID, posición 14.

Por tanto, se debe crear un nuevo campo denominado "Es cliente particular" en la ventana "Tercero", solapa "Cliente", sub-solapa "Intrastat Shipments" (Entregas)

Este campo no es obligatorio es tipo check Yes/NO, con valor por defecto NO.

El usuario lo tendrá que configurar de forma manual

Si un Tercero/Cliente esta configurado de esta forma com "Es cliente particular" = YES, el Tax ID del tercero no se tiene que tener en cuenta (este informado o no), al generar el Instratat ya que se tiene que indicar de forma fija, el valor "QV999999999999".
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0048574 closed mgonzalezh Error de generación del Intrastat cuando el fichero tiene un cliente (expediciones) de Grecia 
Attached Filespng Screenshot from 2022-02-16 11-13-42.png (42,391) 2022-02-16 11:13
https://issues.openbravo.com/file_download.php?file_id=16633&type=bug
png

txt Intrastat-Shipments-Normaldeclaration-2022-Feb-22 (1).txt (277) 2022-02-25 15:08
https://issues.openbravo.com/file_download.php?file_id=16676&type=bug
Issue History
Date ModifiedUsernameFieldChange
2022-02-15 17:24psanjuanNew Issue
2022-02-15 17:24psanjuanAssigned To => Jorge Bravo
2022-02-16 10:07psanjuanSummaryAnalizar si las transacciones que se incluyen en Intrastat, son las relacionadas con impuestos de compra/venta intracomunitarios => Analizar la inclusión de operaciones de venta a distancia
2022-02-16 10:07psanjuanDescription Updatedbug_revision_view_page.php?rev_id=23674#r23674
2022-02-16 10:07psanjuanProposed Solution updated
2022-02-16 11:13psanjuanFile Added: Screenshot from 2022-02-16 11-13-10.png
2022-02-16 11:13psanjuanFile Deleted: Screenshot from 2022-02-16 11-13-10.png
2022-02-16 11:13psanjuanFile Added: Screenshot from 2022-02-16 11-13-42.png
2022-02-21 14:45psanjuanProposed Solution updated
2022-02-21 14:46psanjuanSummaryAnalizar la inclusión de operaciones de venta a distancia => Correcta inclusión de operaciones de venta a distancia en Intrastat
2022-02-21 14:46psanjuanDescription Updatedbug_revision_view_page.php?rev_id=23689#r23689
2022-02-21 14:46psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=23691#r23691
2022-02-21 14:46psanjuanProposed Solution updated
2022-02-22 10:19Alberto_SolaIssue Monitored: Alberto_Sola
2022-02-22 15:07psanjuanProposed Solution updated
2022-02-22 15:08psanjuanProposed Solution updated
2022-02-22 15:08psanjuanProposed Solution updated
2022-02-22 15:27Jorge BravoAssigned ToJorge Bravo => mgonzalezh
2022-02-23 17:50mgonzalezhRelationship addeddepends on 0048574
2022-02-23 21:24hgbotNote Added: 0135257
2022-02-23 21:24hgbotNote Added: 0135258
2022-02-23 21:24hgbotNote Added: 0135259
2022-02-24 14:27Jorge BravoNote Added: 0135277
2022-02-25 15:08psanjuanFile Added: Intrastat-Shipments-Normaldeclaration-2022-Feb-22 (1).txt
2022-02-28 16:31hgbotResolutionopen => fixed
2022-02-28 16:31hgbotStatusnew => closed
2022-02-28 16:31hgbotNote Added: 0135345
2022-02-28 16:31hgbotNote Added: 0135346
2022-02-28 16:31hgbotNote Added: 0135347
2022-02-28 16:31hgbotNote Added: 0135348
2022-02-28 16:31hgbotNote Added: 0135350
2022-02-28 16:31hgbotNote Added: 0135351
2022-02-28 16:31hgbotNote Added: 0135352

Notes
(0135257)
hgbot   
2022-02-23 21:24   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat/-/merge_requests/5 [^]
(0135258)
hgbot   
2022-02-23 21:24   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.es_ES/-/merge_requests/2 [^]
(0135259)
hgbot   
2022-02-23 21:24   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/merge_requests/4 [^]
(0135277)
Jorge Bravo   
2022-02-24 14:27   
TEST PLAN:
 1 - Crear un tercero e indicar en la solapa "Cliente", sub-solapa "Intrastat", campo denominado "Es cliente particular"=SI. No es necesario que el campo CIF/NIF de la cabecera del tercero contenga información (puede estar vacío)

 2 - Crear una factura de venta para este cliente.

 3 - Generar la declaración de intrastat (en el fichero se recoge en la posición 14 el valor QV999999999999)
(0135345)
hgbot   
2022-02-28 16:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat [^]
Changeset: 9aa8a03df85c2bdce452bd7d91afcf2942f69877
Author: Maykel Gonzalez <maykel.gonzalez@smfconsulting.es>
Date: 23-02-2022 15:19:40
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat/-/commit/9aa8a03df85c2bdce452bd7d91afcf2942f69877 [^]

Fixed ISSUE-48606: Added generic TaxId for private customers.
---
M src-db/database/model/tables/INTR_C_BPARTNER.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MODULE.xml
---
(0135346)
hgbot   
2022-02-28 16:31   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat/-/merge_requests/5 [^]
(0135347)
hgbot   
2022-02-28 16:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.es_ES [^]
Changeset: 14cd8e1175857e3449cfadedafc33fc15dd994a9
Author: Maykel Gonzalez <maykel.gonzalez@smfconsulting.es>
Date: 23-02-2022 15:21:16
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.es_ES/-/commit/14cd8e1175857e3449cfadedafc33fc15dd994a9 [^]

Fixed ISSUE-48606: Added generic TaxId for private customers.
---
M referencedata/translation/AD_ELEMENT_TRL_es_ES.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0135348)
hgbot   
2022-02-28 16:31   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.es_ES/-/merge_requests/2 [^]
(0135350)
hgbot   
2022-02-28 16:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain [^]
Changeset: 0c318d3feae16dd79d7809f90745ae2ae3bc9127
Author: Maykel Gonzalez <maykel.gonzalez@smfconsulting.es>
Date: 23-02-2022 15:21:58
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/commit/0c318d3feae16dd79d7809f90745ae2ae3bc9127 [^]

Fixed ISSUE-48574: Removed country validation.
Fixed ISSUE-48606: Added generic TaxId for private customers.
---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
M src/org/openbravo/module/intrastat/spain/ProcessAndGenerateIntrastat_Spain.java
---
(0135351)
hgbot   
2022-02-28 16:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain [^]
Changeset: 26358627d9898b7c1f7ab3d9d6f7daf72c0ab635
Author: Maykel Gonzalez <maykel.gonzalez@smfconsulting.es>
Date: 24-02-2022 08:01:52
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/commit/26358627d9898b7c1f7ab3d9d6f7daf72c0ab635 [^]

Fixed ISSUE-48606: Fixing empty list error.
---
M src/org/openbravo/module/intrastat/spain/ProcessAndGenerateIntrastat_Spain.java
---
(0135352)
hgbot   
2022-02-28 16:31   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/merge_requests/4 [^]