Project:
| View Revisions: Issue #20460 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0020460: wrong definition of some taxes in the dataset | ||
| Revision | 2012-05-09 19:18 by VictorVillar | ||
| 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 |
||
| Revision | 2012-05-09 18:53 by VictorVillar | ||
| 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' in order to search only the tax sales transactions |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |