Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
0014034Localization Pack: SpainTaxespublic2010-07-22 14:352010-10-01 17:29
networkb 
psanjuan 
urgentmajoralways
closedfixed 
20Community Appliance
 
 
0014034: "Import" (Importaciones) related Tax Rates setup as both 0% tax rates and 18/16%-8/7%-4% to be used depending on the needs
It is required that:
"Import" (Importaciones) related Spanish Tax Rates are setup as both 0% tax rates and 18/16%-8/7%-4% to be used depending on the needs. For an explanation see "proposed solution" section.

Right now import tax rate is a 18%, by example, but, it should be a 0% tax rate due to the fact that Import related Invoices do not have an Spanish tax rate normally but 0%
install tax module, version 1.2.17 and verify there are below tax rates:
- Importaciones 16%
- Importaciones 7%
- Importaciones 4%
- Importaciones 18%
- Importaciones 8%
All of the above have below setup:
- From Country: any country but a EU country or Spain
- Destination Country: Spain
- Linked to 303 Tax Parameters.
- Tax rate: any (16%, 7%, 4%, 18% and 8%) but 0% as it is requested to be.
Existing Tax Rates changes:
(1) Existing "importaciones" related Tax rates must be changed as described below:
- From Country: should be now Empty
- Destination Country: should be now Empty

List of existing "importaciones" related Tax Rates:
- Importaciones 16%
- Importaciones 7%
- Importaciones 4%
- Importaciones 18%
- Importaciones 8%

No more changes are required for the existing Tax Rates.
The end user will have to manually select those as a "Tax Line" in the application path: Procurement Management || Transactions || Purchase Invoice || Header >> Tax

New Tax Rates must be created:
(1) Below tax rates must be created, same way as the existing ones but:
- Importaciones 16%=0% - Tax Rate: 0%
- Importaciones 7%=0% - Tax Rate: 0%
- Importaciones 4%=0% - Tax Rate: 0%
- Importaciones 18%=0% - Tax Rate: 0%
- Importaciones 8%=0% - Tax Rate: 0%
(2) For all of the above (new ones):
- From Country: any country but EU Country and Spain.
- Destination Country: Spain
(3) Tax Parameters: empty

The way of using existing and new "Importaciones" related Tax Rates is described below:
1 - Purchase Invoices coming from BP(Vendors) do not located in any of the EU countries or Spain, must be enter in the system in the application path: Procurement Management || Transactions || Purchase Invoice || Header
1.1 - Those Purchase Invoices will be entered in the system in the corresponding currency (by example: $) and the system should select in the Purchase Invoice lines any of the "New" Importaciones Tax Rates, based on "Country From" and "Destination Country"=Spain setup.
1.2.- In any case the Tax Rate should be 0%
2.- In case of "Imports" there is an additional invoice coming from the "Dispatcher/Carrier" (see attachment transitario.pdf) which should also be entered in the system in the application path: Procurement Management || Transactions || Purchase Invoice || Header
2.1.- Above invoice (Dispatcher purchase invoice) normally contains below items:
- Services provided by the Dispatcher - those ones must be handle as services items as a purchase line each linked to the corresponding Tax Rate and subject to VAT (by example: Despacho de Aduanas).
- Custom Exempt items - those ones must be handle as services items as a purchase line each linked to the corresponding Exempt Tax Rate (by example Derechos Arancel).
- And finally "Import VAT" (IVA Importacion) - that ones must be handle as a "Tax Line" in the purchase Invoice - Tax Tab. End user must select any of the "Existing Tax Rates" and enter the corresponding "Taxable Amount" which can be found in a document named "DUA" and the system will automatically calculate the "Tax Amount". In our example, see attachement named dua.pdf, end user must select by example "Importaciones 16%", and enter 9.496,94 in the field "Taxable Amount" so the system can automatically calculate 1.519,51 as Tax Amount. These are the amounts which should be included in the 303 tax report.




No tags attached.
depends on defect 0014395 closed mtaal Openbravo ERP Strange behaviour updating a dataset 
pdf 3.transitario.pdf (47,799) 2010-08-31 09:58
https://issues.openbravo.com/file_download.php?file_id=2992&type=bug
pdf 2.dua.pdf (49,851) 2010-08-31 09:58
https://issues.openbravo.com/file_download.php?file_id=2993&type=bug
Issue History
2010-07-22 14:35networkbNew Issue
2010-07-22 14:35networkbAssigned To => psanjuan
2010-08-17 10:44psanjuanPriorityhigh => urgent
2010-08-30 10:55psanjuanSummarytax rate incorrect in tax "importación 18%" => tax rate incorrect in tax "importaciones 18%"
2010-08-31 09:16psanjuanSummarytax rate incorrect in tax "importaciones 18%" => Incorrect Tax Rate in case of "Import" related Tax Rates - Destination Country Spain
2010-08-31 09:16psanjuanDescription Updatedbug_revision_view_page.php?rev_id=768#r768
2010-08-31 09:16psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=770#r770
2010-08-31 09:16psanjuanProposed Solution updated
2010-08-31 09:56psanjuanProposed Solution updated
2010-08-31 09:56psanjuanProposed Solution updated
2010-08-31 09:58psanjuanFile Added: 3.transitario.pdf
2010-08-31 09:58psanjuanFile Added: 2.dua.pdf
2010-08-31 10:29psanjuanProposed Solution updated
2010-08-31 10:41psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=771#r771
2010-08-31 10:41psanjuanProposed Solution updated
2010-08-31 15:24hgbotCheckin
2010-08-31 15:24hgbotNote Added: 0030544
2010-08-31 15:24hgbotStatusnew => resolved
2010-08-31 15:24hgbotResolutionopen => fixed
2010-08-31 15:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/9db9675bfb77ef4dcb8aa5b3492358254a4b0c47 [^]
2010-09-01 17:40vmromanosRelationship addeddepends on 0014395
2010-09-02 12:04hgbotCheckin
2010-09-02 12:04hgbotNote Added: 0030582
2010-09-02 12:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/9db9675bfb77ef4dcb8aa5b3492358254a4b0c47 [^] => http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/3708d1c87fe62be3d02f7bcf92da15e74d19e4bd [^]
2010-09-20 18:35psanjuanSummaryIncorrect Tax Rate in case of "Import" related Tax Rates - Destination Country Spain => "Import" (Importaciones) related Tax Rates setup as both 0% tax rates and 18%-8%-4% to be used depending on the needs
2010-09-20 18:35psanjuanDescription Updatedbug_revision_view_page.php?rev_id=879#r879
2010-09-20 18:37psanjuanSummary "Import" (Importaciones) related Tax Rates setup as both 0% tax rates and 18%-8%-4% to be used depending on the needs => "Import" (Importaciones) related Tax Rates setup as both 0% tax rates and 18/16%-8/7%-4% to be used depending on the needs
2010-09-20 18:37psanjuanDescription Updatedbug_revision_view_page.php?rev_id=880#r880
2010-10-01 17:29psanjuanNote Added: 0031551
2010-10-01 17:29psanjuanStatusresolved => closed

Notes
(0030544)
hgbot   
2010-08-31 15:24   
Repository: erp/mods/org.openbravo.localization.spain.referencedata.taxes
Changeset: 9db9675bfb77ef4dcb8aa5b3492358254a4b0c47
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Aug 31 15:26:19 2010 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/9db9675bfb77ef4dcb8aa5b3492358254a4b0c47 [^]

Fixed bug 14034 in module version 1.2.18
Updated core's dependency to 2.50MP14

---
M referencedata/standard/Impuestos_ES.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0030582)
hgbot   
2010-09-02 12:04   
Repository: erp/mods/org.openbravo.localization.spain.referencedata.taxes
Changeset: 3708d1c87fe62be3d02f7bcf92da15e74d19e4bd
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Sep 02 12:01:28 2010 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/3708d1c87fe62be3d02f7bcf92da15e74d19e4bd [^]

Fixed issue 14034 in module version 1.2.18
Added IsBusinessObject flag to the C_Tax table
Exported the dataset again

---
M referencedata/standard/Impuestos_ES.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0031551)
psanjuan   
2010-10-01 17:29   
fixed and working