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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0047861
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] AEAT 303minoralways2021-10-15 12:292021-11-15 17:37
ReporterpsanjuanView Statuspublic 
Assigned Tojuabaez 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version7.x
OS VersionOpenbravo Appliance 14.04Database version9.3.xAnt version1.9.x
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0047861: SWIFT info is not required in 303 declaration "A Ingresar" of any type.

DescriptionSWIFT info is not required in 303 declaration "A Ingresar" of any type.
Steps To ReproduceFor 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 SolutionData 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.
TagsNo tags attached.
Attached Filestxt file icon IngresoSwift.txt [^] (2,889 bytes) 2021-10-15 12:29 [Show Content]
png file icon issue47861.png [^] (193,001 bytes) 2021-10-15 12:40


txt file icon Septiembre01.txt [^] (2,889 bytes) 2021-10-15 12:42 [Show Content]
txt file icon Ingreso01B.txt [^] (2,889 bytes) 2021-10-29 14:47 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0047934 closedjuabaez Changes required in the parameters shown for the 303 Tax Report in the Tax Report Launcher window. 

-  Notes
(0132680)
Jorge Bravo (developer)
2021-10-27 11:58

 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".
(0132754)
psanjuan (manager)
2021-10-29 10:40

 SWIFT-BIC is only required if the IBAN is not an Spanish one.
(0132765)
psanjuan (manager)
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 (developer)
2021-10-29 15:08

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat303.es/-/merge_requests/14 [^]
(0133081)
hgbot (developer)
2021-11-15 17:37

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat303.es [^]
Changeset: ded5f0ed296c4d3ea8876d5d992c3c34d5c18895
Author: Juan Baez <juan.baez@smfconsulting.es>
Date: 2021-11-15T16:37:50+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat303.es/-/commit/ded5f0ed296c4d3ea8876d5d992c3c34d5c18895 [^]

Fixed ISSUE-47861 remove SWIFT depends on type of declaration

If type of declaration not is return or not is return for tributary account then set blank swift parameter.
Remove swift when iban is from spain or sepa is 1

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/aeat303/es/report/v2021/AEAT303Report2021.java
---
(0133082)
hgbot (developer)
2021-11-15 17:37

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat303.es/-/merge_requests/14 [^]

- 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 View Revisions
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 View Revisions
2021-10-15 12:43 psanjuan Steps to Reproduce Updated View Revisions
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 View Revisions
2021-10-29 14:53 psanjuan Note Edited: 0132765 View Revisions
2021-10-29 14:57 psanjuan Note Edited: 0132765 View Revisions
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker