Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037195Localization Pack: SpainAEAT 390public2017-10-31 10:582020-01-27 12:33
Reporterngarcia 
Assigned ToTriage Finance 
PriorityhighSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0037195: Tax parameter required for Bases del IVA soportado no deducible (casilla 232)
DescriptionTax parameter required for Bases del IVA soportado no deducible (casilla 232)
Steps To ReproduceB/A
Proposed SolutionA new 390 tax parameter needs to be created named

This new parameter will be there and should work only for those Purchase VAT rates configured as TAX NOT Deductible = Yes.

In those case the amount to take must be the "Tax Base Amount". This amount needs to be allocated in box 232 of 390 tax form.

Scenario 1 - Parent tax rate set as tax not deductible

Scenario 2 - Children tax rate seta as tax not deductible


(In Spanish):

Nombre del parámetro
Search Key = TAXBASE_NODEDUCT
Name = Bases imponibles del IVA soportado no deducible

que debe crearse dentro del tax report grupo "Operaciones específicas"

Type = output
Modelo 390 casilla = 232
Modelo 390 : Elemento del fichero XML - por definir


Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-10-31 10:58ngarciaNew Issue
2017-10-31 10:58ngarciaAssigned To => Triage Finance
2017-10-31 10:58ngarciaIssue Monitored: networkb
2017-10-31 14:41psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16213#r16213
2017-10-31 14:41psanjuanProposed Solution updated
2017-12-12 17:23psanjuanProposed Solution updated
2017-12-12 17:23psanjuanProposed Solution updated
2017-12-12 17:26psanjuanProposed Solution updated
2017-12-12 17:37psanjuanProposed Solution updated
2017-12-12 17:39psanjuanProposed Solution updated
2017-12-18 10:51imonferrerNote Added: 0101092
2017-12-18 15:54vmromanosStatusnew => scheduled
2017-12-18 17:04hgbotCheckin
2017-12-18 17:04hgbotNote Added: 0101104
2017-12-18 17:04hgbotStatusscheduled => resolved
2017-12-18 17:04hgbotResolutionopen => fixed
2017-12-18 17:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/c14dd8d1c547b41abcb99d374d70b3f18ff8b7d1 [^]
2017-12-18 17:04hgbotCheckin
2017-12-18 17:04hgbotNote Added: 0101105
2017-12-18 17:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/c14dd8d1c547b41abcb99d374d70b3f18ff8b7d1 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/b60534c4e56f7cc7f27009d60bdcdbcc31799737 [^]
2017-12-18 17:04hgbotCheckin
2017-12-18 17:04hgbotNote Added: 0101106
2017-12-18 17:06vmromanosNote Added: 0101107
2017-12-18 17:06vmromanosStatusresolved => new
2017-12-18 17:06vmromanosResolutionfixed => open
2018-01-26 14:04hgbotCheckin
2018-01-26 14:04hgbotNote Added: 0101988
2018-01-26 14:04hgbotStatusnew => resolved
2018-01-26 14:04hgbotResolutionopen => fixed
2018-01-26 14:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/b60534c4e56f7cc7f27009d60bdcdbcc31799737 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/c9a926faee9af4c6af3e1e9d10a21e0bea698a6d [^]
2018-01-26 14:04hgbotCheckin
2018-01-26 14:04hgbotNote Added: 0101989
2018-01-26 14:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/c9a926faee9af4c6af3e1e9d10a21e0bea698a6d [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/e4ac83674d0beaff2cf2c396b78c4341003b9bba [^]
2018-01-26 14:04hgbotCheckin
2018-01-26 14:04hgbotNote Added: 0101990
2018-01-26 14:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/e4ac83674d0beaff2cf2c396b78c4341003b9bba [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/9b10a1c93380f93656053120bbdc771ae8734cfa [^]
2018-01-26 14:04hgbotCheckin
2018-01-26 14:04hgbotNote Added: 0101993
2018-01-26 14:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/9b10a1c93380f93656053120bbdc771ae8734cfa [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.cashvat.es/rev/27cd14e63f69a30ab72229f87aba5f3ee1966b2a [^]
2018-01-26 14:04hgbotCheckin
2018-01-26 14:04hgbotNote Added: 0101994
2018-01-26 14:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.cashvat.es/rev/27cd14e63f69a30ab72229f87aba5f3ee1966b2a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.cashvat.es/rev/7d23e9623869fb033b95c4b62f21b8196913ddc6 [^]
2018-01-26 14:05vmromanosNote Added: 0101997
2018-01-26 14:05vmromanosStatusresolved => new
2018-01-26 14:05vmromanosResolutionfixed => open
2020-01-20 16:53PracticsIssue Monitored: Practics
2020-01-27 11:37psanjuanNote Added: 0117261
2020-01-27 12:32psanjuanTypedefect => feature request
2020-01-27 12:32psanjuanNote Deleted: 0117261
2020-01-27 12:33psanjuanNote Added: 0117263
2020-01-27 12:34psanjuanNote Edited: 0117263bug_revision_view_page.php?bugnote_id=0117263#r20239

Notes
(0101092)
imonferrer   
2017-12-18 10:51   
1. Apply the new dataset to any organization
2. Go to Tax Report window
3. Verify a new record for 2017 year is available
4. Go to group SPECIFIC_OPERATIONS
5. Create parameter TAXBASE_NODEDUCT
6. Go lo linked items. Verify only tax rates set as TAX NOT Deductible = Yes are shown
7. Go to Tax Rate window
8. Filter by TAX NOT Deductible = Yes
9. Verify all the records are linked to new parameter TAXBASE_NODEDUCT
(0101104)
hgbot   
2017-12-18 17:04   
Repository: erp/pmods/org.openbravo.module.aeat390.es
Changeset: c14dd8d1c547b41abcb99d374d70b3f18ff8b7d1
Author: imonferrer <imonferrer <at> opentix.es>
Date: Fri Dec 15 11:49:36 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/c14dd8d1c547b41abcb99d374d70b3f18ff8b7d1 [^]

Fixed bug 37195: New Tax parameter Bases del IVA soportado no deducible [232]

---
M referencedata/standard/390_Report_Tax_Parameters.xml
M src-db/database/model/modifiedTables/AD_ORGINFO.xml
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_DATASET.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_FIELDGROUP.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
---
(0101105)
hgbot   
2017-12-18 17:04   
Repository: erp/pmods/org.openbravo.module.aeat390.es
Changeset: b60534c4e56f7cc7f27009d60bdcdbcc31799737
Author: imonferrer <imonferrer <at> opentix.es>
Date: Mon Dec 18 10:12:38 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/b60534c4e56f7cc7f27009d60bdcdbcc31799737 [^]

Fixed bug 37195: New tax parameter 'Bases del IVA soportado no deducible'
This new parameter is linked to Purchase VAT rates configured as TAX NOT Deductible = Yes

---
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_DATASET.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_FIELDGROUP.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
---
(0101106)
hgbot   
2017-12-18 17:04   
Repository: erp/pmods/org.openbravo.module.aeat390.es
Changeset: 292de10b97a95d4f7355f9b5c377366658f725e9
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Dec 18 17:03:33 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/292de10b97a95d4f7355f9b5c377366658f725e9 [^]

Related to issue 37195: Reverted brackets deletion in constraint
Reverted this automatic change to make it easier to read the check constraints

---
M src-db/database/model/modifiedTables/AD_ORGINFO.xml
---
(0101107)
vmromanos   
2017-12-18 17:06   
Pending to link the new parameter with the tax rates
(0101988)
hgbot   
2018-01-26 14:04   
Repository: erp/pmods/org.openbravo.module.aeat390.es
Changeset: c9a926faee9af4c6af3e1e9d10a21e0bea698a6d
Author: imonferrer <imonferrer <at> opentix.es>
Date: Fri Jan 26 11:56:37 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/c9a926faee9af4c6af3e1e9d10a21e0bea698a6d [^]

Fixed 37195: Tax parameter required for Bases del IVA soportado no deducible
Created new tax report, tax report groups, tax report parameters and tax parameters for 2017

---
M referencedata/standard/390_Report_Tax_Parameters.xml
M src-db/database/sourcedata/AD_DATASET.xml
M src-db/database/sourcedata/AD_MODULE.xml
---
(0101989)
hgbot   
2018-01-26 14:04   
Repository: erp/pmods/org.openbravo.module.aeat390.es
Changeset: e4ac83674d0beaff2cf2c396b78c4341003b9bba
Author: imonferrer <imonferrer <at> opentix.es>
Date: Fri Jan 26 12:14:35 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/e4ac83674d0beaff2cf2c396b78c4341003b9bba [^]

Fixed 37195: Tax parameter required for Bases del IVA soportado no deducible
Created new Java class for 2017 tax report

---
M referencedata/standard/390_Report_Tax_Parameters.xml
M src-db/database/sourcedata/AD_DATASET.xml
A src/org/openbravo/module/aeat390/es/v2017/report/AEAT390Report2017.java
---
(0101990)
hgbot   
2018-01-26 14:04   
Repository: erp/pmods/org.openbravo.module.aeat390.es
Changeset: 9b10a1c93380f93656053120bbdc771ae8734cfa
Author: imonferrer <imonferrer <at> opentix.es>
Date: Fri Jan 26 12:36:15 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.es/rev/9b10a1c93380f93656053120bbdc771ae8734cfa [^]

Fixed 37195: Tax parameter required for Bases del IVA soportado no deducible
Correct change in the module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0101993)
hgbot   
2018-01-26 14:04   
Repository: erp/pmods/org.openbravo.module.aeat390.cashvat.es
Changeset: 27cd14e63f69a30ab72229f87aba5f3ee1966b2a
Author: imonferrer <imonferrer <at> opentix.es>
Date: Fri Jan 26 12:03:03 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.cashvat.es/rev/27cd14e63f69a30ab72229f87aba5f3ee1966b2a [^]

fixed 37195: Tax parameter required for Bases del IVA soportado no deducible
Created new cashvat tax parameters

---
M referencedata/standard/390_Cash_VAT_Report_Tax_Parameters.xml
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
---
(0101994)
hgbot   
2018-01-26 14:04   
Repository: erp/pmods/org.openbravo.module.aeat390.cashvat.es
Changeset: 7d23e9623869fb033b95c4b62f21b8196913ddc6
Author: imonferrer <imonferrer <at> opentix.es>
Date: Fri Jan 26 12:41:49 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat390.cashvat.es/rev/7d23e9623869fb033b95c4b62f21b8196913ddc6 [^]

Fixed 37195: Tax parameter required for Bases del IVA soportado no deducible
Correct change in the module version

---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0101997)
vmromanos   
2018-01-26 14:05   
Reopened as the solution was not properly implemented
(0117263)
psanjuan   
2020-01-27 12:33   
(edited on: 2020-01-27 12:34)
This issue is not a defect but a FR now, because it is about including a new parameter that automatically calculates a value which now can be included by the end-user manually at the time of launching Modelo 390.

For this to behave it is not just including a new tax parameter but some java logic is required to be implemented. FR on hold as by now.