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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024614
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Localization Pack: Spain] SPLP 3.0majoralways2013-08-28 13:042014-04-02 08:59
ReporterpsanjuanView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision8d2a0aed71f7
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0024614: 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".

TagsNo tags attached.
Attached Files? file icon SalesTax_CashVAT.ods [^] (13,575 bytes) 2014-01-13 15:04
? file icon PurchaseTax_CashVAT.ods [^] (16,685 bytes) 2014-01-13 15:04
? file icon PurchaseTax_CashVAT_31Ene.ods [^] (17,292 bytes) 2014-01-31 13:14
? file icon SalesTax_CashVAT_31Ene.ods [^] (14,985 bytes) 2014-01-31 13:14

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 00246153.0MP30 closedvmromanos Openbravo ERP Openbravo 3 needs to allow Cash VAT management 

-  Notes
(0062698)
hgbot (developer)
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 (developer)
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 (developer)
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 (manager)
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 (manager)
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 (manager)
2014-04-02 08:59

 Closed as it was in Resolved for too long

- Issue History
Date Modified Username Field Change
2013-08-28 13:04 psanjuan New Issue
2013-08-28 13:04 psanjuan Assigned To => vmromanos
2013-08-28 13:06 psanjuan Proposed Solution updated
2013-08-28 13:22 psanjuan Proposed Solution updated
2013-08-28 13:22 psanjuan Proposed Solution updated
2013-08-28 13:33 psanjuan Proposed Solution updated
2013-08-28 13:34 psanjuan Proposed Solution updated
2013-08-28 13:36 psanjuan Proposed Solution updated
2013-08-28 13:38 psanjuan Proposed Solution updated
2013-08-28 13:41 psanjuan Proposed Solution updated
2013-08-28 13:48 psanjuan Proposed Solution updated
2013-08-28 13:48 psanjuan Proposed Solution updated
2013-09-03 12:39 psanjuan Relationship added related to 0024615
2013-09-03 13:24 psanjuan Proposed Solution updated
2013-09-03 13:28 psanjuan Proposed Solution updated
2013-09-03 13:37 psanjuan Proposed Solution updated
2013-09-03 13:42 psanjuan Proposed Solution updated
2013-11-28 08:03 mmarquez Issue Monitored: mmarquez
2013-12-11 10:02 hgbot Checkin
2013-12-11 10:02 hgbot Note Added: 0062698
2013-12-11 10:02 hgbot Status new => resolved
2013-12-11 10:02 hgbot Resolution open => fixed
2013-12-11 10:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/1efcc9ca2916058bbbf158704884182af6be41c1 [^]
2013-12-12 16:02 hgbot Checkin
2013-12-12 16:02 hgbot Note Added: 0062719
2014-01-08 15:49 hgbot Checkin
2014-01-08 15:49 hgbot Note Added: 0063297
2014-01-08 15:49 hgbot Fixed in SCM revision http://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:40 psanjuan Note Added: 0063355
2014-01-10 12:41 psanjuan File Added: SalesTax_CashVAT.ods
2014-01-10 12:41 psanjuan File Added: PurchaseTax_CashVAT.ods
2014-01-10 13:43 psanjuan File Deleted: PurchaseTax_CashVAT.ods
2014-01-10 13:43 psanjuan File Deleted: SalesTax_CashVAT.ods
2014-01-10 13:43 psanjuan File Added: PurchaseTax_CashVAT.ods
2014-01-10 13:43 psanjuan File Added: SalesTax_CashVAT.ods
2014-01-13 09:56 psanjuan File Deleted: PurchaseTax_CashVAT.ods
2014-01-13 09:56 psanjuan File Deleted: SalesTax_CashVAT.ods
2014-01-13 09:57 psanjuan File Added: PurchaseTax_CashVAT.ods
2014-01-13 09:57 psanjuan File Added: SalesTax_CashVAT.ods
2014-01-13 13:58 psanjuan File Deleted: PurchaseTax_CashVAT.ods
2014-01-13 13:58 psanjuan File Deleted: SalesTax_CashVAT.ods
2014-01-13 13:58 psanjuan File Added: PurchaseTax_CashVAT.ods
2014-01-13 13:58 psanjuan File Added: SalesTax_CashVAT.ods
2014-01-13 15:04 psanjuan File Deleted: PurchaseTax_CashVAT.ods
2014-01-13 15:04 psanjuan File Deleted: SalesTax_CashVAT.ods
2014-01-13 15:04 psanjuan File Added: SalesTax_CashVAT.ods
2014-01-13 15:04 psanjuan File Added: PurchaseTax_CashVAT.ods
2014-01-31 13:14 psanjuan File Added: PurchaseTax_CashVAT_31Ene.ods
2014-01-31 13:14 psanjuan File Added: SalesTax_CashVAT_31Ene.ods
2014-01-31 13:15 psanjuan Note Edited: 0063355 View Revisions
2014-01-31 13:18 psanjuan Note Added: 0063824
2014-04-02 08:59 plujan Note Added: 0065821
2014-04-02 08:59 plujan Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker