Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0044417ModulesIntrastat for Spainpublic2020-06-18 17:562020-09-09 12:31
ReporterAlberto_Sola 
Assigned ToMery Anelo 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
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
Summary0044417: Error al presentar Intrastat "El valor estadístico no puede tener más de 2 decimales...."
DescriptionAl presentar el fichero en la AEAT se obtiene el siguiente mensaje de error:
"El valor estadístico no puede tener más de 2 decimales...."

Steps To Reproduce1º Generar la declaración de Intrastat,
En la pantalla de la declaración se aprecian dos decimales de los cuales el segundo siempre está redondeado.

2º generar fichero txt y al presentar en la AEAT se obtiene el mensaje de error:
"El valor estadístico no puede tener más de 2 decimales...."

3º Al revisar el fichero presentado en la AEAT se observan en ocasiones hasta 4 decimales, cuando por normativa solo deben de presentarse dos.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesjpg CapturaIntrastat.JPG (27,095) 2020-06-18 17:56
https://issues.openbravo.com/file_download.php?file_id=14652&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2020-06-18 17:56Alberto_SolaNew Issue
2020-06-18 17:56Alberto_SolaAssigned To => Jorge Bravo
2020-06-18 17:56Alberto_SolaFile Added: CapturaIntrastat.JPG
2020-06-18 17:56Alberto_SolaIssue Monitored: Alberto_Sola
2020-06-29 11:08psanjuanNote Added: 0121141
2020-06-29 11:08psanjuanNote Deleted: 0121141
2020-06-29 11:09psanjuanNote Added: 0121142
2020-06-29 11:09psanjuanNote Added: 0121143
2020-06-29 11:12psanjuanIssue Monitored: psanjuan
2020-06-29 11:15psanjuanIssue End Monitor: psanjuan
2020-07-20 16:10Jorge BravoAssigned ToJorge Bravo => Mery Anelo
2020-08-06 02:43Mery AneloNote Added: 0121866
2020-08-06 02:43Mery AneloStatusnew => scheduled
2020-08-21 14:59vmromanosProjectLocalization Pack: Spain => Modules
2020-08-21 15:00vmromanosCategorySpain Professional Localization Pack => Intrastat for Spain
2020-08-27 03:07hgbotNote Added: 0122364
2020-09-09 12:31hgbotResolutionopen => fixed
2020-09-09 12:31hgbotStatusscheduled => closed
2020-09-09 12:31hgbotNote Added: 0122867
2020-09-09 12:31hgbotNote Added: 0122868
2020-09-09 12:31hgbotNote Added: 0122869
2020-09-09 12:31hgbotNote Added: 0122870
2020-09-09 12:31hgbotNote Added: 0122871
2020-09-09 12:31hgbotNote Added: 0122872

Notes
(0121142)
psanjuan   
2020-06-29 11:09   
SMF
Hola Alberto,

En el cliente que comentas, cómo se están introduciendo los datos del valor estadístico? Tienen alguna customización para rellenarlo?

Te comento esto porque creemos que en BBDD este campo está rellenado con 4 decimales y es por eso que el fichero recoge los 4 decimales. Con el resto de clientes que tenemos no se produce este problema porque todos ellos tienen 2 decimales en BBDD.

Puedes confirmar esta teoría?

Saludos,
(0121143)
psanjuan   
2020-06-29 11:09   
Precognis

Buenas tardes Jorge, perdona que no te haya respondido antes, estaba de vacaciones.

Hemos revisado lo que comentas y no es posible porque el campo valor estadístico se rellena de forma automática con la fórmula:
importe neto + ( ( cantidad facturada * peso del producto) * %) , puedes encontrar más información en http://wiki.openbravo.com/wiki/Projects:Intrastat [^]


Te puedo confirmar que hemos observado que cuando el producto tiene indicado un peso con tres decimales entonces dispara el redondeo del valor estadístico en la pantalla de Declaración de Intrastat mostrando el fichero con más de dos decimales.

¿podrían confirmar este extremo y de ser así poder corregirlo?

Quedo a la espera de sus comentarios , muchas gracias.
(0121866)
Mery Anelo   
2020-08-06 02:43   
Test Plan:
- Edit the file Format.xml to be able to use three or more decimals.
- Compile and restart tomcat
- Log as System Admin
- Change the precision price and costing to tree or more decimals. See the following link: http://wiki.openbravo.com/wiki/How_to_change_the_price_precision [^]
- Log as Group Admin Role
- Configure the intrastat according to the user manual. See the following link: http://wiki.openbravo.com/wiki/Projects/Intrastat/Manual_de_Usuario_es_ES [^]
- Make sure to use numbers that do not give round values ​​when making the accounts corresponding to the intrastat.
     -For example: In the product config use a "Net Mass (Kg): 1.608", Organization "Statistical Value %: 12".
- After that create a purchase invoice, note the above.
     -For example: Line with the configure product "Quantity Invoiced: 11" and "Net Unit Price: 10.171"
- Complete the process and generate the intrastat declare.
- Make sure the decimal places printed in the file are 2
(0122364)
hgbot   
2020-08-27 03:07   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/merge_requests/1 [^]
(0122867)
hgbot   
2020-09-09 12:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain [^]
Changeset: 3447d9774ad0a39eef9deef8f7670d3d4df746e8
Author: Mery Anelo <mery.anelo@smfconsulting.es>
Date: 2020-08-26T21:57:29-03:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/commit/3447d9774ad0a39eef9deef8f7670d3d4df746e8 [^]

Fixed BUG-44417: Format java

---
M src/org/openbravo/module/intrastat/spain/ProcessAndGenerateIntrastat_Spain.java
---
(0122868)
hgbot   
2020-09-09 12:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain [^]
Changeset: e0a4419e7bbf204544973099d70b4ecd53e801fd
Author: Mery Anelo <mery.anelo@smfconsulting.es>
Date: 2020-08-26T22:01:16-03:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/commit/e0a4419e7bbf204544973099d70b4ecd53e801fd [^]

Fixed BUG-44417: Round decimal places in the statistical value of the Intrastat

Find the standard precision of the currency on the invoice and use it to round the value.

---
M src/org/openbravo/module/intrastat/spain/ProcessAndGenerateIntrastat_Spain.java
---
(0122869)
hgbot   
2020-09-09 12:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain [^]
Changeset: d1672b3aed29f91fe38b75f99dd3b7d74a3fcf0b
Author: Mery Anelo <mery.anelo@smfconsulting.es>
Date: 2020-08-28T12:08:28-03:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/commit/d1672b3aed29f91fe38b75f99dd3b7d74a3fcf0b [^]

Fixed BUG-44417: Round decimal places in the statistical value of the Intrastat

Method correction.

---
M src/org/openbravo/module/intrastat/spain/ProcessAndGenerateIntrastat_Spain.java
---
(0122870)
hgbot   
2020-09-09 12:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain [^]
Changeset: 7b71bbdd1b984be08237a857607ee025665dda61
Author: Mery Anelo <mery.anelo@smfconsulting.es>
Date: 2020-09-03T11:26:43-03:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/commit/7b71bbdd1b984be08237a857607ee025665dda61 [^]

Fixed BUG-44417: Round decimal places in the statistical value of the Intrastat

Correction.

---
M src/org/openbravo/module/intrastat/spain/ProcessAndGenerateIntrastat_Spain.java
---
(0122871)
hgbot   
2020-09-09 12:31   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/merge_requests/1 [^]
(0122872)
hgbot   
2020-09-09 12:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain [^]
Changeset: cc39e27d0d088027f355fe8503193c8b7bbe526a
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 2020-09-09T12:21:12+02:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/commit/cc39e27d0d088027f355fe8503193c8b7bbe526a [^]

Fixed BUG-44417: Simplified code

---
M src/org/openbravo/module/intrastat/spain/ProcessAndGenerateIntrastat_Spain.java
---