Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049508Localization Pack: SpainSIIpublic2022-06-08 09:582022-08-24 13:49
Reporterwicherr 
Assigned Tomgonzalezh 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
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
Summary0049508: when a product is "No declarable SII", the invoice belongs in error
DescriptionWhen a product has a tax category = "No declarable SII",
If an invoice contains this product,
When it is sent to SII,
The invoice belongs in error in the "SII Monitor"

Error from the SII : "La factura contiene lineas de impuesto que pertenecen a la categoría 'No declarable SII'."
Steps To Reproduce- Put the tax category of a product at "No declarable SII"
- Create a ticket on webPOS with this product and Invoice it
- In the backend, try to send the Invoice to SII
- The invoice belongs in error
Proposed SolutionThose invoices should not be sent so,
- They should not be present in SII monitor
- Or They should have a Status "right" with a comment or a specific status that make them "invisible" in the SII monitor

-> This modification should be done in the SII manual sending + background process
Additional Information
TagsNOR
Relationships
related to design defect 0048634 new psanjuan [Spain SII] Invoices including products having a mix of "Normal" and "Do not sent to SII" Tax categories are not sent to SII 
Attached Filespng Screenshot from 2022-06-27 15-13-43.png (181,735) 2022-06-28 09:32
https://issues.openbravo.com/file_download.php?file_id=17247&type=bug
png

png Screenshot from 2022-06-28 15-12-24.png (336,904) 2022-06-28 15:15
https://issues.openbravo.com/file_download.php?file_id=17254&type=bug
Issue History
Date ModifiedUsernameFieldChange
2022-06-08 09:58wicherrNew Issue
2022-06-08 09:58wicherrAssigned To => psanjuan
2022-06-08 10:09wicherrTag Attached: NOR
2022-06-13 12:36aferrazCategoryAEAT SII for Retail => SII
2022-06-16 10:09psanjuanAssigned Topsanjuan => Jorge Bravo
2022-06-22 12:53Jorge BravoAssigned ToJorge Bravo => psanjuan
2022-06-22 14:31rafarodaRelationship addedrelated to 0048634
2022-06-27 15:18psanjuanNote Added: 0138788
2022-06-27 15:20psanjuanNote Edited: 0138788bug_revision_view_page.php?bugnote_id=0138788#r24366
2022-06-28 09:26psanjuanAssigned Topsanjuan => Jorge Bravo
2022-06-28 09:26Jorge BravoAssigned ToJorge Bravo => mgonzalezh
2022-06-28 09:32psanjuanFile Added: Screenshot from 2022-06-27 15-13-43.png
2022-06-28 15:14psanjuanNote Edited: 0138788bug_revision_view_page.php?bugnote_id=0138788#r24385
2022-06-28 15:15psanjuanFile Added: Screenshot from 2022-06-28 15-12-24.png
2022-06-28 15:16psanjuanNote Edited: 0138788bug_revision_view_page.php?bugnote_id=0138788#r24386
2022-07-02 00:47hgbotNote Added: 0138966
2022-07-05 12:09rafarodaRelationship addedrelated to 0048984
2022-07-06 14:58psanjuanNote Added: 0139128
2022-07-06 15:01psanjuanNote Edited: 0139128bug_revision_view_page.php?bugnote_id=0139128#r24432
2022-07-06 15:03psanjuanNote Edited: 0139128bug_revision_view_page.php?bugnote_id=0139128#r24433
2022-07-06 15:06psanjuanNote Added: 0139129
2022-07-08 10:22psanjuanNote Deleted: 0139128
2022-07-08 10:23psanjuanNote Added: 0139182
2022-07-08 10:25psanjuanNote Edited: 0139182bug_revision_view_page.php?bugnote_id=0139182#r24454
2022-07-08 10:25psanjuanStatusnew => closed
2022-07-08 10:25psanjuanResolutionopen => no change required
2022-07-08 10:28hgbotNote Added: 0139183
2022-08-16 15:15psanjuanNote Deleted: 0139129
2022-08-16 15:16psanjuanRelationship deletedrelated to 0048984
2022-08-24 13:49psanjuanNote Added: 0140372
2022-08-24 13:54psanjuanNote Edited: 0140372bug_revision_view_page.php?bugnote_id=0140372#r24663
2022-08-24 14:01psanjuanNote Edited: 0140372bug_revision_view_page.php?bugnote_id=0140372#r24664
2022-08-24 15:05psanjuanNote Edited: 0140372bug_revision_view_page.php?bugnote_id=0140372#r24665

Notes
(0138788)
psanjuan   
2022-06-27 15:18   
(edited on: 2022-06-28 15:16)
Solución propuesta:

Las facturas que contienen líneas relacionadas con un impuesto ligado a una categoría de IVA marcada como "SII declarable = No", son tenidas en cuenta por el process background de SII "Grouped invoices SII sending process". Esto no se va a cambiar, dado que en un futuro podríamos tener facturas con líneas declarables/no declarables.

Lo que vamos a hacer por el momento es no mostrar en la ventana SII Monitor las facturas con esta información (ver imagen):
Sent to SII = NO
SII Registration Status - Sending error
SII error reason = La factura contiene lineas de impuesto que pertenecen a la categoría 'No declarable SII'.

Estas facturas no se deben mostrar en Monitor SII, incluso si el usuario quita el filtro por defecto. Por tanto esta lógica se tiene que incluir en la clausula Where HQL de la solapa.

Además, hay que tener en cuanta el registro más reciente de la sub-solapa "Issued Invoices SII Data".

Sólo aplica a facturas de venta o emitidas.

Ver imagenes.
(0138966)
hgbot   
2022-07-02 00:47   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/merge_requests/43 [^]
(0139182)
psanjuan   
2022-07-08 10:23   
(edited on: 2022-07-08 10:25)
Este MR no se incluye en el Módulo ya que no lo podemos considerar genérico. Se comparte MR con el cliente para que si lo necesita, y de forma controlada, se lo aplique.
Cerramos issue.
(0139183)
hgbot   
2022-07-08 10:28   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/merge_requests/43 [^]
(0140372)
psanjuan   
2022-08-24 13:49   
(edited on: 2022-08-24 15:05)
No tener en cuenta la solución propuesta anterior ya que esa solución se tiene que basar en tener de forma completa y total, la gestión y envio de facturas a SII con líneas declarables/NO declarables.

Se plantea al cliente el actualizar el estado de esas facturas a "Enviado" a SII, lo cual haría que ya no se muestren en SII Monitor.