Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024614Localization Pack: SpainSPLP 3.0public2013-08-28 13:042014-04-02 08:59
Reporterpsanjuan 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04.1
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0024614: Several SPLP features need to be adjusted to manage Cash VAT
DescriptionSeveral SPLP features need to be adjusted to manage Cash VAT
Steps To Reproducen/a
Proposed Solution(1) Spanish taxes dataset needs to include new VAT Rates set as "Cash VAT Rate".

* Current VAT Tax Rates need to be duplicated as there should be New VAT Tax Rates which allow to manage Cash VAT (and therefore are set as "Cash VAT Rate", see issue related).
See excel sheets attached. To be Research.

Example: we need to have a tax rate named "Adquisiciones IVA 21%" (current one with no change, therefore do not set as "Cash VAT Rate") + a new tax rate named "Adquisiciones IVA 21% IVA de Caja" configured same way as "Adquisiciones IVA 21%" but set as "Cash VAT Rate".

(2) Invoice Register Books Setup dataset needs to include new VAT Rates set as "Cash VAT Rate" in the configuration of both:

* the Received Invoice Register Book. The configuration of this book needs to include the new VAT purchase tax set as Cash VAT Rate, and for all the purchase document types.
* and Issued Invoice Register Book. The configuration of this book needs to include the new VAT sales tax set as Cash VAT Rate, and for all the sales document types.

A new version module needs to be released named:
"Configuración de los libros de facturas 2014".

(3) Invoice Register Books feature needs to change for Invoices under Cash VAT regimen (check-box "Cash VAT Invoice" selected):

- Issued Invoice Register Book must specify the collection date (total or partial) + the amount collected + bank + method of payment for each issued invoice.
- Received Invoices Register Book must specify the payment date (total or partial) + the amount paid + method of payment for each received invoice.

Note: It could be that a specific Collection & Payments book needs to be created. No more information on this regard.
This change will impact the 340 txt format for sure. No news about this change coming from the AEAT yet.

Note that:
the "final" format changes in the Invoice Register Books and therefore in the 340 VAT report, are not known at this moment. To be research.

(4) Below listed VAT reports need to be adjusted to manage Cash VAT.

- Changes in the monthly/quarterly VAT reports (VAT reports 340, 303 and 349) and in the annual VAT reports (390 and 347)

Note that:
The "final" format changes in the VAT reports are not known at this moment.

As soon as those new requirements are known (published by the AEAT), the corresponding Feature Request will be created for each of these VAT reports (303, 340, 349, 390 and 347)

Changes expected are:

* the txt or xml format (in the case of 390 VAT report) needs to be adjusted. No news about the changes coming from the AEAT so far.

(First changes will take place in the monthly 303, 340 and 349 reports of January 2014 period to be submitted to the AEAT February 20, 2014 the latest. The changes in the 390 and 347 can wait as those will need to be submitted in 2015)

* the Sales VAT to be included in these reports must be the VAT actually "Collected" in the date/period it has been totally or partially collected for those sales invoices set as "Cash VAT Invoice".

* and the Purchase VAT to be included in these reports must be the VAT actually "Paid" in the date/period it has been totally or partially paid, for those purchase invoices set as "Cash VAT Invoice".

Additional Information
TagsNo tags attached.
Relationships
related to feature request 00246153.0MP30 closed vmromanos Openbravo ERP Openbravo 3 needs to allow Cash VAT management 
Attached Files? SalesTax_CashVAT.ods (13,575) 2014-01-13 15:04
https://issues.openbravo.com/file_download.php?file_id=6635&type=bug
? PurchaseTax_CashVAT.ods (16,685) 2014-01-13 15:04
https://issues.openbravo.com/file_download.php?file_id=6636&type=bug
? PurchaseTax_CashVAT_31Ene.ods (17,292) 2014-01-31 13:14
https://issues.openbravo.com/file_download.php?file_id=6677&type=bug
? SalesTax_CashVAT_31Ene.ods (14,985) 2014-01-31 13:14
https://issues.openbravo.com/file_download.php?file_id=6678&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-08-28 13:04psanjuanNew Issue
2013-08-28 13:04psanjuanAssigned To => vmromanos
2013-08-28 13:04psanjuanOBNetwork customer => No
2013-08-28 13:06psanjuanProposed Solution updated
2013-08-28 13:22psanjuanProposed Solution updated
2013-08-28 13:22psanjuanProposed Solution updated
2013-08-28 13:33psanjuanProposed Solution updated
2013-08-28 13:34psanjuanProposed Solution updated
2013-08-28 13:36psanjuanProposed Solution updated
2013-08-28 13:38psanjuanProposed Solution updated
2013-08-28 13:41psanjuanProposed Solution updated
2013-08-28 13:48psanjuanProposed Solution updated
2013-08-28 13:48psanjuanProposed Solution updated
2013-09-03 12:39psanjuanRelationship addedrelated to 0024615
2013-09-03 13:24psanjuanProposed Solution updated
2013-09-03 13:28psanjuanProposed Solution updated
2013-09-03 13:37psanjuanProposed Solution updated
2013-09-03 13:42psanjuanProposed Solution updated
2013-11-28 08:03mmarquezIssue Monitored: mmarquez
2013-12-11 10:02hgbotCheckin
2013-12-11 10:02hgbotNote Added: 0062698
2013-12-11 10:02hgbotStatusnew => resolved
2013-12-11 10:02hgbotResolutionopen => fixed
2013-12-11 10:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/1efcc9ca2916058bbbf158704884182af6be41c1 [^]
2013-12-12 16:02hgbotCheckin
2013-12-12 16:02hgbotNote Added: 0062719
2014-01-08 15:49hgbotCheckin
2014-01-08 15:49hgbotNote Added: 0063297
2014-01-08 15:49hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/1efcc9ca2916058bbbf158704884182af6be41c1 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/8d2a0aed71f711bd2126d4c3d3734142774a79c5 [^]
2014-01-10 12:40psanjuanNote Added: 0063355
2014-01-10 12:41psanjuanFile Added: SalesTax_CashVAT.ods
2014-01-10 12:41psanjuanFile Added: PurchaseTax_CashVAT.ods
2014-01-10 13:43psanjuanFile Deleted: PurchaseTax_CashVAT.ods
2014-01-10 13:43psanjuanFile Deleted: SalesTax_CashVAT.ods
2014-01-10 13:43psanjuanFile Added: PurchaseTax_CashVAT.ods
2014-01-10 13:43psanjuanFile Added: SalesTax_CashVAT.ods
2014-01-13 09:56psanjuanFile Deleted: PurchaseTax_CashVAT.ods
2014-01-13 09:56psanjuanFile Deleted: SalesTax_CashVAT.ods
2014-01-13 09:57psanjuanFile Added: PurchaseTax_CashVAT.ods
2014-01-13 09:57psanjuanFile Added: SalesTax_CashVAT.ods
2014-01-13 13:58psanjuanFile Deleted: PurchaseTax_CashVAT.ods
2014-01-13 13:58psanjuanFile Deleted: SalesTax_CashVAT.ods
2014-01-13 13:58psanjuanFile Added: PurchaseTax_CashVAT.ods
2014-01-13 13:58psanjuanFile Added: SalesTax_CashVAT.ods
2014-01-13 15:04psanjuanFile Deleted: PurchaseTax_CashVAT.ods
2014-01-13 15:04psanjuanFile Deleted: SalesTax_CashVAT.ods
2014-01-13 15:04psanjuanFile Added: SalesTax_CashVAT.ods
2014-01-13 15:04psanjuanFile Added: PurchaseTax_CashVAT.ods
2014-01-31 13:14psanjuanFile Added: PurchaseTax_CashVAT_31Ene.ods
2014-01-31 13:14psanjuanFile Added: SalesTax_CashVAT_31Ene.ods
2014-01-31 13:15psanjuanNote Edited: 0063355bug_revision_view_page.php?bugnote_id=0063355#r5400
2014-01-31 13:18psanjuanNote Added: 0063824
2014-04-02 08:59plujanNote Added: 0065821
2014-04-02 08:59plujanStatusresolved => closed

Notes
(0062698)
hgbot   
2013-12-11 10:02   
Repository: erp/mods/org.openbravo.localization.spain.referencedata.taxes
Changeset: 1efcc9ca2916058bbbf158704884182af6be41c1
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Wed Dec 11 12:04:29 2013 +0530
URL: http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/1efcc9ca2916058bbbf158704884182af6be41c1 [^]

Fixes Issue 24614: Several SPLP features need to be adjusted to manage Cash VAT

1. Included new cash VAT tax rates
2. Adapted "Info. Conta. Impuestos" process to support the new default transitory accounts linked to the cash vat.

---
M referencedata/standard/Impuestos_ES.xml
M src-db/database/model/functions/ESTAX_ACCOUNTING_TAB.xml
M src-db/database/sourcedata/AD_DATASET.xml
---
(0062719)
hgbot   
2013-12-12 16:02   
Repository: erp/mods/org.openbravo.localization.spain.referencedata.taxes
Changeset: f71e26f38547870e677129f2fb58183c25723e3f
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Thu Dec 12 17:16:46 2013 +0530
URL: http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/f71e26f38547870e677129f2fb58183c25723e3f [^]

Related to Issue 24614: Several SPLP features need to be adjusted to manage Cash VAT

---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0063297)
hgbot   
2014-01-08 15:49   
Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 8d2a0aed71f711bd2126d4c3d3734142774a79c5
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Wed Jan 08 20:08:55 2014 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/8d2a0aed71f711bd2126d4c3d3734142774a79c5 [^]

Fixes Issue 24614: Several SPLP features need to be adjusted to manage Cash VAT

[1] Added payment/collection date, amount paid/collected, method of payment and bank in Invoice register book lineStyle
[2] Modified the "Create" Process in invoice register book to include the new fields
[3] Added the fields payment date, amount paid and method of payment in Received Invoices RegisterBook report
[4] Added the fields collection date, amount collected, method of payment, bank in Issued Invoices RegisterBook report

---
M src-db/database/model/tables/OBIRB_INVBOOKLINE.xml
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
M src/org/openbravo/module/invoicesregisterbook/obirb_reports/IssuedInvoicesRegisterBook.jrxml
M src/org/openbravo/module/invoicesregisterbook/obirb_reports/ReceivedInvoicesRegisterBook.jrxml
---
(0063355)
psanjuan   
2014-01-10 12:40   
(edited on: 2014-01-31 13:15)
Regarding point (1) above

(1) Spanish taxes dataset needs to include new VAT Rates set as "Cash VAT Rate".

CASH VAT rates are not going to be included in the Spanish Taxes dataset but in a new module, therefore version 1.4.0 of the Spanish Taxes module is now cancelled.

For additional information about which taxes need to be created as CASH VAT taxes, please review the two excel sheets attached.
(0063824)
psanjuan   
2014-01-31 13:18   
There is a new version of the excel sheets, named as 31 Ene

In those sheets the Spanish tax rates are split as:
-The ones which do not need to be duplicated due to Cash VAT feature. Those are set to "No" in Red color.

- The ones which need to be duplicated due to Cash VAT feature. Those are set to "Yes" and in Black color and Blue color (this last one is for the ones including withholdings)

- The ones which require an additional research. Those are set to "TBD" in Green color.
(0065821)
plujan   
2014-04-02 08:59   
Closed as it was in Resolved for too long