Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028749Localization Pack: SpainAEAT 190public2015-01-23 12:412015-11-13 13:06
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
Summary0028749: It should be possible to launch 190 tax form for an Organization having a Fiscal Calendar defined from i.e. July to June
DescriptionIt should be possible to launch 190 tax form for an Organization having a Fiscal Calendar defined from i.e. July to June.
Steps To ReproduceAccess to fiscal calendar and define year 2015-2016 with periods from July 15 to June 16. Configure this calendar as Organization calendar by default.
Define also another calendar 2015 with periods from January 15 to December 15
Do the same for 2016.
Install 190 tax form module.
Navigate to tax report launcher and realize that Fiscal Calendar is not editable, therefore fiscal calendar from January 15 to December 15 can not be selected.
Proposed SolutionAccess to fiscal calendar and define year 2015-2016 with periods from July 15 to June 16
Define also another calendar 2015 with periods from January 15 to December 15
Do the same for 2016.
Install 190 tax form module.
Navigate to tax report launcher and realize that Fiscal Calendar is editable, therefore a fiscal calendar can be selected, regardless only one fiscal calendar can be assigned to the Organization.

Select the calendar starting from January to December.

Verify that the data contained in 190 tax form is correct
Additional Information
TagsNo tags attached.
Relationships
caused by design defect 0028040 closed vmromanos Modules It is not possible to obtain proper AEAT reports with Fiscal Calendar defined from July to June 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-01-23 12:41psanjuanNew Issue
2015-01-23 12:41psanjuanAssigned To => vmromanos
2015-01-23 12:41psanjuanOBNetwork customer => No
2015-01-23 12:45psanjuanRelationship addedcaused by 0028040
2015-01-23 12:51psanjuanRelationship addedcauses 0028750
2015-01-23 12:51psanjuanRelationship deletedcauses 0028750
2015-02-26 12:20psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=7778#r7778
2015-02-26 12:20psanjuanProposed Solution updated
2015-02-26 12:23psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=7783#r7783
2015-10-08 10:59vmromanosStatusnew => scheduled
2015-10-08 11:26hgbotCheckin
2015-10-08 11:26hgbotNote Added: 0080882
2015-10-08 11:26hgbotStatusscheduled => resolved
2015-10-08 11:26hgbotResolutionopen => fixed
2015-10-08 11:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat190.es/rev/2d486e5f7c798ba97b0ce02f3c674ac1a9a978f4 [^]
2015-10-08 11:26hgbotCheckin
2015-10-08 11:26hgbotNote Added: 0080883
2015-10-28 10:09dmitry_mezentsevNote Added: 0081374
2015-11-13 11:46psanjuanNote Added: 0081820
2015-11-13 11:50psanjuanNote Edited: 0081820bug_revision_view_page.php?bugnote_id=0081820#r10224
2015-11-13 11:56psanjuanNote Edited: 0081820bug_revision_view_page.php?bugnote_id=0081820#r10229
2015-11-13 12:04psanjuanNote Edited: 0081820bug_revision_view_page.php?bugnote_id=0081820#r10230
2015-11-13 12:07psanjuanNote Edited: 0081820bug_revision_view_page.php?bugnote_id=0081820#r10231
2015-11-13 12:10psanjuanNote Edited: 0081820bug_revision_view_page.php?bugnote_id=0081820#r10232
2015-11-13 12:51psanjuanNote Edited: 0081820bug_revision_view_page.php?bugnote_id=0081820#r10233
2015-11-13 12:59psanjuanNote Edited: 0081820bug_revision_view_page.php?bugnote_id=0081820#r10234
2015-11-13 13:03psanjuanNote Edited: 0081820bug_revision_view_page.php?bugnote_id=0081820#r10235
2015-11-13 13:04psanjuanNote Edited: 0081820bug_revision_view_page.php?bugnote_id=0081820#r10236
2015-11-13 13:06psanjuanStatusresolved => closed

Notes
(0080882)
hgbot   
2015-10-08 11:26   
Repository: erp/pmods/org.openbravo.module.aeat190.es
Changeset: 2d486e5f7c798ba97b0ce02f3c674ac1a9a978f4
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Oct 08 11:23:04 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat190.es/rev/2d486e5f7c798ba97b0ce02f3c674ac1a9a978f4 [^]

Fixed bug 28749: Increased major dependency to Tax Report Launcher 1.1.0

The code already supports the posibility of selecting a calendar different from the Organization's one, so no change required.

---
M src-db/database/sourcedata/AD_DATASET.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0080883)
hgbot   
2015-10-08 11:26   
Repository: erp/pmods/org.openbravo.module.aeat190.cashvat.es
Changeset: bee586198198164368cadc630e5d7451e200ac1f
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Oct 08 11:23:50 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat190.cashvat.es/rev/bee586198198164368cadc630e5d7451e200ac1f [^]

Related to issue 28749: Increased major dependency for AEAT 190 3.4.0

---
M src-db/database/sourcedata/AD_DATASET.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0081374)
dmitry_mezentsev   
2015-10-28 10:09   
Not closed for 20 days!
The same for 28750, 28751, 29074, 29075.
(0081820)
psanjuan   
2015-11-13 11:46   
(edited on: 2015-11-13 13:04)
Test Plan

Pre-requisites:

All test done for a new organization named "Fiscal Calendar" which do have related a fiscal calendar named "Fiscal Calendar June_May" for which three years have been created:
2013 - this year has periods from June 2013 to May 2014
2014 - this year has periods from June 2014 to May 2015
2015 - this year has periods from June 2015 to May 2016

Make sure, all these periods are opened, and the Organization has this fiscal calendar assigned in the Organization window.
Make sure there is a contact person configured for the Organization in the organization window, Information tab.
The contact person selected needs to have a phone number.

Go to Fiscal Calendar window and create another calendar named "Fiscal Calendar Jan-Dec" which do also have below two years:
2013 - this year has periods from January 2013 to December 2013
2014 - this year has periods from January 2014 to December 2014
2015 - this year has periods from January 2015 to December 2015

After installing 190 tax form module, apply 190 dataset to Fiscal Calendar organization.

Make sure Spanish tax rates are also applied.

Create a service related to "IVA Normal Servicios" tax category and a purchase price list.
Create a supplier type business partner named "Professional A" located in Spain (do not forget to add an Spanish "Provincia"), related to "Business Partner Tax Category" = Servicios Profesionales Normal.

Test Case 1

Go to purchase invoice and create a new one dated on Dec 2013 for the BP and the service product for a net amount = 100.00. Make sure that the tax rate selected is "Prestación servicios nacional 21% -21%R".
Complete and Post the invoice.
Tax Base Amount=100.00
Tax Amount=21.00
Witholding Amount = -21.00

Pay the invoice dated on Dec 2013.

Go to Tax Report Launcher window and enter/select below data:
Organization = Fiscal Calendar Org
Report = Modelo 190
Calendar = Fiscal Calendar Jan-Dec
Year = 2014
Period = Anually.

Launch the report by just entering a file name in the "Tax Report Launcher Input Parameters". Open the txt file and verify it is empty.

Test Case 2

Go to purchase invoice and create a new one dated on Dec 2013 for the BP and the service product for a net amount = 150.00. Make sure that the tax rate selected is "Prestación servicios nacional 21% -21%R".
Complete and Post the invoice.
Tax Base Amount=150.00
Tax Amount=21.00
Witholding Amount = -21.00

Pay the invoice dated on Jan 2014.

Go to Tax Report Launcher window and enter/select below data:
Organization = Fiscal Calendar Org
Report = Modelo 190
Calendar = Fiscal Calendar Jan-Dec
Year = 2014
Period = Anually.

Launch the report by just entering a file name in the "Tax Report Launcher Input Parameters". Open the txt file and verify below data after importing the file in Informativas:

BP = Professional A
Ejercicio Devengo = 2013
Provincia = Navarra
Clave = G
Subclave = 01
Percepciones integras = 150.00
Retenciones = 31.50

Test Case 3

Go to purchase invoice and create a new one dated on March 2014 for the BP and the service product for a net amount = 400.00. Make sure that the tax rate selected is "Prestación servicios nacional 21% -21%R".
Complete and Post the invoice.
Tax Base Amount=400.00
Tax Amount=84.00
Witholding Amount = -84.00

Pay the invoice dated on April 2014.


Go to Tax Report Launcher window and enter/select below data:
Organization = Fiscal Calendar Org
Report = Modelo 190
Calendar = Fiscal Calendar Jan-Dec
Year = 2014
Period = Anually.

Launch the report by just entering a file name in the "Tax Report Launcher Input Parameters". Open the txt file and verify below data after importing the file in Informativas:

Record 1
BP = Professional A
Ejercicio Devengo = 2013
Provincia = Navarra
Clave = G
Subclave = 01
Percepciones integras = 150.00
Retenciones = 31.50

Record 2
BP = Professional A
Ejercicio Devengo =
Provincia = Navarra
Clave = G
Subclave = 01
Percepciones integras = 400.00
Retenciones = 84.00

Test Case 4

Go to purchase invoice and create a new one dated on June 2014 for the BP and the service product for a net amount = 500.00. Make sure that the tax rate selected is "Prestación servicios nacional 21% -21%R".
Complete and Post the invoice.
Tax Base Amount=500.00
Tax Amount=105
Witholding Amount = -105

Pay the invoice on June 2014.

Go to purchase invoice and create a new one dated on January 2015 for the BP and the service product for a net amount = 600.00. Make sure that the tax rate selected is "Prestación servicios nacional 21% -21%R".
Complete and Post the invoice.
Tax Base Amount=600.00
Tax Amount=126
Witholding Amount = -126

Pay the invoice on January 2015.


Go to Tax Report Launcher widow and enter/select below data:
Organization = Fiscal Calendar Org
Report = Modelo 190
Calendar = Fiscal Calendar Jan-Dec
Year = 2014
Period = Anually.

Launch the report by just entering a file name in the "Tax Report Launcher Input Parameters". Open the txt file and verify below data after importing the file in Informativas:

Record 1
BP = Professional A
Ejercicio Devengo = 2013
Provincia = Navarra
Clave = G
Subclave = 01
Percepciones integras = 150.00
Retenciones = 31.50

Record 2
BP = Professional A
Ejercicio Devengo =
Provincia = Navarra
Clave = G
Subclave = 01
Percepciones integras = 900.00
Retenciones = 189.00


Test Case 5

Go to purchase invoice and create a new one dated on December 2014 for the BP and the service product for a net amount = 500.00. Make sure that the tax rate selected is "Prestación servicios nacional 21% -21%R".
Complete and Post the invoice.
Tax Base Amount=700.00
Tax Amount= 147.00
Witholding Amount = -147.00

Pay the invoice on January 2015.

Go to Tax Report Launcher widow and enter/select below data:
Organization = Fiscal Calendar Org
Report = Modelo 190
Calendar = Fiscal Calendar Jan-Dec
Year = 2014
Period = Anually.

Launch the report by just entering a file name in the "Tax Report Launcher Input Parameters". Open the txt file and verify below data after importing the file in Informativas:

Record 1
BP = Professional A
Ejercicio Devengo = 2013
Provincia = Navarra
Clave = G
Subclave = 01
Percepciones integras = 150.00
Retenciones = 31.50

Record 2
BP = Professional A
Ejercicio Devengo =
Provincia = Navarra
Clave = G
Subclave = 01
Percepciones integras = 900.00
Retenciones = 189.00


Test Plan above verified.

Issue closed.