Openbravo Issue Tracking System - Localization Pack: Spain | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0020460 | Localization Pack: Spain | Taxes | public | 2012-05-09 18:50 | 2012-07-26 02:42 |
Reporter | VictorVillar | ||||
Assigned To | ioritzCia | ||||
Priority | high | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | OS | 5 | OS Version | ||
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 | |||||
Regression introduced in release | |||||
Summary | 0020460: wrong definition of some taxes in the dataset | ||||
Description | we can see after execute the following query [1] of the DB function c_gettax, that we obtain more than one register, and this is not correct because the only tax that should be appear is 'Ventas exentas', the only one that should be checked as istaxexempt. SELECT t.C_Tax_ID, T.NAME FROM C_Tax t INNER JOIN AD_Org o ON(t.AD_Client_ID = o.AD_Client_ID) WHERE t.ISTAXEXEMPT = 'Y' and t.sopotype ='S' AND o.AD_Org_ID = p_org_id AND t.ValidFrom <= shipdate AND t.isActive = 'Y' ORDER BY t.VALIDFROM DESC We have realised about this behaviour if you configure one Business partner as Exempt and you are doing a sales transaction. Also, this query is not correct because it is necessary to have a where clause with t.sopotype ='S' and t.sopotype ='B' in order to search only the tax sales transactions created by user | ||||
Steps To Reproduce | As group admin role, Configure a BP as exempt and then create a sales order with that BP, in combo taxes we can see more than one register. The only tax which should be appear is "Ventas exentas" | ||||
Proposed Solution | only check as taxexempt "Ventas exentas" in the dataset. Review the query indicated in the Description, add some kind of restriction about sales transaction. | ||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2012-05-09 18:50 | VictorVillar | New Issue | |||
2012-05-09 18:50 | VictorVillar | Assigned To | => jonalegriaesarte | ||
2012-05-09 18:53 | VictorVillar | Issue Monitored: networkb | |||
2012-05-09 19:18 | VictorVillar | Description Updated | bug_revision_view_page.php?rev_id=3441#r3441 | ||
2012-06-07 12:34 | jonalegriaesarte | Assigned To | jonalegriaesarte => ioritzCia | ||
2012-06-11 13:08 | ioritzCia | Assigned To | ioritzCia => caristu | ||
2012-07-06 11:13 | caristu | Assigned To | caristu => VictorVillar | ||
2012-07-06 11:14 | caristu | Assigned To | VictorVillar => ioritzCia | ||
2012-07-16 18:34 | ioritzCia | Status | new => scheduled | ||
2012-07-16 18:34 | ioritzCia | fix_in_branch | => pi | ||
2012-07-18 09:31 | hgbot | Checkin | |||
2012-07-18 09:31 | hgbot | Note Added: 0050709 | |||
2012-07-18 09:31 | hgbot | Status | scheduled => resolved | ||
2012-07-18 09:31 | hgbot | Resolution | open => fixed | ||
2012-07-18 09:31 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/5b8d7382e4da67658d62bd854188a42dabbcc992 [^] | ||
2012-07-20 15:08 | VictorVillar | Note Added: 0050784 | |||
2012-07-20 15:08 | VictorVillar | Status | resolved => closed | ||
2012-07-26 02:42 | hudsonbot | Checkin | |||
2012-07-26 02:42 | hudsonbot | Note Added: 0050848 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|