Openbravo Issue Tracking System - Openbravo Localizations
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0046453Openbravo LocalizationsLocalization Italypublic2021-05-03 09:472022-03-28 11:23
Reporterpsanjuan 
Assigned Topsanjuan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Support ticket
OBNetwork customer
Regression introduced in release
Summary0046453: Electronic Invoice Italy - XML invoice to SDI
DescriptionElectronic Invoice Italy - XML invoice to SDI
Steps To Reproducen/a
Proposed SolutionElectronic Invoice for Italy needs to be implemented as described in the documentation below:

https://www.agenziaentrate.gov.it/portale/web/guest/specifiche-tecniche-versione-1.6.2 [^]

See Functional Specification:
https://docs.google.com/document/d/1Za1KJsTSxVrOjJBcAT7MG5nU1OEkHvpXM28SjDAD1Ws/edit# [^]
Additional Information
TagsNo tags attached.
Relationships
has duplicate feature request 0048468 closed psanjuan Openbravo Localizations [Italie] Facture XML SDI - Developpement 
related to feature request 0046170 acknowledged psanjuan Retail Modules RT Printer v 2.0 - XML 7 changes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-05-03 09:47psanjuanNew Issue
2021-05-03 09:47psanjuanAssigned To => psanjuan
2021-05-03 09:48psanjuanRelationship addedrelated to 0046170
2021-05-03 09:49psanjuanNote Added: 0127727
2021-05-03 09:50psanjuanNote Edited: 0127727bug_revision_view_page.php?bugnote_id=0127727#r22411
2022-01-20 12:00psanjuanProposed Solution updated
2022-01-24 07:09jetxarriRelationship addedhas duplicate 0048468
2022-01-24 07:11hgbotNote Added: 0134504
2022-02-16 13:35hgbotNote Added: 0135048
2022-03-03 15:26hgbotNote Added: 0135434
2022-03-07 12:30hgbotNote Added: 0135496
2022-03-10 19:18hgbotResolutionopen => fixed
2022-03-10 19:18hgbotStatusnew => resolved
2022-03-10 19:18hgbotNote Added: 0135633
2022-03-10 19:18hgbotNote Added: 0135634
2022-03-10 19:21hgbotNote Added: 0135635
2022-03-10 19:21hgbotNote Added: 0135636
2022-03-11 14:16hgbotStatusresolved => closed
2022-03-11 14:16hgbotFixed in Version => PR22Q2
2022-03-11 14:16hgbotNote Added: 0135660
2022-03-11 14:16hgbotNote Added: 0135661
2022-03-11 14:18hgbotNote Added: 0135662
2022-03-11 14:18hgbotNote Added: 0135663
2022-03-14 08:30hgbotNote Added: 0135667
2022-03-28 11:23vmromanosNote Added: 0136089

Notes
(0127727)
psanjuan   
2021-05-03 09:49   
(edited on: 2021-05-03 09:50)
The specification of the all tags of the XML are in this URL :

https://www.agenziaentrate.gov.it/portale/documents/20143/2931841/Table+view+B2B+Ordinary+invoice.xls/53388c61-951e-089a-1771-7ebd0ed662f4 [^]


All the specification and all cases are in this URL:

https://www.agenziaentrate.gov.it/portale/documents/20143/2931841/Appendix+A+-+Technical+Specifications+vers+1.6.2.pdf/e1deef1c-b3dd-1f7f-b275-078f29555eea [^]

An example of an easy XML:

https://www.agenziaentrate.gov.it/portale/documents/20143/288192/ST+Fatturazione+elettronica+-+ITHVQWPH73P42H501Y_00023_ITHVQWPH73P42H501Y_00023.xml/418a88d2-0d03-91f5-de5d-febae1ce829e [^]

An useful service to test the XML is in this URL

https://www.fatturacheck.it/ [^]
(0134504)
hgbot   
2022-01-24 07:11   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/merge_requests/1 [^]
(0135048)
hgbot   
2022-02-16 13:35   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/528 [^]
(0135434)
hgbot   
2022-03-03 15:26   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/8 [^]
(0135496)
hgbot   
2022-03-07 12:30   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/4 [^]
(0135633)
hgbot   
2022-03-10 19:18   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: 9c617651ff8197b6dd4390930ff253a3f16b9a3f
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 10-03-2022 19:10:24
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/9c617651ff8197b6dd4390930ff253a3f16b9a3f [^]

Fixed ISSUE-46453: Invoice API

---
M examples/Openbravo API.postman_collection.json
M src-db/database/sourcedata/API_EXPORT_FILTER.xml
M src-db/database/sourcedata/API_EXPORT_FILTER_PARAM.xml
M src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0135634)
hgbot   
2022-03-10 19:18   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/8 [^]
(0135635)
hgbot   
2022-03-10 19:21   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: c5d997a1f5a3ff93974bf00e1288df533c9c8b97
Author: Martí Queralt <marti.queralt@openbravo.com>
Date: 10-03-2022 18:21:14
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/c5d997a1f5a3ff93974bf00e1288df533c9c8b97 [^]

Fixed ISSUE-46453: Automatic tests for Invoice export

---
A src-test/data/export/filter/invoice/ByDocumentNo.json
A src-test/data/export/filter/invoice/ById.json
A src-test/data/export/filter/invoice/ByInvoiceDate.json
A src-test/data/export/filter/invoice/ByInvoiceDateRange.json
A src-test/org/openbravo/api/tests/export/ApiExportInvoiceFilters.java
M src-test/org/openbravo/api/tests/StandaloneTestSuite.java
M src-test/org/openbravo/api/tests/util/ApiTestConstants.java
---
(0135636)
hgbot   
2022-03-10 19:21   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/4 [^]
(0135660)
hgbot   
2022-03-11 14:16   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: fb0e1910505fb5b5e83921d1f43a79df174425fa
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 10-03-2022 14:59:06
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/fb0e1910505fb5b5e83921d1f43a79df174425fa [^]

Fixed FR-46453: Added e-invoice fields to Sales Invoice

This fields will only be shown when filled.
Filling them is a responsibility of a third party.

---
M src-db/database/model/tables/C_INVOICE.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_FIELDGROUP.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
---
(0135661)
hgbot   
2022-03-11 14:16   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/528 [^]
(0135662)
hgbot   
2022-03-11 14:18   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice [^]
Changeset: c37daedb744cb988739991a59f3a824821a26177
Author: Javier Etxarri <javier.echarri@openbravo.com>
Date: 24-01-2022 07:10:35
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/commit/c37daedb744cb988739991a59f3a824821a26177 [^]

ISSUE-46453: Starting the module development

---
---
(0135663)
hgbot   
2022-03-11 14:18   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/merge_requests/1 [^]
(0135667)
hgbot   
2022-03-14 08:30   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: c7ccce8574c05e5633a978c53872e715c7ea2645
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 14-03-2022 08:30:41
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/c7ccce8574c05e5633a978c53872e715c7ea2645 [^]

Related to ISSUE-46453: fixed db-cons

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0136089)
vmromanos   
2022-03-28 11:23   
Performance testing export invoice: https://docs.google.com/spreadsheets/d/1Nyc9h6caQZqB_-g0K5QXyzX3GMnp1LfoE7BEOO38XDA/ [^]