Openbravo Issue Tracking System - Localization Pack: Spain |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0047861 | Localization Pack: Spain | AEAT 303 | public | 2021-10-15 12:29 | 2021-11-15 17:37 |
|
| Reporter | psanjuan | |
| Assigned To | juabaez | |
| Priority | urgent | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | Openbravo Appliance 14.04 |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | |
| Support ticket | |
| OBNetwork customer | |
| Regression introduced in release | |
|
| Summary | 0047861: SWIFT info is not required in 303 declaration "A Ingresar" of any type. |
| Description | SWIFT info is not required in 303 declaration "A Ingresar" of any type. |
| Steps To Reproduce | For a given period book a sales invoice for an amount of 2000.00 € for instance with its corresponding VAT amount (21% VAT Rate)
Book also a purchase invoice for an amount of 100.00 € for instance, with its corresponding VAT amount (21% VAT Rate)
The result of this declaration will be positive (A ingresar) as it will be 2.000-100.00 = 1.100.00
Launch the 303 monthly report for that perido (ie. September). Select the option "A ingresar" and enter IBAN info and SWIFT info.
Upload the file in the corresponding Tax Agency web: https://www7.aeat.es/wlpl/BUGC-JDIT/VentanaCensalIva?forigen=file303 [^]
Realize that the error shown below is shown.
Create now another Purchase Invoice with VAT, for the same period and for a quantity of 5000.00 € for instance.
That means that the result of the 303 tax form will be negative (A devolver).
as it will be 2.000-5100.00 = -3.100.00
Launch 303 Tax Report by including IBAN and SWIFT info together with rest of date required for "Declaraciones a Devolver". See file "Septiembre01".
Verify that once uploaded, no error message is shown.
This issue can also be reproduced if the customer has SWIFT data configured as "Constant" input in the Tax Report definition window. As already mentioned before, SWIFT info is also taken from there for 303 tax forms "A devolver" (negative ones).
Try to import the file attached, which include SWIFT info in a "A Ingresar" 303 tax form. Once uploaded an error is shown. See also image attached. |
| Proposed Solution | Data below, either as input or constant must only be taken into account in "negative" 303 declarations, that means, whenever the end-user selects the parameters "Devolución" and "Devolución Cuenta Tributaria"
* SWIFT-BIC
* Banco
* Dirección del Banco
* Ciudad del banco
* Código ISO (dos posiciones) del país
* Marca SEPA
Positive ones (A ingresar) can only include IBAN information. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | feature request | 0047934 | | closed | juabaez | Changes required in the parameters shown for the 303 Tax Report in the Tax Report Launcher window. |
|
| Attached Files |  IngresoSwift.txt (2,889) 2021-10-15 12:29
https://issues.openbravo.com/file_download.php?file_id=16268&type=bug
 issue47861.png (193,001) 2021-10-15 12:40
https://issues.openbravo.com/file_download.php?file_id=16269&type=bug
Septiembre01.txt (2,889) 2021-10-15 12:42
https://issues.openbravo.com/file_download.php?file_id=16270&type=bug
Ingreso01B.txt (2,889) 2021-10-29 14:47
https://issues.openbravo.com/file_download.php?file_id=16319&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2021-10-15 12:29 | psanjuan | New Issue | |
| 2021-10-15 12:29 | psanjuan | Assigned To | => Jorge Bravo |
| 2021-10-15 12:29 | psanjuan | File Added: IngresoSwift.txt | |
| 2021-10-15 12:40 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=23188#r23188 |
| 2021-10-15 12:40 | psanjuan | Proposed Solution updated | |
| 2021-10-15 12:40 | psanjuan | File Added: issue47861.png | |
| 2021-10-15 12:42 | psanjuan | File Added: Septiembre01.txt | |
| 2021-10-15 12:43 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=23189#r23189 |
| 2021-10-15 12:43 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=23190#r23190 |
| 2021-10-15 12:53 | Practics | Issue Monitored: Practics | |
| 2021-10-19 14:41 | Jorge Bravo | Assigned To | Jorge Bravo => juabaez |
| 2021-10-19 15:59 | psanjuan | Proposed Solution updated | |
| 2021-10-25 16:44 | juabaez | Status | new => scheduled |
| 2021-10-26 12:57 | psanjuan | Proposed Solution updated | |
| 2021-10-26 13:02 | psanjuan | Relationship added | related to 0047934 |
| 2021-10-27 11:58 | Jorge Bravo | Note Added: 0132680 | |
| 2021-10-29 10:40 | psanjuan | Note Added: 0132754 | |
| 2021-10-29 14:47 | psanjuan | Note Added: 0132765 | |
| 2021-10-29 14:47 | psanjuan | File Added: Ingreso01B.txt | |
| 2021-10-29 14:49 | psanjuan | Note Edited: 0132765 | bug_revision_view_page.php?bugnote_id=0132765#r23257 |
| 2021-10-29 14:53 | psanjuan | Note Edited: 0132765 | bug_revision_view_page.php?bugnote_id=0132765#r23258 |
| 2021-10-29 14:57 | psanjuan | Note Edited: 0132765 | bug_revision_view_page.php?bugnote_id=0132765#r23259 |
| 2021-10-29 15:08 | hgbot | Note Added: 0132766 | |
| 2021-11-15 17:37 | hgbot | Resolution | open => fixed |
| 2021-11-15 17:37 | hgbot | Status | scheduled => closed |
| 2021-11-15 17:37 | hgbot | Note Added: 0133081 | |
| 2021-11-15 17:37 | hgbot | Note Added: 0133082 | |
|
Notes |
|
|
|
TEST PLAN:
Se ha realizado pruebas con diferentes tipos de declaración (Compensación, Devolución, Ingreso y Resultado Cero) siendo todas positivas y recogiendo de forma correcta la AEAT la información enviada.
Todas las pruebas se han realizado introduciendo manualmente la información de la sección Banco, dentro de "Párametros de entrada". También, se ha probado a configurar dicha información como "Constante" dentro de la ventana Declaración de impuestos". |
|
|
|
|
|
SWIFT-BIC is only required if the IBAN is not an Spanish one. |
|
|
|
(0132765)
|
|
psanjuan
|
2021-10-29 14:47
(edited on: 2021-10-29 14:57) |
|
Test case 2
For a given period book a sales invoice for an amount of 2000.00 € for instance with its corresponding VAT amount (21% VAT Rate)
Book also a purchase invoice for an amount of 100.00 € for instance, with its corresponding VAT amount (21% VAT Rate)
The result of this declaration will be positive (A ingresar) as it will be 2.000-100.00 = 1.100.00
Launch the 303 monthly report for that perido (ie. September). Select the option "A ingresar" and enter IBAN info and SWIFT info.
Upload the file in the corresponding Tax Agency web: https://www7.aeat.es/wlpl/BUGC-JDIT/VentanaCensalIva?forigen=file303 [^] [^]
Realize that no error is shown.
See file "Ingreso01B.txt"
Repeat the same test case by selecting the parameters: Ingreso domiciliación bancaria, Ingreso CC tributaria.
Test case 2
Repeat the same scenario for a negative declaration by selecting any of the options "Devolución" or "Devolución CCTributaria"
Enter all Banco data including the SWIFT, including an Spanish IBAN and value 1 for SEPA.
No error is shown but the parameter "Solicitud de devolución en cuenta abierta en el extranjero" is selected in the AEAT web, after uploading the file, and going to the section "Formalizar Ingreso/Devolución".
SWIFT must not be entered for ES "IBAN"
Enter all Banco data but SWIFT
No error is shown, and the option selected in the section "Formalizar Ingreso/Devolución" is the correct one. "Solicitud de devolución en una cuenta abierta en España".
|
|
|
|
(0132766)
|
|
hgbot
|
|
2021-10-29 15:08
|
|
|
|
|
(0133081)
|
|
hgbot
|
|
2021-11-15 17:37
|
|
|
|
|
(0133082)
|
|
hgbot
|
|
2021-11-15 17:37
|
|
|