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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0028557
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Modules] Cash VAT Managementmajoralways2015-01-12 09:082015-12-15 18:04
ReporterpsanjuanView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision6108e841c723
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 Topsanjuan
Regression introduced in release
Summary

0028557: New process/management needed to settle unpaid VAT at a given date.

DescriptionA new process needs to be implemented to settle at a given date, the VAT of unpaid invoices (both purchase and sales), invoices dated within a given period of time.

In the case of Spain:

Dated on 31/12/2015 not paid VAT of 2014 invoices needs to be submitted.

In Spanish:

Con efectos desde el 1 de enero de 2014, el artículo 23 de la Ley 14/2013, de 27 de septiembre, de apoyo a los emprendedores y su internacionalización introduce el Régimen especial del criterio de caja en el Capítulo X del Título IX de la Ley 37/1992, de 28 de diciembre, del Impuesto sobre el Valor Añadido (art. 163 decies y sig.)

Este nuevo Régimen especial de carácter optativo, permite a los sujetos pasivos retrasar el devengo y la consiguiente declaración e ingreso del IVA repercutido hasta el momento del cobro a sus clientes aunque se retardará, igualmente, la deducción del IVA soportado en sus adquisiciones hasta el momento en que efectúe el pago a sus proveedores (criterio de caja doble); todo ello con la fecha límite del 31 de diciembre del año inmediato posterior a aquel en que las operaciones se hayan efectuado.


Steps To Reproducen/a
Proposed SolutionA new process named "Manual Cash VAT Settlement" needs to be created.

This process will allow to select total/partially paid purchase/sales invoices for:
* a given organization
* invoices dated starting from a given date
* invoices dated up to a given ending date
* and for a given currency

Within this process a "pick&complete" feature will allow to select those invoices to settle.

Once posted at a given accounting date (in Spain should be 31-12-2015), generated accounting entries will move "temporary" VAT accounted amounts to "final" VAT accounts, therefore VAT can be settled and submitted to the tax authorities.

Same way a new line set as "Manual Settlement" will then be created in the corresponding invoice, "Cash VAT" tab.

This process is supposed to be implemented in a generic way. Specific requirements for Spain will also be handle in modules such as 303 Tax Form, depending on the needs.

In Spanish:

Se va a implementar una nueva ventana/proceso relacionada con un nuevo tipo de documento. En esta ventana se podrá seleccionar:
* la organización
* la fecha factura desde (i.e. 01-01-2014)
* la fecha factura hasta (i.e. 31-12-2014)
fechas con las que filtrar las facturas acogidas a IVA de Caja que no se encuentren pagadas/cobradas total o parcialmente, dentro del periodo en que se acogieron al IVA de Caja (2014)
* y la moneda (EUR)

Una vez se lanza el proceso, en otra ventana de tipo Pick&Edit, se mostrarán las facturas que cubren los criterios de selección anteriores. Para cada factura se mostrará el porcentaje de IVA que resta por liquidar.

El usuario podrá seleccionar las facturas para su liquidación a fecha 31-12-2015 (fecha contable a introducir por el usuario).

Una vez contabilizado, se realizará el asiento contable de traslado del IVA de cuentas temporales (tipo 4720T) a definitivas (47200). Este IVA, por tanto, se devenga a 31-12-2015 y por tanto puede liquidarse con Hacienda. (Se podrá incluir por tanto en modelos 303 y 390 - Enero).

Se creará una nueva línea de liquidación manual con fecha de pago 31-12-2015 en la ventana factura, pestaña Impuesto, sub-pestaña Cash VAT, con el porcentaje restante de liquidación de IVA a fecha 31-12-2015


TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0031699 closedvmromanos Openbravo ERP Payments after manual cash vat settlement 
causes feature request 0031644 closedvmromanos Localization Pack: Spain End Year Cash VAT manually settled needs to be included in Modelo 390 2015 
causes feature request 0027942 closedvmromanos Localization Pack: Spain End of year Cash VAT needs to be submitted in 303 end year tax form (December 2015 or 4Q 2015) 

-  Notes
(0081446)
psanjuan (manager)
2015-11-03 12:08

 For additional information (In Spanish) review url below:
(0082323)
psanjuan (manager)
2015-11-25 13:49

 Verified. See test cases created in Test Link under Cash VAT folder// Manual Cash VAT Settlement.
(0082332)
hgbot (developer)
2015-11-25 15:35

 Repository: erp/devel/pi
Changeset: f70a7e72efe6e07af355415caeee30c32be0bbd8
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Nov 25 15:34:21 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f70a7e72efe6e07af355415caeee30c32be0bbd8 [^]

Fixed bug 28557: Manual Cash VAT Settlement (Core)

This changeset contains only the Manual Cash VAT Settlement stuff related to core.
The rest of this feature can be found in Cash VAT Module 1.0.100 (or higher).

Added column C_INVOICETAX_CASHVAT.ISMANUALSETTLEMENT to control whether the line is created by a Manual Cash VAT Settlement.
View C_INVOICETAX_CASHVAT_V modified to get records linked to a payment or not (as for the new records comming from a Manual Cash VAT Settlement)
Deprecated method createFactCashVAT() to remove useless parameter cCurrencyID and adapted to get always the invoice's currency instead.

---
M src-db/database/model/tables/C_INVOICETAX_CASHVAT.xml
M src-db/database/model/views/C_INVOICETAX_CASHVAT_V.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src/org/openbravo/erpCommon/ad_forms/DocFINFinAccTransaction.java
M src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java
M src/org/openbravo/erpCommon/ad_forms/DocFINReconciliation.java
M src/org/openbravo/erpCommon/utility/CashVATUtil.java
---
(0082333)
vmromanos (manager)
2015-11-25 15:36

 Code related to Manual Cash VAT module can be found in manual_settlement ([ms]) branch: https://code.openbravo.com/erp/mods/org.openbravo.module.cashvat/shortlog/c550f9a516ec [^]
(0082353)
hudsonbot (developer)
2015-11-26 00:59

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/47856dce24b9 [^]
Maturity status: Test
(0082385)
hgbot (developer)
2015-11-26 18:49

 Repository: erp/mods/org.openbravo.module.cashvat
Changeset: 6108e841c7231c2d277b2fddbbcf047b240c81f1
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Nov 26 18:44:19 2015 +0100
URL: http://code.openbravo.com/erp/mods/org.openbravo.module.cashvat/rev/6108e841c7231c2d277b2fddbbcf047b240c81f1 [^]

Fixed bug 28557: Manual Cash VAT Settlement (Module)

---
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
M src-db/database/sourcedata/AD_TAB.xml
A build/classes/org/openbravo/module/cashvat/modulescript/CreateAccountingConfiguration.class
A build/classes/org/openbravo/module/cashvat/modulescript/CreateAccountingConfigurationData.class
A referencedata/standard/Grid_Configuration.xml
A referencedata/standard/OBCVAT_DocumentType.xml
A src-db/database/model/modifiedTables/C_TAX.xml
A src-db/database/model/tables/OBCVAT_MANUALSETTLEMENT.xml
A src-db/database/model/tables/OBCVAT_MANUALSETTLEMENTLINE.xml
A src-db/database/model/triggers/OBCVAT_MANUALSETTLEMENT_TRG.xml
A src-db/database/model/triggers/OBCVAT_MANUALSETTLINE_TRG.xml
A src-db/database/sourcedata/AD_CALLOUT.xml
A src-db/database/sourcedata/AD_COLUMN.xml
A src-db/database/sourcedata/AD_DATASET.xml
A src-db/database/sourcedata/AD_DATASET_TABLE.xml
A src-db/database/sourcedata/AD_ELEMENT.xml
A src-db/database/sourcedata/AD_MENU.xml
A src-db/database/sourcedata/AD_MESSAGE.xml
A src-db/database/sourcedata/AD_MODEL_OBJECT.xml
A src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
A src-db/database/sourcedata/AD_PACKAGE.xml
A src-db/database/sourcedata/AD_REFERENCE.xml
A src-db/database/sourcedata/AD_REF_LIST.xml
A src-db/database/sourcedata/AD_TABLE.xml
A src-db/database/sourcedata/AD_TABLE_NAVIGATION.xml
A src-db/database/sourcedata/AD_TREENODE.xml
A src-db/database/sourcedata/AD_VAL_RULE.xml
A src-db/database/sourcedata/AD_WINDOW.xml
A src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
A src-db/database/sourcedata/OBUIAPP_PROCESS.xml
A src-db/database/sourcedata/OBUIAPP_REF_WINDOW.xml
A src-db/database/sourcedata/OBUISEL_SELECTOR.xml
A src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
A src-test/org/openbravo/module/cashvat/PerformanceTest.java
A src-util/modulescript/src/org/openbravo/module/cashvat/modulescript/CreateAccountingConfiguration.java
A src-util/modulescript/src/org/openbravo/module/cashvat/modulescript/CreateAccountingConfiguration_data.xsql
A src/org/openbravo/module/cashvat/accounting/DocLine_ManualSettlement.java
A src/org/openbravo/module/cashvat/accounting/DocManualSettlementCashVAT.java
A src/org/openbravo/module/cashvat/accounting/DocManualSettlementCashVATTemplate.java
A src/org/openbravo/module/cashvat/callout/SE_ManualCashVATSettlement_Org.java
A src/org/openbravo/module/cashvat/handler/CashVATManualSettlementHandler.java
A src/org/openbravo/module/cashvat/handler/ReactivateCashVATManualSettlementHandler.java
A src/org/openbravo/module/cashvat/hqlquerytransformer/CashVATForSettlementTransformer.java
A src/org/openbravo/module/cashvat/util/OBCVAT_Utility.java
---
(0082393)
psanjuan (manager)
2015-11-27 08:52

 Issue can be closed.

- Issue History
Date Modified Username Field Change
2015-01-12 09:08 psanjuan New Issue
2015-01-12 09:08 psanjuan Assigned To => vmromanos
2015-10-27 13:47 psanjuan Status new => scheduled
2015-10-27 13:47 psanjuan Proposed Solution updated
2015-11-02 11:38 psanjuan Proposed Solution updated
2015-11-03 11:42 psanjuan Description Updated View Revisions
2015-11-03 11:58 psanjuan Summary Dated on 31/12/2015 not paid VAT needs to be submitted => New process/management needed to settle unpaid VAT at a given date.
2015-11-03 11:58 psanjuan Description Updated View Revisions
2015-11-03 11:58 psanjuan Proposed Solution updated
2015-11-03 12:00 psanjuan Proposed Solution updated
2015-11-03 12:08 psanjuan Note Added: 0081446
2015-11-03 12:08 psanjuan Proposed Solution updated
2015-11-03 12:10 psanjuan Proposed Solution updated
2015-11-25 13:49 psanjuan Note Added: 0082323
2015-11-25 15:35 hgbot Checkin
2015-11-25 15:35 hgbot Note Added: 0082332
2015-11-25 15:35 hgbot Status scheduled => resolved
2015-11-25 15:35 hgbot Resolution open => fixed
2015-11-25 15:35 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f70a7e72efe6e07af355415caeee30c32be0bbd8 [^]
2015-11-25 15:36 vmromanos Note Added: 0082333
2015-11-25 15:37 vmromanos Review Assigned To => psanjuan
2015-11-26 00:59 hudsonbot Checkin
2015-11-26 00:59 hudsonbot Note Added: 0082353
2015-11-26 18:49 hgbot Checkin
2015-11-26 18:49 hgbot Note Added: 0082385
2015-11-26 18:49 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/f70a7e72efe6e07af355415caeee30c32be0bbd8 [^] => http://code.openbravo.com/erp/mods/org.openbravo.module.cashvat/rev/6108e841c7231c2d277b2fddbbcf047b240c81f1 [^]
2015-11-27 08:52 psanjuan Note Added: 0082393
2015-11-27 08:52 psanjuan Status resolved => closed
2015-12-09 14:11 psanjuan Relationship added causes 0031644
2015-12-09 14:12 psanjuan Relationship added causes 0027942
2015-12-14 10:24 vmromanos Relationship added related to 0031699
2015-12-15 18:04 ngarcia Issue Monitored: ngarcia

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker