Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
0030589Localization Pack: SpainAEAT 303public2015-08-17 11:192015-09-28 14:05
psanjuan 
jonalegriaesarte 
highminoralways
newopen 
20Ubuntu 8.04.1
 
 
0030589: There should be an automatic process that somehow fills in 303 tax form parameter "Cuotas a compensar de periodos anteriores"
There should be an automatic process that somehow fills in 303 tax form parameter "Cuotas a compensar de periodos anteriores" if applicable.
Install the module "Tax Report: Modelo 303 (Spain)"

Apply 303 tax form dataset to F&B España organization.

Dated on August 2015 make sure there is no sales invoice booked and post for any Spanish customer

Dated on August 2015 make sure there are 4 invoices, invoices 671, 695, 683, 674 and 670 all of them for Bebidas Alegres supplier and below data each:
Tax rate = Adquisiciones IVA 21%
Taxable Amount = 1000.00 €
Tax Amount = 210.00

Therefore dated on Augut 2015 total purchase VAT taxable amount = 4000.00 and total deductible purchase Tax Amount = 840

Navigate to the Tax Report Launcher and select below data:

Organization = F&B España
Report = Modelo 303 2015 - Autoliquidación Mensual del IVA
Year = 2015
Period = Ago-15

Press input parameters and enter below data:
Nombre del fichero = Agosto_2015
Compensación = check this parameter
Atribuible a la Administración del Estado % = 100

Press "Generate Electronic File"

Import the generated file in this link: https://www.agenciatributaria.gob.es/AEAT.sede/procedimientoini/G414.shtml [^]

See below image.

There is no Sales VAT (IVA Devengado), but only Purchase VAT (IVA Deducible) set as "A compensar" for an amount = 840.00 €

Dated on September 2015, make sure you do not have any purchase invoice booked and post for any Spanish supplier but below sales invoice:

Organization = F&B España
Business Partner = Hoteles Buenas Noches
Invoice date / Accounting date = 21-09-2015
Product = Agua sin Gas
Invoice Quantity = 1880
Complete and post the invoice, therefore Sales Tax Amount = 604.04


Navigate to the Tax Report Launcher and select below data:

Organization = F&B España
Report = Modelo 303 2015 - Autoliquidación Mensual del IVA
Year = 2015
Period = Sep-15

Press input parameters and enter below data:
Nombre del fichero = Sept_2015
Compensar = check this parameter
Atribuible a la Administración del Estado % = 100
Cuotas a compensar de periodos anteriores = 840, as currently there is no way to automatically get that value from previous period 303 tax report.

Press "Generate Electronic File"

Import the generated file in this link: https://www.agenciatributaria.gob.es/AEAT.sede/procedimientoini/G414.shtml [^]

See below image.

840 € are shown in 303 tax form box [67], therefore total tax amount to settle decreases from 604.04 to -235.96
Negative amounts calculated for a given period should be retrieved somehow in the field "Cuotas a compensar de periodos anteriores" for the next period.

It is important to take into account that 303 tax form periodicity can be monthly and quarterly.

Besides that, it is important to remark that this behaviour is correct whenever the parameter "Inscrito en el Registro de devolución mensual" is NOT checked, same as "Devolución" parameter.
No tags attached.
related to feature request 0029158 new psanjuan "saldos a compensar" parameter needs to be automatically calculated for 303 
txt Agosto2015.txt (2,848) 2015-08-18 11:32
https://issues.openbravo.com/file_download.php?file_id=8369&type=bug
txt Septiembre2015.txt (2,848) 2015-08-18 11:32
https://issues.openbravo.com/file_download.php?file_id=8370&type=bug
? 30589_1.bmp (2,121,534) 2015-08-18 11:34
https://issues.openbravo.com/file_download.php?file_id=8371&type=bug
? 30589_2.bmp (2,603,578) 2015-08-18 11:34
https://issues.openbravo.com/file_download.php?file_id=8372&type=bug
Issue History
2015-08-17 11:19psanjuanNew Issue
2015-08-17 11:19psanjuanAssigned To => jonalegriaesarte
2015-08-18 09:47psanjuanSummaryThere should be an automatic process that fills in 303 tax form parameter "Cuotas a compensar de periodos anteriores" => There should be an automatic process that somehow fills in 303 tax form parameter "Cuotas a compensar de periodos anteriores"
2015-08-18 09:47psanjuanDescription Updatedbug_revision_view_page.php?rev_id=9216#r9216
2015-08-18 09:47psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9218#r9218
2015-08-18 10:03psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9219#r9219
2015-08-18 10:35psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9220#r9220
2015-08-18 11:31psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9221#r9221
2015-08-18 11:32psanjuanFile Added: Agosto2015.txt
2015-08-18 11:32psanjuanFile Added: Septiembre2015.txt
2015-08-18 11:34psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9222#r9222
2015-08-18 11:34psanjuanFile Added: 30589_1.bmp
2015-08-18 11:34psanjuanFile Added: 30589_2.bmp
2015-08-18 12:09psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9223#r9223
2015-08-18 12:09psanjuanProposed Solution updated
2015-08-18 12:10psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9224#r9224
2015-09-28 14:05psanjuanRelationship addedrelated to 0029158

There are no notes attached to this issue.