Openbravo Issue Tracking System - Modules
View Issue Details
0028557ModulesCash VAT Managementpublic2015-01-12 09:082015-12-15 18:04
psanjuan 
vmromanos 
urgentmajoralways
closedfixed 
20Ubuntu 8.04.1
 
 
psanjuan
0028557: New process/management needed to settle unpaid VAT at a given date.
A 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.


n/a
A 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


No tags attached.
related to defect 0031699 closed vmromanos Openbravo ERP Payments after manual cash vat settlement 
causes feature request 0031644 closed vmromanos Localization Pack: Spain End Year Cash VAT manually settled needs to be included in Modelo 390 2015 
causes feature request 0027942 closed vmromanos Localization Pack: Spain End of year Cash VAT needs to be submitted in 303 end year tax form (December 2015 or 4Q 2015) 
Issue History
2015-01-12 09:08psanjuanNew Issue
2015-01-12 09:08psanjuanAssigned To => vmromanos
2015-10-27 13:47psanjuanStatusnew => scheduled
2015-10-27 13:47psanjuanProposed Solution updated
2015-11-02 11:38psanjuanProposed Solution updated
2015-11-03 11:42psanjuanDescription Updatedbug_revision_view_page.php?rev_id=10010#r10010
2015-11-03 11:58psanjuanSummaryDated 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:58psanjuanDescription Updatedbug_revision_view_page.php?rev_id=10011#r10011
2015-11-03 11:58psanjuanProposed Solution updated
2015-11-03 12:00psanjuanProposed Solution updated
2015-11-03 12:08psanjuanNote Added: 0081446
2015-11-03 12:08psanjuanProposed Solution updated
2015-11-03 12:10psanjuanProposed Solution updated
2015-11-25 13:49psanjuanNote Added: 0082323
2015-11-25 15:35hgbotCheckin
2015-11-25 15:35hgbotNote Added: 0082332
2015-11-25 15:35hgbotStatusscheduled => resolved
2015-11-25 15:35hgbotResolutionopen => fixed
2015-11-25 15:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f70a7e72efe6e07af355415caeee30c32be0bbd8 [^]
2015-11-25 15:36vmromanosNote Added: 0082333
2015-11-25 15:37vmromanosReview Assigned To => psanjuan
2015-11-26 00:59hudsonbotCheckin
2015-11-26 00:59hudsonbotNote Added: 0082353
2015-11-26 18:49hgbotCheckin
2015-11-26 18:49hgbotNote Added: 0082385
2015-11-26 18:49hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f70a7e72efe6e07af355415caeee30c32be0bbd8 [^] => http://code.openbravo.com/erp/mods/org.openbravo.module.cashvat/rev/6108e841c7231c2d277b2fddbbcf047b240c81f1 [^]
2015-11-27 08:52psanjuanNote Added: 0082393
2015-11-27 08:52psanjuanStatusresolved => closed
2015-12-09 14:11psanjuanRelationship addedcauses 0031644
2015-12-09 14:12psanjuanRelationship addedcauses 0027942
2015-12-14 10:24vmromanosRelationship addedrelated to 0031699
2015-12-15 18:04ngarciaIssue Monitored: ngarcia

Notes
(0081446)
psanjuan   
2015-11-03 12:08   
For additional information (In Spanish) review url below:
(0082323)
psanjuan   
2015-11-25 13:49   
Verified. See test cases created in Test Link under Cash VAT folder// Manual Cash VAT Settlement.
(0082332)
hgbot   
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   
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   
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   
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   
2015-11-27 08:52   
Issue can be closed.