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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0025992
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2014-03-14 09:222014-12-26 13:15
ReporterngarciaView Statuspublic 
Assigned Toreinaldoguerra 
PriorityhighResolutionduplicateFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version3.0PR15Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toumartirena
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0025992: Tax rate is not automatically selected in invoice lines for exempt customers

DescriptionTax rate is not automatically selected in invoice lines for exempt customers if there exists another tax rate defined for an organization not in the natural tree of the document's organization with a newest Valid From date
Steps To ReproduceAs group admin role:
   Define a Customer from F&B España, S.A. as Tax Exempt
   Check that there exists a Tax Rate for F&B España, S.A. set as Tax Exempt
   Create a Tax Rate for F&B US, Inc. set as Tax Exempt and with a Valid From date of today
   Create a Sales Invoice for F&B España, S.A., that business partner and Invoice date of today
   Add a line to it and check that when selecting a product the Tax field is not filled automatically
Proposed SolutionIn C_GETTAX function the following query should be filtered by the organizations in the tree of the document's organization

SELECT t.C_Tax_ID
          FROM C_Tax t
          INNER JOIN AD_Org o
            ON(t.AD_Client_ID = o.AD_Client_ID)
          WHERE t.ISTAXEXEMPT = 'Y'
            AND o.AD_Org_ID = p_Org_ID
            AND t.ValidFrom <= p_shipDate
            AND t.isActive = 'Y'
            AND (t.sopotype = CASE WHEN (p_issotrx = 'Y')
                    THEN ('S')
                    ELSE ('P') END OR t.sopotype = 'B')
          ORDER BY t.VALIDFROM DESC
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of defect 00280533.0PR15Q1 closedreinaldoguerra Tax is not selected when the BP is set as exempt and there exists a tax with a newer valid from date and different organization 

-  Notes
(0072837)
umartirena (reporter)
2014-12-26 13:15

Issue duplicate of https://issues.openbravo.com/view.php?id=28053 [^]

- Issue History
Date Modified Username Field Change
2014-03-14 09:22 ngarcia New Issue
2014-03-14 09:22 ngarcia Assigned To => jonalegriaesarte
2014-03-14 09:22 ngarcia Modules => Core
2014-03-14 09:22 ngarcia Resolution time => 1401228000
2014-03-14 09:22 ngarcia Triggers an Emergency Pack => No
2014-03-14 09:25 ngarcia Issue Monitored: ngarcia
2014-06-30 13:46 jonalegriaesarte Target Version PR14Q3 => PR14Q4
2014-10-02 11:01 jonalegriaesarte Target Version 3.0PR14Q4 => 3.0PR15Q1
2014-12-22 12:36 vmromanos Target Version 3.0PR15Q1 => 3.0PR15Q2
2014-12-24 15:32 reinaldoguerra Assigned To jonalegriaesarte => reinaldoguerra
2014-12-24 15:32 reinaldoguerra Status new => scheduled
2014-12-26 13:14 umartirena Relationship added duplicate of 0028053
2014-12-26 13:15 umartirena Review Assigned To => umartirena
2014-12-26 13:15 umartirena Status scheduled => closed
2014-12-26 13:15 umartirena Resolution open => duplicate
2014-12-26 13:15 umartirena Fixed in Version => pi
2014-12-26 13:15 umartirena Note Added: 0072837


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker