Openbravo Issue Tracking System - Openbravo Localizations
View Issue Details
0050262Openbravo LocalizationsLocalization Italypublic2022-09-16 01:422022-10-26 09:49
rtoledano 
jetxarri 
normalmajoralways
closedfixed 
5
 
 
0050262: Electronic Invoice Italy - Natura XML tag is missing when tax exempt is present
This is the SPEC: https://docs.google.com/document/d/1Za1KJsTSxVrOjJBcAT7MG5nU1OEkHvpXM28SjDAD1Ws/edit# [^]

See related points 2.2.1.12 2.2.1.14, 2.2.2.1 and 2.2.2.2

Posible values for tag Natura: N1, N2.1, N2.2, N3.1, N3.2, N3.3, N3.4, N3.5, N3.6, N4, N5, N6.1, N6.2, N6.3, N6.4, N6.5, N6.6, N6.7, N6.8, N6.9, N7
Go to https://www.fatturacheck.it [^]
and upload file attached "tax_excempt_client.xml" you will see
the validation error: "Natura non presente a fronte di una Aliquota IVA pari a 0".
As part of e-invoice module for Italy, it is required to create a new "field" named "Fiscal Natura" in the Tax Rate window (C_Tax).

This field needs to be included in the module "Italy Master Data", therefore e-invoice module needs to depend on it.

This field needs to include below list of values:
N1
N2.1
N2.2
N3.1
N3.2
N3.3
N3.4
N3.5
N3.6
N4
N5
N6.1
N6.2
N6.3
N6.4
N6.5
N6.6
N6.7
N6.8
N6.9
N7


(N2, N3 and N6 (values no longer permitted)

This new field will only be displayed if the tax rate is configured as Tax Exempt = Yes. This field will not be mandatory.

The value configured in this field for an invoice including an exempt tax rate, will be the one to send in the position 2.2.1.14 and 2.2.2.2 in the e-invoice module.

If this value is not filled in, when an e-invoice needs to be created for an invoice containing an exempt tax rate, an error message will be send to the end-user, so he/she can properly configure it for the exempt tax rate, prior e-invoice generation.
No tags attached.
related to design defect 0050460 new psanjuan Wrong dependencies in the RT-Server / RT- Printer and e-invoice 
related to defect 0050636 closed jetxarri "Fiscal Natura" reference list needs to be enhaced therefore the corresponding code is included 
blocks defect 0050641 closed jetxarri A translation module is needed for the module Italy Master Data 
xml tax exempt client.xml (3,134) 2022-09-16 01:42
https://issues.openbravo.com/file_download.php?file_id=17521&type=bug
Issue History
2022-09-16 01:42rtoledanoNew Issue
2022-09-16 01:42rtoledanoAssigned To => aferraz
2022-09-16 01:42rtoledanoFile Added: tax exempt client.xml
2022-09-16 01:55rtoledanoDescription Updatedbug_revision_view_page.php?rev_id=24772#r24772
2022-09-16 08:38aferrazAssigned Toaferraz => Triage Omni OMS
2022-09-23 14:17psanjuanProposed Solution updated
2022-09-23 14:19psanjuanProposed Solution updated
2022-09-23 14:33psanjuanProposed Solution updated
2022-09-23 15:08aferrazAssigned ToTriage Omni OMS => rqueralta
2022-09-26 10:04psanjuanProposed Solution updated
2022-09-26 10:07psanjuanProposed Solution updated
2022-10-04 05:49hgbotNote Added: 0141611
2022-10-05 16:19sebastien_lironAssigned Torqueralta => aferraz
2022-10-06 09:21psanjuanNote Added: 0141716
2022-10-10 09:34psanjuanProposed Solution updated
2022-10-10 09:40psanjuanProposed Solution updated
2022-10-10 09:57psanjuanNote Added: 0141881
2022-10-10 10:19psanjuanRelationship addedrelated to 0050460
2022-10-10 12:54hgbotNote Added: 0141901
2022-10-10 12:58aferrazAssigned Toaferraz => jetxarri
2022-10-10 14:19hgbotNote Added: 0141913
2022-10-10 14:31hgbotNote Added: 0141914
2022-10-10 14:59hgbotNote Added: 0141916
2022-10-10 16:30hgbotResolutionopen => fixed
2022-10-10 16:30hgbotStatusnew => closed
2022-10-10 16:30hgbotNote Added: 0141922
2022-10-10 16:30hgbotNote Added: 0141923
2022-10-10 16:31hgbotNote Added: 0141924
2022-10-10 16:31hgbotNote Added: 0141925
2022-10-10 16:32hgbotNote Added: 0141926
2022-10-10 16:32hgbotNote Added: 0141927
2022-10-26 09:49psanjuanRelationship addedrelated to 0050636
2022-10-26 09:51psanjuanRelationship addedblocks 0050641

Notes
(0141611)
hgbot   
2022-10-04 05:49   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/merge_requests/11 [^]
(0141716)
psanjuan   
2022-10-06 09:21   
This issue is currently on hold because dependencies between rt-printer, rt-server and e-invoicing modules for Italy are being analyzed.
it could be that fields such as this one Natura are included in an existing data set for Italy.
(0141881)
psanjuan   
2022-10-10 09:57   
Fix this issue as described above as a new field of the Italian Master Data module. For more details see:
https://docs.google.com/document/d/1Za1KJsTSxVrOjJBcAT7MG5nU1OEkHvpXM28SjDAD1Ws/edit# [^]
sections 2.2.2.1, 2.2.2.2 and 2.2.2.12, 2.2.2.2.14
(0141901)
hgbot   
2022-10-10 12:54   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.masterdata/-/merge_requests/2 [^]
(0141913)
hgbot   
2022-10-10 14:19   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/merge_requests/12 [^]
(0141914)
hgbot   
2022-10-10 14:31   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/merge_requests/11 [^]
(0141916)
hgbot   
2022-10-10 14:59   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.masterdata.api/-/merge_requests/2 [^]
(0141922)
hgbot   
2022-10-10 16:30   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.masterdata [^]
Changeset: 8f4c93a272f310449c37e4cc292649f354b977d9
Author: Javier Etxarri <javier.etxarri@openbravo.com>
Date: 10-10-2022 12:54:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.masterdata/-/commit/8f4c93a272f310449c37e4cc292649f354b977d9 [^]

Fixed ISSUE-50262: Added a new field Fiscal Natura in c_tax table

---
A src-db/database/model/modifiedTables/C_TAX.xml
A src-db/database/sourcedata/AD_REFERENCE.xml
A src-db/database/sourcedata/AD_REF_LIST.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
---
(0141923)
hgbot   
2022-10-10 16:30   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.masterdata/-/merge_requests/2 [^]
(0141924)
hgbot   
2022-10-10 16:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.masterdata.api [^]
Changeset: 1e706aa0ffd8f8c17f1433629bca3b635dd23907
Author: Javier Etxarri <javier.etxarri@openbravo.com>
Date: 10-10-2022 14:56:02
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.masterdata.api/-/commit/1e706aa0ffd8f8c17f1433629bca3b635dd23907 [^]

Fixed ISSUE-50262: Move to this module natura fiscal code

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0141925)
hgbot   
2022-10-10 16:31   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.masterdata.api/-/merge_requests/2 [^]
(0141926)
hgbot   
2022-10-10 16:32   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice [^]
Changeset: 526b4e296d4c123c0e7891cd3d53f793cb4cde7c
Author: Javier <javieretxarri@ekinbe.com>
Date: 10-10-2022 14:32:01
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/commit/526b4e296d4c123c0e7891cd3d53f793cb4cde7c [^]

Fixed ISSUE-50262: Added Natura XML tag when tax exempt is present

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
M src-test/org/openbravo/localization/italy/einvoice/TestItalyXMLCreationFromJson.java
M src/org/openbravo/localization/italy/einvoice/xmlengine/document/ItalyDatiRiepilogo.java
M src/org/openbravo/localization/italy/einvoice/xmlengine/document/ItalyDettaglioLinee.java
---
(0141927)
hgbot   
2022-10-10 16:32   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.localization.italy.einvoice/-/merge_requests/12 [^]