Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0048871
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo Localizations] Localization Spainminorhave not tried2022-03-23 09:152022-10-25 17:30
ReporterwicherrView Statuspublic 
Assigned Topsanjuan 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Regression introduced in release
Summary

0048871: 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.
TagsNOR
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0048821 closedaferraz [Portugal] There are missing Tax Rate configuration for Tax Exempt Customer 
related to feature request 0045755 closedvmromanos New taxes required set as Tax Exempt=Yes 

-  Notes
(0135942)
wicherr (developer)
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);

- Issue History
Date Modified Username Field Change
2022-03-23 09:15 wicherr New Issue
2022-03-23 09:15 wicherr Assigned To => psanjuan
2022-03-23 09:25 wicherr Tag Attached: NOR
2022-03-23 09:36 wicherr Note Added: 0135942
2022-03-23 16:31 rafaroda Relationship added related to 0048821
2022-03-23 16:31 rafaroda Relationship added related to 0045755
2022-10-25 17:30 psanjuan Severity major => minor


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker