Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028053Openbravo ERP09. Financial managementpublic2014-11-03 12:092014-12-30 23:28
Reporterngarcia 
Assigned Toreinaldoguerra 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Versionpi 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028053: 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
DescriptionTax is not selected when the BP is set as exempt and there exists a tax with a newer valid from date and different organization
Steps To ReproduceAs group admin role:
   Set the Alimentos y Supermercados, S.A. business partner as Tax Exempt
   Set the Exempt tax rate (F&B US, Inc. organization) as Tax Exempt (check it's Valid From Date is newer than the one for Ventas Exentas tax rate)
   Create a Sales Order for F&B España Región Norte and Alimentos y Supermercados
   Add a line and check that when adding a product the Arrendamiento 16% (cobros) tax rate is selected (the first one in the combo list)

   The problem is that the C_GETTAX function returns the id for the Exempt tax rate and as it is not in the organization tree of the document it is not shown in the combo
Proposed SolutionThe C_GETTAX function should filter by organization when the business partner is exempt
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 00259923.0PR15Q2 closed reinaldoguerra Tax rate is not automatically selected in invoice lines for exempt customers 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-11-03 12:09ngarciaNew Issue
2014-11-03 12:09ngarciaAssigned To => AtulOpenbravo
2014-11-03 12:09ngarciaModules => Core
2014-11-03 12:09ngarciaResolution time => 1418166000
2014-11-03 12:09ngarciaTriggers an Emergency Pack => No
2014-11-03 12:10ngarciaTarget Version => 3.0PR15Q1
2014-11-03 12:10ngarciaIssue Monitored: networkb
2014-12-13 20:29reinaldoguerraAssigned ToAtulOpenbravo => reinaldoguerra
2014-12-13 20:29reinaldoguerraStatusnew => scheduled
2014-12-22 16:30ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=7313#r7313
2014-12-24 14:55reinaldoguerraNote Added: 0072821
2014-12-26 13:14umartirenaRelationship addedhas duplicate 0025992
2014-12-26 13:17hgbotCheckin
2014-12-26 13:17hgbotNote Added: 0072838
2014-12-26 13:17hgbotStatusscheduled => resolved
2014-12-26 13:17hgbotResolutionopen => fixed
2014-12-26 13:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e771ac26cf0930b50d6e9fb48254788863b809fd [^]
2014-12-26 13:17umartirenaReview Assigned To => umartirena
2014-12-26 13:17umartirenaNote Added: 0072839
2014-12-26 13:17umartirenaStatusresolved => closed
2014-12-26 13:17umartirenaFixed in Version => pi
2014-12-30 23:28hudsonbotCheckin
2014-12-30 23:28hudsonbotNote Added: 0073269

Notes
(0072821)
reinaldoguerra   
2014-12-24 14:55   
Test plan used:
1- Login into Openbravo ERP
2- Go to business partner window and select Alimentos y Supermercados, S.A.
3- Go to Customer tab and check Tax Exempt flag
4- Go to Tax Rate window
5- Set the Exempt tax rate (F&B US, Inc. organization) as Tax Exempt too (check Tax Exempt flag)
6- Check it's Valid From Date is newer than the one for Ventas Exentas tax rate
7- Create a Sales Order for F&B España Región Norte and Alimentos y Supermercados as business partner
8- Add a line and check that when adding a product, Entregas a Canarias,Ceuta y Melilla (%R=>0%) is selected as tax rate, as it is the first tax rate mark as exempt for F&B España ordering by Valid From date.
(0072838)
hgbot   
2014-12-26 13:17   
Repository: erp/devel/pi
Changeset: e771ac26cf0930b50d6e9fb48254788863b809fd
Author: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
Date: Tue Dec 23 11:46:18 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/e771ac26cf0930b50d6e9fb48254788863b809fd [^]

Fixed bug 28053: Tax is not selected when the business partner is set as exempt.

The callout applied in sales order line tax selector, now obtains tax rate for the header's organization tree when the business partner is set as Tax Exempt.
The C_GETTAX function was changed to filter tax rates taking into account the order's header organization tree. Now when creating a new order's line for a tax exempt business parter, the tax selector will show records for the correspondent organization tree.

---
M src-db/database/model/functions/C_GETTAX.xml
---
(0072839)
umartirena   
2014-12-26 13:17   
Code Review and Testing OK
(0073269)
hudsonbot   
2014-12-30 23:28   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6525fe229e06 [^]
Maturity status: Test