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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0014034
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] Taxesmajoralways2010-07-22 14:352010-10-01 17:29
ReporternetworkbView Statuspublic 
Assigned Topsanjuan 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision3708d1c87fe6
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

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

DescriptionIt 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%
Steps To Reproduceinstall 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.
Proposed SolutionExisting 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.




TagsNo tags attached.
Attached Filespdf file icon 3.transitario.pdf [^] (47,799 bytes) 2010-08-31 09:58
pdf file icon 2.dua.pdf [^] (49,851 bytes) 2010-08-31 09:58

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0014395 closedmtaal Openbravo ERP Strange behaviour updating a dataset 

-  Notes
(0030544)
hgbot (developer)
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 (developer)
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 (manager)
2010-10-01 17:29

 fixed and working

- Issue History
Date Modified Username Field Change
2010-07-22 14:35 networkb New Issue
2010-07-22 14:35 networkb Assigned To => psanjuan
2010-08-17 10:44 psanjuan Priority high => urgent
2010-08-30 10:55 psanjuan Summary tax rate incorrect in tax "importación 18%" => tax rate incorrect in tax "importaciones 18%"
2010-08-31 09:16 psanjuan Summary tax rate incorrect in tax "importaciones 18%" => Incorrect Tax Rate in case of "Import" related Tax Rates - Destination Country Spain
2010-08-31 09:16 psanjuan Description Updated View Revisions
2010-08-31 09:16 psanjuan Steps to Reproduce Updated View Revisions
2010-08-31 09:16 psanjuan Proposed Solution updated
2010-08-31 09:56 psanjuan Proposed Solution updated
2010-08-31 09:56 psanjuan Proposed Solution updated
2010-08-31 09:58 psanjuan File Added: 3.transitario.pdf
2010-08-31 09:58 psanjuan File Added: 2.dua.pdf
2010-08-31 10:29 psanjuan Proposed Solution updated
2010-08-31 10:41 psanjuan Steps to Reproduce Updated View Revisions
2010-08-31 10:41 psanjuan Proposed Solution updated
2010-08-31 15:24 hgbot Checkin
2010-08-31 15:24 hgbot Note Added: 0030544
2010-08-31 15:24 hgbot Status new => resolved
2010-08-31 15:24 hgbot Resolution open => fixed
2010-08-31 15:24 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/9db9675bfb77ef4dcb8aa5b3492358254a4b0c47 [^]
2010-09-01 17:40 vmromanos Relationship added depends on 0014395
2010-09-02 12:04 hgbot Checkin
2010-09-02 12:04 hgbot Note Added: 0030582
2010-09-02 12:04 hgbot Fixed in SCM revision http://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:35 psanjuan Summary Incorrect 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:35 psanjuan Description Updated View Revisions
2010-09-20 18:37 psanjuan Summary "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:37 psanjuan Description Updated View Revisions
2010-10-01 17:29 psanjuan Note Added: 0031551
2010-10-01 17:29 psanjuan Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker