Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0019911
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Tax Report Launchermajoralways2012-02-29 10:332012-03-30 12:13
ReporterjecharriView Statuspublic 
Assigned Tojecharri 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision454da4d68bb9
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0019911: The Process Info.Conta.Impuestos is not working properly

DescriptionWhen you have taxes defined in * level for different entities, this process add extra information to all taxes.

For one tax for entity 2 and defined in *, we will have information in c_tax_acct table about this tax and entity one accounting schema.
Steps To Reproduce-Go to enterprise module management and apply to * the dataset of module taxes.
-Create 2 entities, both with accounting schema.
-Create one organization (legal with accounting) with accounting schema in both entities.
-create taxes for 2 entities as * level.

Run the process "Info.Cont.Impuestos" as * level and entity 1.
Yo will see that taxes for entity 2 are added to c_tax_acct with entity one accounting schema information.
Proposed SolutionInside the pl, change SELECT * FROM C_TAX T WHERE T.AD_ORG_ID = v_Org for

SELECT * FROM C_TAX T WHERE T.AD_ORG_ID = v_Org and t.ad_client_id=v_Client
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate defect 0019970 closedjonalegriaesarte Localization Pack: Spain to run the process info.conta.impuestos, the accounting is generated to all taxed, included other entities taxes 

-  Notes
(0046442)
hgbot (developer)
2012-03-15 10:52

Repository: erp/mods/org.openbravo.localization.spain.referencedata.taxes
Changeset: 454da4d68bb9628b697319bd0011513a366ce813
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Mar 15 10:44:22 2012 +0100
URL: http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/454da4d68bb9628b697319bd0011513a366ce813 [^]

Fixes issue 19911: The Process Info.Conta.Impuestos is not working properly.
The problem was that one query was not cosidering the client when it was taking the taxes

---
M src-db/database/model/functions/ESTAX_ACCOUNTING_TAB.xml
---
(0046491)
jecharri (developer)
2012-03-16 09:13

Test cases:
-it is enough with steps to reproduce.

Apart from that, and easier example is to have two clients:
-create tax-rates in both.
-apply to one of them the dataset of module "taxes configuration for spain" at * level.
-after that run the process "Info.Conta.Impuestos" and verifie that the tax of the other client is not in the table C_Tax_Acct
(0046968)
ioritzCia (developer)
2012-03-30 12:13

Verified.

- Issue History
Date Modified Username Field Change
2012-02-29 10:33 jecharri New Issue
2012-02-29 10:33 jecharri Assigned To => vmromanos
2012-02-29 10:33 jecharri Modules => Core
2012-02-29 10:33 jecharri Resolution time => 1333836000
2012-02-29 12:01 jecharri Steps to Reproduce Updated View Revisions
2012-03-02 17:30 eduardo_Argal Assigned To vmromanos => jonalegriaesarte
2012-03-06 18:06 jonalegriaesarte Assigned To jonalegriaesarte => jecharri
2012-03-15 10:52 hgbot Checkin
2012-03-15 10:52 hgbot Note Added: 0046442
2012-03-15 10:52 hgbot Status new => resolved
2012-03-15 10:52 hgbot Resolution open => fixed
2012-03-15 10:52 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.taxes/rev/454da4d68bb9628b697319bd0011513a366ce813 [^]
2012-03-16 09:13 jecharri Note Added: 0046491
2012-03-16 09:31 maite Relationship added has duplicate 0019970
2012-03-30 10:41 jonalegriaesarte Project Openbravo ERP => Modules
2012-03-30 10:42 jonalegriaesarte Category 09. Financial management => Tax Report Launcher
2012-03-30 10:42 jonalegriaesarte version pi =>
2012-03-30 10:42 jonalegriaesarte Target Version 3.0MP10 =>
2012-03-30 12:13 ioritzCia Note Added: 0046968
2012-03-30 12:13 ioritzCia Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker