Openbravo Issue Tracking System - Localization Pack: Spain |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028751 | Localization Pack: Spain | AEAT 347 | public | 2015-01-23 12:53 | 2015-11-13 11:40 |
|
| Reporter | psanjuan | |
| Assigned To | vmromanos | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Ubuntu 8.04.1 |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | |
| Support ticket | |
| OBNetwork customer | No |
| Regression introduced in release | |
|
| Summary | 0028751: It should be possible to launch 347 tax form for an Organization having a Fiscal Calendar defined from i.e. July to June |
| Description | It should be possible to launch 347 tax form for an Organization having a Fiscal Calendar defined from i.e. July to June |
| Steps To Reproduce | Access 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 347 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 Solution | Access 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 347 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 347 tax form is correct |
| Additional Information | |
| Tags | No 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 | | related to | defect | 0029065 | | closed | vmromanos | Localization Pack: Spain | 347 Year information should be considered from period's information instead of name set in Year window |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2015-01-23 12:53 | psanjuan | New Issue | |
| 2015-01-23 12:53 | psanjuan | Assigned To | => jonalegriaesarte |
| 2015-01-23 12:53 | psanjuan | OBNetwork customer | => No |
| 2015-01-23 12:53 | psanjuan | Relationship added | caused by 0028040 |
| 2015-02-26 12:23 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=7782#r7782 |
| 2015-02-26 12:23 | psanjuan | Proposed Solution updated | |
| 2015-02-26 13:16 | psanjuan | Relationship added | related to 0029065 |
| 2015-10-08 08:55 | vmromanos | Status | new => scheduled |
| 2015-10-08 08:55 | vmromanos | Assigned To | jonalegriaesarte => vmromanos |
| 2015-10-08 10:29 | hgbot | Checkin | |
| 2015-10-08 10:29 | hgbot | Note Added: 0080879 | |
| 2015-10-08 10:29 | hgbot | Status | scheduled => resolved |
| 2015-10-08 10:29 | hgbot | Resolution | open => fixed |
| 2015-10-08 10:29 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat347apr.es/rev/70f5997f70006691563f5ac5ef543b30388ee15d [^] |
| 2015-10-08 10:29 | hgbot | Checkin | |
| 2015-10-08 10:29 | hgbot | Note Added: 0080880 | |
| 2015-11-13 10:58 | psanjuan | Note Added: 0081809 | |
| 2015-11-13 11:00 | psanjuan | Note Edited: 0081809 | bug_revision_view_page.php?bugnote_id=0081809#r10216 |
| 2015-11-13 11:02 | psanjuan | Note Edited: 0081809 | bug_revision_view_page.php?bugnote_id=0081809#r10217 |
| 2015-11-13 11:10 | psanjuan | Note Edited: 0081809 | bug_revision_view_page.php?bugnote_id=0081809#r10218 |
| 2015-11-13 11:11 | psanjuan | Note Edited: 0081809 | bug_revision_view_page.php?bugnote_id=0081809#r10219 |
| 2015-11-13 11:40 | psanjuan | Note Edited: 0081809 | bug_revision_view_page.php?bugnote_id=0081809#r10222 |
| 2015-11-13 11:40 | psanjuan | Status | resolved => closed |
| 2015-11-13 11:53 | psanjuan | Note Edited: 0081809 | bug_revision_view_page.php?bugnote_id=0081809#r10228 |
|
Notes |
|
|
(0080879)
|
|
hgbot
|
|
2015-10-08 10:29
|
|
Repository: erp/pmods/org.openbravo.module.aeat347apr.es
Changeset: 70f5997f70006691563f5ac5ef543b30388ee15d
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Oct 08 10:21:50 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat347apr.es/rev/70f5997f70006691563f5ac5ef543b30388ee15d [^]
Fixed bug 28751: Support for different calendars when launching the report
Reverted latest changes from 0029065, so there is a validation that ensures all the periods of the selected year belong to the same natural year.
The report's queries use the accounting date, so it automatically supports this new feature available in Tax Report Launcher 1.1.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
M src/org/openbravo/module/aeat347apr/es/AEAT347ReportAPR.java
M src/org/openbravo/module/aeat347apr/es/AEAT347ReportAPRDao.java
---
|
|
|
|
(0080880)
|
|
hgbot
|
|
2015-10-08 10:29
|
|
|
|
|
(0081809)
|
|
psanjuan
|
2015-11-13 10:58
(edited on: 2015-11-13 11:53) |
|
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.
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 347 tax form module, apply 347 dataset to Fiscal Calendar organization.
Make sure Spanish tax rates are also applied.
Create a product related to "IVA Normal" tax category and related to a valid sales price list.
Create a customer type business partner named "Customer A" located in Spain.
Test Case 1
Go to sales invoice and create a new one date Dec 2013 for a net amount = 100.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=100.00
Tax Amount=21.00
Go to Tax Report Launcher window and enter/select below data:
Organization = Fiscal Calendar Org
Report = Modelo 347 2014 - Declaración Anual de operaciones con Terceros.
Calendar = Fiscal Calendar Jan-Dec
Year = 2014
Period = Anually.
Launch the report by entering a file name, a contact person and a contact phone. Verify it is empty.
Test Case 2
Go to sales invoice and create a new one date January 2014 for a net amount = 200.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=200.00
Tax Amount=42.0
Go to sales invoice and create a new one date February 2014 for a net amount = 300.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=300.00
Tax Amount=63.0
Go to sales invoice and create a new one date March 2014 for a net amount = 400.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=400.00
Tax Amount=84.0
Go to sales invoice and create a new one date April 2014 for a net amount = 500.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=500.00
Tax Amount=105.0
Go to sales invoice and create a new one date May 2014 for a net amount = 600.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=600.00
Tax Amount=126.0
Go to sales invoice and create a new one date June 2014 for a net amount = 700.00. Make sure that the tax rate selected is "Entregas IVA 21%. Complete and Post the invoice.
Tax Base Amount=700.00
Tax Amount=147.0
Go to sales invoice and create a new one date July 2014 for a net amount = 800.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=800.00
Tax Amount=168.0
Go to sales invoice and create a new one date August 2014 for a net amount = 900.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=900.00
Tax Amount=189.0
Go to sales invoice and create a new one date September 2014 for a net amount = 1000.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=1000.00
Tax Amount=210
Go to sales invoice and create a new one date October 2014 for a net amount = 1100.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=1100.00
Tax Amount=231.0
Go to sales invoice and create a new one date November 2014 for a net amount = 1200.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=1200.00
Tax Amount=252.0
Go to sales invoice and create a new one date December 2014 for a net amount = 1300.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=1300.00
Tax Amount=273.0
Go to sales invoice and create a new one date January 2015 for a net amount = 1400.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=1400.00
Tax Amount=294.0
Total Tax Base Amount (2014) = 9000.00
Total Tax Amount (2014) = 1890.00
Go to Tax Report Launcher window and enter/select below data:
Organization = Fiscal Calendar Org
Report = Modelo 347 2014 - Declaración Anual de operaciones con Terceros.
Calendar = Fiscal Calendar Jan-Dec
Year = 2014
Period = Anually.
Launch the report by entering a file name, a contact person and a contact phone.
Open the csv file generated and verify that it only contains the 12 invoices dated on 2014.
Import the file in Informativas. Verify below data for Customer A
First Quarter Amount = 1089.00
Second Quarter Amount = 2178.00
Third Quarter Amount = 3267.00
Forth Quarter Amount = 4356.00
Test plan above verified. Issue closed.
|
|