Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0048871 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo Localizations] Localization Spain | minor | have not tried | 2022-03-23 09:15 | 2022-10-25 17:30 | |||||||
| Reporter | wicherr | View Status | public | |||||||||
| Assigned To | psanjuan | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM 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 | |||||||||||
| Description | Spain fiscal module does not include tax rates for "tax exempt" customers | |||||||||||
| Steps To Reproduce | Install the spain fiscal module | |||||||||||
| Proposed Solution | Inserts to put in comments. | |||||||||||
| Tags | NOR | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
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); |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |