Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0025992

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 07. Sales management

minor

always

2014-03-14 09:22

2014-12-26 13:15

Reporter

ngarcia

View Status

public

Assigned To

reinaldoguerra

Priority

high

Resolution

duplicate

Fixed in Version

pi

Status

closed

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

3.0PR15Q2

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

SCM revision

Merge Request Status

Review Assigned To

umartirena

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

27205

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

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

Description

Tax 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 Reproduce

As 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 Solution

In 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

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

3.0PR15Q1

closed

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 (viewer) 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	OBNetwork customer	=> No
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	OBNetwork customer	No => Yes
2014-10-02 11:01	jonalegriaesarte	Target Version	3.0PR14Q4 => 3.0PR15Q1
2014-10-23 11:20	ngarcia	Support ticket	=> 27205
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