Openbravo Issue Tracking System - Openbravo Localizations
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052919Openbravo LocalizationsLocalization Portugalpublic2023-07-04 12:002023-07-27 14:11
Reporterpsanjuan 
Assigned Tojonae 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
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
Summary0052919: Tax Exemption reason M11 is not being included in the e-fatura file regardless it is used in a sales transaction
DescriptionTax Exemption reason M11 is not being included in the e-fatura file regardless it is used in a sales transaction
Steps To ReproduceIn this terminal https://portugal-certification-19q3.rm.openbravo.com/openbravo/web/org.openbravo.retail.posterminal/?terminal=VBS-1#login [^]
create a new sales, including the product "Test Producto Isento 2"
Go to the OB backoffice and launch the e-fatura file for the date of the transaction.

Verify that in the XML file, there is no information related to the exempt reason
<SalesInvoices>
<NumberOfEntries>1</NumberOfEntries>
<TotalDebit>0</TotalDebit>
<TotalCredit>10.00</TotalCredit>
<Invoice>
<InvoiceNo>FS 23FSA/00008</InvoiceNo>
<ATCUD>23FSAVC-00008</ATCUD>
<DocumentStatus>
<InvoiceStatus>N</InvoiceStatus>
<InvoiceStatusDate>2023-07-04T15:46:05</InvoiceStatusDate>
<SourceID>Openbravo</SourceID>
<SourceBilling>P</SourceBilling>
</DocumentStatus>
<Hash>ox8sku9fHG4BxYz+7LglIlQwpQrguQkE+IW7+WymdSVvut5lKkg0Bx+4Gl0x/HgUv7O/k3X4YjcTmXReEBkoK7FhK+fJCMmDL6GGPIMWKRZov+4JDD4Ghy31/KXiz7QwLlaku9N891lyHs6bjSkClTltHcNqf/ggkaaG/KYtez4=</Hash>
<HashControl>1</HashControl>
<InvoiceDate>2023-07-04</InvoiceDate>
<InvoiceType>FS</InvoiceType>
<SpecialRegimes>
<SelfBillingIndicator>0</SelfBillingIndicator>
<CashVATSchemeIndicator>0</CashVATSchemeIndicator>
<ThirdPartiesBillingIndicator>0</ThirdPartiesBillingIndicator>
</SpecialRegimes>
<SourceID>Openbravo</SourceID>
<SystemEntryDate>2023-07-04T15:46:05</SystemEntryDate>
<CustomerID>T019/C0001</CustomerID>
<Line>
<LineNumber>1</LineNumber>
<OrderReferences>
<OriginatingON>OV 23FSA/00008</OriginatingON>
<OrderDate>2023-07-04</OrderDate>
</OrderReferences>
<ProductCode>T2</ProductCode>
<ProductDescription>T2 - Test Producto Isento 2 </ProductDescription>
<Quantity>1</Quantity>
<UnitOfMeasure>Unit</UnitOfMeasure>
<UnitPrice>10</UnitPrice>
<TaxPointDate>2023-07-04</TaxPointDate>
<Description>T2 - Test Producto Isento 2</Description>
<CreditAmount>10.000</CreditAmount>
<Tax>
<TaxType>IVA</TaxType>
<TaxCountryRegion>PT</TaxCountryRegion>
<TaxCode>ISE</TaxCode>
<TaxPercentage>0</TaxPercentage>
</Tax>
</Line>

Make now a sale for the product "Test Product Isento", launch the XML file and verify that the tax exempt information is there:
Invoice>
<InvoiceNo>FS 23FSA/00009</InvoiceNo>
<ATCUD>23FSAVC-00009</ATCUD>
<DocumentStatus>
<InvoiceStatus>N</InvoiceStatus>
<InvoiceStatusDate>2023-07-04T15:50:26</InvoiceStatusDate>
<SourceID>Openbravo</SourceID>
<SourceBilling>P</SourceBilling>
</DocumentStatus>
<Hash>vZBVci/x1thmb/amoLZEwQPGlusWacwZCzLO8Ep67EiQhupQXY5MnksKEibjilWY++Wne9LQaYX7byEDCmtcU/KOwmuAVnAihptE/vxXjTHXeryd0cuNaCvph6rTwjxK+B4vlKp7D6MOYNlKVbPIkmn1Yn5+wA8cX8lYZEJj8yw=</Hash>
<HashControl>1</HashControl>
<InvoiceDate>2023-07-04</InvoiceDate>
<InvoiceType>FS</InvoiceType>
<SpecialRegimes>
<SelfBillingIndicator>0</SelfBillingIndicator>
<CashVATSchemeIndicator>0</CashVATSchemeIndicator>
<ThirdPartiesBillingIndicator>0</ThirdPartiesBillingIndicator>
</SpecialRegimes>
<SourceID>Openbravo</SourceID>
<SystemEntryDate>2023-07-04T15:50:26</SystemEntryDate>
<CustomerID>T019/C0001</CustomerID>
<Line>
<LineNumber>1</LineNumber>
<OrderReferences>
<OriginatingON>OV 23FSA/00009</OriginatingON>
<OrderDate>2023-07-04</OrderDate>
</OrderReferences>
<ProductCode>T1</ProductCode>
<ProductDescription>T1 - Test Produto Isento</ProductDescription>
<Quantity>1</Quantity>
<UnitOfMeasure>Unit</UnitOfMeasure>
<UnitPrice>10</UnitPrice>
<TaxPointDate>2023-07-04</TaxPointDate>
<Description>T1 - Test Produto Isento</Description>
<CreditAmount>10.000</CreditAmount>
<Tax>
<TaxType>IVA</TaxType>
<TaxCountryRegion>PT</TaxCountryRegion>
<TaxCode>ISE</TaxCode>
<TaxPercentage>0</TaxPercentage>
</Tax>
Invoice>
<InvoiceNo>FS 23FSA/00009</InvoiceNo>
<ATCUD>23FSAVC-00009</ATCUD>
<DocumentStatus>
<InvoiceStatus>N</InvoiceStatus>
<InvoiceStatusDate>2023-07-04T15:50:26</InvoiceStatusDate>
<SourceID>Openbravo</SourceID>
<SourceBilling>P</SourceBilling>
</DocumentStatus>
<Hash>vZBVci/x1thmb/amoLZEwQPGlusWacwZCzLO8Ep67EiQhupQXY5MnksKEibjilWY++Wne9LQaYX7byEDCmtcU/KOwmuAVnAihptE/vxXjTHXeryd0cuNaCvph6rTwjxK+B4vlKp7D6MOYNlKVbPIkmn1Yn5+wA8cX8lYZEJj8yw=</Hash>
<HashControl>1</HashControl>
<InvoiceDate>2023-07-04</InvoiceDate>
<InvoiceType>FS</InvoiceType>
<SpecialRegimes>
<SelfBillingIndicator>0</SelfBillingIndicator>
<CashVATSchemeIndicator>0</CashVATSchemeIndicator>
<ThirdPartiesBillingIndicator>0</ThirdPartiesBillingIndicator>
</SpecialRegimes>
<SourceID>Openbravo</SourceID>
<SystemEntryDate>2023-07-04T15:50:26</SystemEntryDate>
<CustomerID>T019/C0001</CustomerID>
<Line>
<LineNumber>1</LineNumber>
<OrderReferences>
<OriginatingON>OV 23FSA/00009</OriginatingON>
<OrderDate>2023-07-04</OrderDate>
</OrderReferences>
<ProductCode>T1</ProductCode>
<ProductDescription>T1 - Test Produto Isento</ProductDescription>
<Quantity>1</Quantity>
<UnitOfMeasure>Unit</UnitOfMeasure>
<UnitPrice>10</UnitPrice>
<TaxPointDate>2023-07-04</TaxPointDate>
<Description>T1 - Test Produto Isento</Description>
<CreditAmount>10.000</CreditAmount>
<Tax>
<TaxType>IVA</TaxType>
<TaxCountryRegion>PT</TaxCountryRegion>
<TaxCode>ISE</TaxCode>
<TaxPercentage>0</TaxPercentage>
</Tax>
<TaxExemptionReason>Artigo 9º do CIVA, nº27</TaxExemptionReason>
<TaxExemptionCode>M07</TaxExemptionCode>
Proposed SolutionBelow listed nodes need to be included, for each tax rate with an exempt reason:
<TaxExemptionReason>Artigo 9º do CIVA, nº27</TaxExemptionReason>
<TaxExemptionCode>M07</TaxExemptionCode>
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Screenshot from 2023-07-04 15-52-13.png (148,961) 2023-07-04 15:53
https://issues.openbravo.com/file_download.php?file_id=18723&type=bug
png

png Screenshot from 2023-07-04 15-52-23.png (149,443) 2023-07-04 15:53
https://issues.openbravo.com/file_download.php?file_id=18724&type=bug
png

png Screenshot from 2023-07-04 15-52-58.png (105,706) 2023-07-04 15:53
https://issues.openbravo.com/file_download.php?file_id=18725&type=bug
png

png Captura de pantalla 2023-07-27 a las 14.02.01.png (269,788) 2023-07-27 14:10
https://issues.openbravo.com/file_download.php?file_id=18810&type=bug
png Captura de pantalla 2023-07-27 a las 14.02.06.png (5,303) 2023-07-27 14:10
https://issues.openbravo.com/file_download.php?file_id=18811&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2023-07-04 12:00psanjuanNew Issue
2023-07-04 12:00psanjuanAssigned To => psanjuan
2023-07-04 15:49psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=26403#r26403
2023-07-04 15:49psanjuanProposed Solution updated
2023-07-04 15:51psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=26404#r26404
2023-07-04 15:53psanjuanFile Added: Screenshot from 2023-07-04 15-52-13.png
2023-07-04 15:53psanjuanFile Added: Screenshot from 2023-07-04 15-52-23.png
2023-07-04 15:53psanjuanFile Added: Screenshot from 2023-07-04 15-52-58.png
2023-07-04 15:54psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=26405#r26405
2023-07-04 15:54psanjuanProposed Solution updated
2023-07-04 15:54psanjuanAssigned Topsanjuan => jonae
2023-07-27 14:09jonaeNote Added: 0152942
2023-07-27 14:10jonaeFile Added: Captura de pantalla 2023-07-27 a las 14.02.01.png
2023-07-27 14:10jonaeFile Added: Captura de pantalla 2023-07-27 a las 14.02.06.png
2023-07-27 14:11jonaeNote Added: 0152943
2023-07-27 14:11jonaeStatusnew => closed
2023-07-27 14:11jonaeResolutionopen => no change required

Notes
(0152942)
jonae   
2023-07-27 14:09   
I think this is not an issue. There is a validation in code that checks if the Tax Exempt field is set to export the Tax Exemption information. In the case of the M11, asociated to the “IVA Isento DL 346/85“ tax rate, it is not set. See images attached. Once the flag is set for that tax rate, the process exports the information properly
(0152943)
jonae   
2023-07-27 14:11   
It is a problem in the configuration of the tax rate