Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040851Localization Pack: SpainSIIpublic2019-05-13 09:402020-06-05 14:06
Reporteretarajano 
Assigned ToMery Anelo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
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
Summary0040851: SII Invoices Query - Inaccurate data
DescriptionThe information displayed in the window "SII Invoices Query" is not accurate.

In the source code, when matching Openbravo invoices to SII invoices, the query to get the Openbravo invoices does not filter by "In SII system date" configuration parameter, which could lead to retrieve invoices from previous years that match the criteria but are not relevant to the SII.

If data is not congruent and the same purchase order reference is used in more than one invoice/business partner (even though it shouldn't happen, there is no OOTB constraint about it) the window will display fewer invoices found in Openbravo.

Adding a new restriction to the query regarding the "In SII system date" would be desirable and more performant.
Steps To Reproduce- Log in the application.
- Find a random invoice from a date before the "In SII system date" and copy the business partner / poreference.
- Create a new invoice with the same business partner / poreference.
- Send the invoice to the SII.
- Retrieve the sent invoices for that period from the "SII Invoices Query" window.
- The newly created invoice won't be found in Openbravo because the application considers it as "not unique".
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-05-13 09:40etarajanoNew Issue
2019-05-13 09:40etarajanoAssigned To => Opentix-Test
2020-04-23 18:02psanjuanAssigned ToOpentix-Test => Mery Anelo
2020-05-29 07:16Mery AneloNote Added: 0120436
2020-05-29 07:16Mery AneloStatusnew => scheduled
2020-06-03 23:28hgbotCheckin
2020-06-03 23:28hgbotNote Added: 0120632
2020-06-03 23:28hgbotStatusscheduled => resolved
2020-06-03 23:28hgbotResolutionopen => fixed
2020-06-03 23:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.sii/rev/71804dfc6fdcb2c067780a68de2462b83a703c15 [^]
2020-06-05 14:06Jorge BravoStatusresolved => closed

Notes
(0120436)
Mery Anelo   
2020-05-29 07:16   
Test plan:
- Log in the application.
- Find a random invoice from a date before the "In SII system date" and copy the business partner / poreference.
- Create a new invoice with the same business partner / poreference.
- Send the invoice to the SII.
- Retrieve the sent invoices for that period from the "SII Invoices Query" window.
- Openbravo must find the created invoices, being a unique record when comparing the invoice date as well.
(0120632)
hgbot   
2020-06-03 23:28   
Repository: erp/pmods/org.openbravo.module.sii
Changeset: 71804dfc6fdcb2c067780a68de2462b83a703c15
Author: Mery Anelo <mery.anelo <at> smfconsulting.es>
Date: Wed Jun 03 18:27:30 2020 -0300
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.sii/rev/71804dfc6fdcb2c067780a68de2462b83a703c15 [^]

Fixed bug 40851: obtain unique information on the invoices sent to the SII

Restricts invoices based on "Supplier reference" and "Invoice date", both of which are mandatory for the SII.

---
M src/org/openbravo/module/sii/process/ConsultaFactura.java
---