Openbravo Issue Tracking System - Openbravo Localizations
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048871Openbravo LocalizationsLocalization Spainpublic2022-03-23 09:152022-10-25 17:30
Reporterwicherr 
Assigned Topsanjuan 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
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
Summary0048871: Spain fiscal module does not include tax rates for "tax exempt" customers
DescriptionSpain fiscal module does not include tax rates for "tax exempt" customers
Steps To ReproduceInstall the spain fiscal module
Proposed SolutionInserts to put in comments.
Additional Information
TagsNOR
Relationships
related to defect 0048821 closed aferraz [Portugal] There are missing Tax Rate configuration for Tax Exempt Customer 
related to feature request 0045755 closed vmromanos New taxes required set as Tax Exempt=Yes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-03-23 09:15wicherrNew Issue
2022-03-23 09:15wicherrAssigned To => psanjuan
2022-03-23 09:25wicherrTag Attached: NOR
2022-03-23 09:36wicherrNote Added: 0135942
2022-03-23 16:31rafarodaRelationship addedrelated to 0048821
2022-03-23 16:31rafarodaRelationship addedrelated to 0045755
2022-10-25 17:30psanjuanSeveritymajor => minor

Notes
(0135942)
wicherr   
2022-03-23 09:36   
What I added in Norauto environment : (Can you/we check?) - Final purpose : Adding the tax rates into the module

-----------------------------------

For Spain - Peninsula y baleares - IVA

-----------------------------------
INSERT INTO public.c_tax
(c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, "name", updatedby, description, taxindicator, validfrom, issummary, rate, parent_tax_id, c_country_id, c_region_id, to_country_id, to_region_id, c_taxcategory_id, isdefault, istaxexempt, sopotype, "cascade", c_bp_taxcategory_id, line, iswithholdingtax, isnotaxable, deducpercent, originalrate, istaxundeductable, istaxdeductable, isnovat, baseamount, c_taxbase_id, doctaxamount, iscashvat, em_obspti_declaration, em_obspti_isreversecharge, em_obspti_isequivalentcharge, em_obspti_isintracommunity, em_obspti_islease, em_obspti_isrealestate, em_obspti_reagyp, em_obspti_isrebu, em_obspti_isexport, em_obspti_isimplicitcharge, em_ef_group, em_saft_taxcode, em_saft_taxexemption_id, em_rtp_department)
VALUES('45A8F63E04AB4F999510B47B4663715E', '757D621ABD1948F5BCBAD91F19BB70AC', '1F000EB998B94441AC9388472697307F', 'Y', now(), '100', now(), 'Exento IVA Normal', '100', NULL, NULL, '1999-01-01 00:00:00.000', 'N', 0, NULL, '106', NULL, '106', NULL, 'FF80818123B7FC160123B804AB88000B', 'N', 'Y', 'S', 'N', NULL, 10, 'N', 'N', NULL, NULL, 'N', 'N', 'N', 'LNA', NULL, 'D', 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 'NOR', NULL, NULL);

INSERT INTO public.c_tax
(c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, "name", updatedby, description, taxindicator, validfrom, issummary, rate, parent_tax_id, c_country_id, c_region_id, to_country_id, to_region_id, c_taxcategory_id, isdefault, istaxexempt, sopotype, "cascade", c_bp_taxcategory_id, line, iswithholdingtax, isnotaxable, deducpercent, originalrate, istaxundeductable, istaxdeductable, isnovat, baseamount, c_taxbase_id, doctaxamount, iscashvat, em_obspti_declaration, em_obspti_isreversecharge, em_obspti_isequivalentcharge, em_obspti_isintracommunity, em_obspti_islease, em_obspti_isrealestate, em_obspti_reagyp, em_obspti_isrebu, em_obspti_isexport, em_obspti_isimplicitcharge, em_ef_group, em_saft_taxcode, em_saft_taxexemption_id, em_rtp_department)
VALUES('462168E3D8734D30A5D0C6F9ACB695A5', '757D621ABD1948F5BCBAD91F19BB70AC', '1F000EB998B94441AC9388472697307F', 'Y', now(), '100',now(), 'Exento IVA Super Reducido', '100', NULL, NULL, '1999-01-01 00:00:00.000', 'N', 0, NULL, '106', NULL, '106', NULL, 'FF80818123B7FC160123B804AB8C0019', 'N', 'Y', 'S', 'N', NULL, 10, 'N', 'N', NULL, NULL, 'N', 'N', 'N', 'LNA', NULL, 'D', 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 'NOR', NULL, NULL);

INSERT INTO public.c_tax
(c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, "name", updatedby, description, taxindicator, validfrom, issummary, rate, parent_tax_id, c_country_id, c_region_id, to_country_id, to_region_id, c_taxcategory_id, isdefault, istaxexempt, sopotype, "cascade", c_bp_taxcategory_id, line, iswithholdingtax, isnotaxable, deducpercent, originalrate, istaxundeductable, istaxdeductable, isnovat, baseamount, c_taxbase_id, doctaxamount, iscashvat, em_obspti_declaration, em_obspti_isreversecharge, em_obspti_isequivalentcharge, em_obspti_isintracommunity, em_obspti_islease, em_obspti_isrealestate, em_obspti_reagyp, em_obspti_isrebu, em_obspti_isexport, em_obspti_isimplicitcharge, em_ef_group, em_saft_taxcode, em_saft_taxexemption_id, em_rtp_department)
VALUES('EB89EE037085419EB628984E18DD4548', '757D621ABD1948F5BCBAD91F19BB70AC', '1F000EB998B94441AC9388472697307F', 'Y', now(), '100', now(), 'Exento IVA Reducido', '100', NULL, NULL, '1999-01-01 00:00:00.000', 'N', 0, NULL, '106', NULL, '106', NULL, 'FF80818123B7FC160123B804AB880008', 'N', 'Y', 'S', 'N', NULL, 10, 'N', 'N', NULL, NULL, 'N', 'N', 'N', 'LNA', NULL, 'D', 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 'NOR', NULL, NULL);


-----------------------------------

For Spain - Canarias IGIC

-----------------------------------

INSERT INTO public.c_tax
(c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, "name", updatedby, description, taxindicator, validfrom, issummary, rate, parent_tax_id, c_country_id, c_region_id, to_country_id, to_region_id, c_taxcategory_id, isdefault, istaxexempt, sopotype, "cascade", c_bp_taxcategory_id, line, iswithholdingtax, isnotaxable, deducpercent, originalrate, istaxundeductable, istaxdeductable, isnovat, baseamount, c_taxbase_id, doctaxamount, iscashvat, em_obspti_declaration, em_obspti_isreversecharge, em_obspti_isequivalentcharge, em_obspti_isintracommunity, em_obspti_islease, em_obspti_isrealestate, em_obspti_reagyp, em_obspti_isrebu, em_obspti_isexport, em_obspti_isimplicitcharge, em_ef_group, em_rtp_department, em_saft_taxcode, em_saft_taxexemption_id, em_obspti_receive_oss)
VALUES('B690B0A0246B466C9D049C14E7A7F5A3', '757D621ABD1948F5BCBAD91F19BB70AC', '1F000EB998B94441AC9388472697307F', 'Y', '2022-03-18 16:31:23.966', '58383E479B064FECBC863373B12B722D', '2022-03-18 16:31:23.966', 'Adquisiciones IGI 0% exento', '58383E479B064FECBC863373B12B722D', 'Adquisiciones IGI 0% Tax exempt', NULL, '1999-01-01 00:00:00.000', 'N', 0, NULL, '106', NULL, '106', NULL, '6A1AAE35161D433AAE21955B3D5010D1', 'N', 'Y', 'B', 'N', NULL, 10, 'N', 'N', NULL, NULL, 'N', 'N', 'N', 'LNA', NULL, 'D', 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, NULL, 'NOR', NULL, NULL);

INSERT INTO public.c_tax
(c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, "name", updatedby, description, taxindicator, validfrom, issummary, rate, parent_tax_id, c_country_id, c_region_id, to_country_id, to_region_id, c_taxcategory_id, isdefault, istaxexempt, sopotype, "cascade", c_bp_taxcategory_id, line, iswithholdingtax, isnotaxable, deducpercent, originalrate, istaxundeductable, istaxdeductable, isnovat, baseamount, c_taxbase_id, doctaxamount, iscashvat, em_obspti_declaration, em_obspti_isreversecharge, em_obspti_isequivalentcharge, em_obspti_isintracommunity, em_obspti_islease, em_obspti_isrealestate, em_obspti_reagyp, em_obspti_isrebu, em_obspti_isexport, em_obspti_isimplicitcharge, em_ef_group, em_rtp_department, em_saft_taxcode, em_saft_taxexemption_id, em_obspti_receive_oss)
VALUES('99A4617D929B4361AAD53D898CC23682', '757D621ABD1948F5BCBAD91F19BB70AC', '1F000EB998B94441AC9388472697307F', 'Y', '2022-03-18 16:34:32.010', '58383E479B064FECBC863373B12B722D', '2022-03-18 16:34:32.010', 'IGIC Reducido exento', '58383E479B064FECBC863373B12B722D', NULL, NULL, '1999-01-01 00:00:00.000', 'N', 0, NULL, '106', '230', '106', NULL, '6E4A065E6E0D480EBDEF8E3C0F9D31E4', 'N', 'Y', 'B', 'N', NULL, 10, 'N', 'N', NULL, NULL, 'N', 'N', 'N', 'LNA', NULL, 'D', 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, NULL, 'NOR', NULL, NULL);

INSERT INTO public.c_tax
(c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, "name", updatedby, description, taxindicator, validfrom, issummary, rate, parent_tax_id, c_country_id, c_region_id, to_country_id, to_region_id, c_taxcategory_id, isdefault, istaxexempt, sopotype, "cascade", c_bp_taxcategory_id, line, iswithholdingtax, isnotaxable, deducpercent, originalrate, istaxundeductable, istaxdeductable, isnovat, baseamount, c_taxbase_id, doctaxamount, iscashvat, em_obspti_declaration, em_obspti_isreversecharge, em_obspti_isequivalentcharge, em_obspti_isintracommunity, em_obspti_islease, em_obspti_isrealestate, em_obspti_reagyp, em_obspti_isrebu, em_obspti_isexport, em_obspti_isimplicitcharge, em_ef_group, em_rtp_department, em_saft_taxcode, em_saft_taxexemption_id, em_obspti_receive_oss)
VALUES('BEA0665AAF094EB1BCDEAF09A21E76A6', '757D621ABD1948F5BCBAD91F19BB70AC', '1F000EB998B94441AC9388472697307F', 'Y', '2022-03-22 11:29:02.786', '58383E479B064FECBC863373B12B722D', '2022-03-22 15:06:55.989', 'IGIC Incrementado 1 exento', '58383E479B064FECBC863373B12B722D', NULL, NULL, '1999-01-01 00:00:00.000', 'N', 0, NULL, '106', '230', '106', NULL, 'E7A8B6441F214E7A89F798CA8BF67663', 'N', 'Y', 'B', 'N', NULL, 10, 'N', 'N', NULL, NULL, 'N', 'N', 'N', 'LNA', NULL, 'D', 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, NULL, 'NOR', NULL, NULL);

INSERT INTO public.c_tax
(c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, "name", updatedby, description, taxindicator, validfrom, issummary, rate, parent_tax_id, c_country_id, c_region_id, to_country_id, to_region_id, c_taxcategory_id, isdefault, istaxexempt, sopotype, "cascade", c_bp_taxcategory_id, line, iswithholdingtax, isnotaxable, deducpercent, originalrate, istaxundeductable, istaxdeductable, isnovat, baseamount, c_taxbase_id, doctaxamount, iscashvat, em_obspti_declaration, em_obspti_isreversecharge, em_obspti_isequivalentcharge, em_obspti_isintracommunity, em_obspti_islease, em_obspti_isrealestate, em_obspti_reagyp, em_obspti_isrebu, em_obspti_isexport, em_obspti_isimplicitcharge, em_ef_group, em_rtp_department, em_saft_taxcode, em_saft_taxexemption_id, em_obspti_receive_oss)
VALUES('1AF2A5272B544651806DC6C3734CCD24', '757D621ABD1948F5BCBAD91F19BB70AC', '1F000EB998B94441AC9388472697307F', 'Y', '2022-03-22 15:03:22.577', '58383E479B064FECBC863373B12B722D', '2022-03-22 15:06:46.851', 'IGIC Incrementado 2 exento', '58383E479B064FECBC863373B12B722D', NULL, NULL, '1999-01-01 00:00:00.000', 'N', 0, NULL, '106', '230', '106', NULL, '5491B1AEEC3A44BDB8163FA5998A02D2', 'N', 'Y', 'B', 'N', NULL, 10, 'N', 'N', NULL, NULL, 'N', 'N', 'N', 'LNA', NULL, 'D', 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, NULL, 'NOR', NULL, NULL);

INSERT INTO public.c_tax
(c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, "name", updatedby, description, taxindicator, validfrom, issummary, rate, parent_tax_id, c_country_id, c_region_id, to_country_id, to_region_id, c_taxcategory_id, isdefault, istaxexempt, sopotype, "cascade", c_bp_taxcategory_id, line, iswithholdingtax, isnotaxable, deducpercent, originalrate, istaxundeductable, istaxdeductable, isnovat, baseamount, c_taxbase_id, doctaxamount, iscashvat, em_obspti_declaration, em_obspti_isreversecharge, em_obspti_isequivalentcharge, em_obspti_isintracommunity, em_obspti_islease, em_obspti_isrealestate, em_obspti_reagyp, em_obspti_isrebu, em_obspti_isexport, em_obspti_isimplicitcharge, em_ef_group, em_rtp_department, em_saft_taxcode, em_saft_taxexemption_id, em_obspti_receive_oss)
VALUES('D4F7AB1825CB4427A3687FDCFC9C88D4', '757D621ABD1948F5BCBAD91F19BB70AC', '1F000EB998B94441AC9388472697307F', 'Y', '2022-03-22 15:10:59.255', '58383E479B064FECBC863373B12B722D', '2022-03-22 15:12:16.739', 'IGIC General exento', '58383E479B064FECBC863373B12B722D', NULL, NULL, '1999-01-01 00:00:00.000', 'N', 0, NULL, '106', '230', '106', NULL, 'EA36DABE7E3542E5A68AB89C0DC0338F', 'N', 'Y', 'B', 'N', NULL, 10, 'N', 'N', NULL, NULL, 'N', 'N', 'N', 'LNA', NULL, 'D', 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, NULL, 'NOR', NULL, NULL);