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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0025992

Openbravo ERP

07. Sales management

public

2014-03-14 09:22

2014-12-26 13:15

Reporter

ngarcia

Assigned To

reinaldoguerra

Priority

high

Severity

minor

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

Target Version

3.0PR15Q2

Fixed in Version

Merge Request Status

Review Assigned To

umartirena

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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

Additional Information