Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0044417
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Intrastat for Spainmajorhave not tried2020-06-18 17:562020-09-09 12:31
ReporterAlberto_SolaView Statuspublic 
Assigned ToMery Anelo 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0044417: 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.
TagsNo tags attached.
Attached Filesjpg file icon CapturaIntrastat.JPG [^] (27,095 bytes) 2020-06-18 17:56

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0121142)
psanjuan (manager)
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 (manager)
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 (developer)
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 (developer)
2020-08-27 03:07

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/merge_requests/1 [^]
(0122867)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2020-09-09 12:31

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.intrastat.spain/-/merge_requests/1 [^]
(0122872)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2020-06-18 17:56 Alberto_Sola New Issue
2020-06-18 17:56 Alberto_Sola Assigned To => Jorge Bravo
2020-06-18 17:56 Alberto_Sola File Added: CapturaIntrastat.JPG
2020-06-18 17:56 Alberto_Sola Issue Monitored: Alberto_Sola
2020-06-29 11:08 psanjuan Note Added: 0121141
2020-06-29 11:08 psanjuan Note Deleted: 0121141
2020-06-29 11:09 psanjuan Note Added: 0121142
2020-06-29 11:09 psanjuan Note Added: 0121143
2020-06-29 11:12 psanjuan Issue Monitored: psanjuan
2020-06-29 11:15 psanjuan Issue End Monitor: psanjuan
2020-07-20 16:10 Jorge Bravo Assigned To Jorge Bravo => Mery Anelo
2020-08-06 02:43 Mery Anelo Note Added: 0121866
2020-08-06 02:43 Mery Anelo Status new => scheduled
2020-08-21 14:59 vmromanos Project Localization Pack: Spain => Modules
2020-08-21 15:00 vmromanos Category Spain Professional Localization Pack => Intrastat for Spain
2020-08-27 03:07 hgbot Note Added: 0122364
2020-09-09 12:31 hgbot Resolution open => fixed
2020-09-09 12:31 hgbot Status scheduled => closed
2020-09-09 12:31 hgbot Note Added: 0122867
2020-09-09 12:31 hgbot Note Added: 0122868
2020-09-09 12:31 hgbot Note Added: 0122869
2020-09-09 12:31 hgbot Note Added: 0122870
2020-09-09 12:31 hgbot Note Added: 0122871
2020-09-09 12:31 hgbot Note Added: 0122872


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker