Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028750Localization Pack: SpainAEAT 390public2015-01-23 12:512015-11-13 10:56
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
Summary0028750: It should be possible to launch 390 tax form for an Organization having a Fiscal Calendar defined from i.e. July to June
DescriptionIt should be possible to launch 390 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 caledar as Organization calendar by default.
Define also another calendar 2015 with periods from January 15 to December 15
Do the same for 2016.
Install 390 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. Configure this caledar as Organization calendar by default.
Define also another calendar 2015 with periods from January 15 to December 15
Do the same for 2016.
Install 390 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 390 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:51psanjuanNew Issue
2015-01-23 12:51psanjuanOBNetwork customer => No
2015-01-23 12:51psanjuanRelationship addedcaused by 0028749
2015-01-23 12:51psanjuanRelationship deletedcaused by 0028749
2015-01-23 12:52psanjuanRelationship addedcaused by 0028040
2015-02-26 12:22psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=7780#r7780
2015-02-26 12:22psanjuanProposed Solution updated
2015-02-26 12:24psanjuanAssigned To => psanjuan
2015-10-08 16:23vmromanosStatusnew => scheduled
2015-10-08 16:23vmromanosAssigned Topsanjuan => vmromanos
2015-10-08 17:03hgbotCheckin
2015-10-08 17:03hgbotNote Added: 0080898
2015-10-08 17:03hgbotStatusscheduled => resolved
2015-10-08 17:03hgbotResolutionopen => fixed
2015-10-08 17:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/906a4cc31d6ed64cdbf1365b3804158f81db9760 [^]
2015-10-08 17:05hgbotCheckin
2015-10-08 17:05hgbotNote Added: 0080899
2015-11-13 09:36psanjuanNote Added: 0081804
2015-11-13 09:39psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10202
2015-11-13 09:40psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10203
2015-11-13 10:14psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10208
2015-11-13 10:31psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10209
2015-11-13 10:32psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10210
2015-11-13 10:54psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10211
2015-11-13 10:55psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10212
2015-11-13 10:55psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10213
2015-11-13 10:56psanjuanStatusresolved => closed
2015-11-13 10:58psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10214
2015-11-13 11:52psanjuanNote Edited: 0081804bug_revision_view_page.php?bugnote_id=0081804#r10227

Notes
(0080898)
hgbot   
2015-10-08 17:03   
Repository: erp/pmods/org.openbravo.module.aeat390.es
Changeset: 906a4cc31d6ed64cdbf1365b3804158f81db9760
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Oct 08 17:00:14 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/906a4cc31d6ed64cdbf1365b3804158f81db9760 [^]

Fixed issue 28750: 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_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0080899)
hgbot   
2015-10-08 17:05   
Repository: erp/pmods/org.openbravo.module.aeat390.cashvat.es
Changeset: da58dc458edfdc375d15856a3ede9bd15adca753
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Oct 08 17:01:22 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.cashvat.es/rev/da58dc458edfdc375d15856a3ede9bd15adca753 [^]

Related to issue 28750: Increased major dependency for AEAT 390 3.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
---
(0081804)
psanjuan   
2015-11-13 09:36   
(edited on: 2015-11-13 11:52)
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, besides a default Activity assigned in the "Actividades del IAE" tab.

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 390 tax form module, apply 390 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 = 10.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=10.00
Tax Amount=2.10

Go to Tax Report Launcher window and enter/select below data:
Organization = Fiscal Calendar Org
Report = Modelo 390 v2014 - Declaración Anual del IVA
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 csv file generated. Verify it is empty.

Test Case 2

Go to sales invoice and create a new one date January 2014 for a net amount = 20.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=20.00
Tax Amount=4.20

Go to sales invoice and create a new one date February 2014 for a net amount = 30.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=30.00
Tax Amount=6.30

Go to sales invoice and create a new one date March 2014 for a net amount = 40.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=40.00
Tax Amount=8.40

Go to sales invoice and create a new one date April 2014 for a net amount = 50.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=50.00
Tax Amount=10.50

Go to sales invoice and create a new one date May 2014 for a net amount = 60.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=60.00
Tax Amount=12.60

Go to sales invoice and create a new one date June 2014 for a net amount = 70.00. Make sure that the tax rate selected is "Entregas IVA 21%. Complete and Post the invoice.
Tax Base Amount=70.00
Tax Amount=14.70

Go to sales invoice and create a new one date July 2014 for a net amount = 80.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=80.00
Tax Amount=16.80

Go to sales invoice and create a new one date August 2014 for a net amount = 90.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=90.00
Tax Amount=18.90

Go to sales invoice and create a new one date September 2014 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

Go to sales invoice and create a new one date October 2014 for a net amount = 110.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=110.00
Tax Amount=23.10

Go to sales invoice and create a new one date November 2014 for a net amount = 120.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=120.00
Tax Amount=25.20

Go to sales invoice and create a new one date December 2014 for a net amount = 130.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=130.00
Tax Amount=27.30

Go to sales invoice and create a new one date January 2015 for a net amount = 140.00. Make sure that the tax rate selected is "Entregas IVA 21%". Complete and Post the invoice.
Tax Base Amount=140.00
Tax Amount=29.40

Total Tax Base Amount (2014) = 900.00
Total Tax Amount (2014) = 189.00

Go to Tax Report Launcher window and enter/select below data:
Organization = Fiscal Calendar Org
Report = Modelo 390 v2014 - Declaración Anual del IVA
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 csv file generated. Verify it has the 12 invoices dated on 2014.

Open XML file. Verify below data:

<RegGeneral>
        <BaseImponibleyCuota>
            <RegOrdinario>
                <Tipo21>
                    <BI>900.00</BI>
                    <Cuota>189.00</Cuota>
                </Tipo21>
            </RegOrdinario>
            <TotalBasesyCuotasIVA>
                <TipoX>
                    <BI>900.00</BI>
                    <Cuota>189.00</Cuota>
                </TipoX>
            </TotalBasesyCuotasIVA>
            <TotalCuotasIVA>189.00</TotalCuotasIVA>
        </BaseImponibleyCuota>
        <Deducciones>
            <SumDeducciones>0</SumDeducciones>
        </Deducciones>
        <ResRegGeneral>189.00</ResRegGeneral>
    </RegGeneral>
    <LiqAnual>
        <SumResultados>189.00</SumResultados>
        <ResLiquidacion>189.00</ResLiquidacion>
    </LiqAnual>
    <ResLiquidaciones>
        <PerNoRegGrupos/>
    </ResLiquidaciones>
    <VolOperaciones>
        <OpRegGeneral>900.00</OpRegGeneral>
        <TotalVolOp>900.00</TotalVolOp>
    </VolOperaciones>

Test Plan above verified. Issue can be closed.