Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027252Openbravo ERP07. Sales managementpublic2014-07-31 19:122014-12-30 23:23
Reportercaristu 
Assigned Tovmromanos 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q4Fixed in Versionpi 
Merge Request Status
Review Assigned Toreinaldoguerra
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket29818
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027252: Invoice lines with products that doesn't belong to the natural tree of the organization in the header
DescriptionIt is possible to create invoice lines with products that doesn't belong to the natural tree of the organization in the header.
Steps To Reproduce1) Login as F&B International Group Admin, create a new sales price list for F&B International Group. Set it as default.
2) Add one product from F&B España and another one from F&B US to the price list
3) Go to the [Sales Invoice] window and create a new record for F&B España
4) Go to the [Lines] tab and click on the product selector. Notice that it is possible to select the product from F&B US
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 00270763.0PR15Q1 closed AtulOpenbravo Product defined for an organization can be used when creating purchase invoice belonging to different organization's tree 
related to defect 00272533.0PR14Q4 closed shankarb @additional_filters@ is not working as expected in HQL query selectors 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-31 19:12caristuNew Issue
2014-07-31 19:12caristuAssigned To => dmiguelez
2014-07-31 19:12caristuOBNetwork customer => Yes
2014-07-31 19:12caristuModules => Core
2014-07-31 19:12caristuSupport ticket => 29818
2014-07-31 19:12caristuResolution time => 1405893600
2014-07-31 19:12caristuTriggers an Emergency Pack => No
2014-07-31 19:13caristuIssue Monitored: networkb
2014-07-31 19:37caristuResolution time1405893600 => 1407967200
2014-07-31 19:37caristuAssigned Todmiguelez => AtulOpenbravo
2014-07-31 19:37caristuRelationship addedrelated to 0027253
2014-07-31 19:39caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6224#r6224
2014-07-31 19:42caristuResolution time1407967200 => 1408658400
2014-09-22 16:09vmromanosRelationship addedrelated to 0027076
2014-09-22 16:12vmromanosReview Assigned To => vmromanos
2014-09-22 16:12vmromanosRelationship replacedduplicate of 0027076
2014-09-22 16:12vmromanosNote Added: 0070243
2014-09-22 16:12vmromanosStatusnew => closed
2014-09-22 16:12vmromanosResolutionopen => duplicate
2014-10-09 18:41caristuNote Added: 0070849
2014-10-09 18:41caristuStatusclosed => new
2014-10-09 18:41caristuResolutionduplicate => open
2014-10-09 18:42caristuNote Edited: 0070849bug_revision_view_page.php?bugnote_id=0070849#r6765
2014-10-12 02:46reinaldoguerraAssigned ToAtulOpenbravo => reinaldoguerra
2014-10-12 02:46reinaldoguerraStatusnew => scheduled
2014-10-12 02:46reinaldoguerraNote Added: 0070888
2014-10-21 18:05vmromanosAssigned Toreinaldoguerra => vmromanos
2014-10-21 18:05vmromanosReview Assigned Tovmromanos => reinaldoguerra
2014-10-21 18:10hgbotCheckin
2014-10-21 18:10hgbotNote Added: 0071100
2014-10-21 18:10hgbotStatusscheduled => resolved
2014-10-21 18:10hgbotResolutionopen => fixed
2014-10-21 18:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b22cd5e9d70de62dca4ce2964c479c4cd893a329 [^]
2014-10-22 04:59reinaldoguerraStatusresolved => closed
2014-10-22 04:59reinaldoguerraFixed in Version => pi
2014-12-30 23:23hudsonbotCheckin
2014-12-30 23:23hudsonbotNote Added: 0072963

Notes
(0070243)
vmromanos   
2014-09-22 16:12   
Duplicated of 0027076
(0070849)
caristu   
2014-10-09 18:41   
(edited on: 2014-10-09 18:42)
Still able to reproduce the issue in pi with the steps to reproduce (using F&B España as the organization in the context)
(0070888)
reinaldoguerra   
2014-10-12 02:46   
Test plan used:
1- Login into Openbravo ERP as F&B International Group Admin
2- Go to Price List window and create a new one for F&B International Group. Set it as default. Also check Sales price List flag.
3- Go to Price list version tab an create a new one named "Tarifa de ventas". Select a price list schema.
4- Go to product price tab and add one product from F&B España and another one from F&B US.
5- Go to the Sales Invoice window and create a new record for F&B España
6- Go to the Lines tab and click on the product selector.
7- Notice that only products in the same tree of the organization in the header are shown.
(0071100)
hgbot   
2014-10-21 18:10   
Repository: erp/devel/pi
Changeset: b22cd5e9d70de62dca4ce2964c479c4cd893a329
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Oct 21 18:07:45 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b22cd5e9d70de62dca4ce2964c479c4cd893a329 [^]

Fixed bug 27252: Invoice lines products don't belong to the org. header tree.

Sales invoice line product selector's HQL query base table was changed to Product table so the implicit filter by accessible Organizations is now applied for Product instead of ProductPrice.
Now the selector filters by products with organization in the same tree of the organization in the header. This change also affects other windows where this selector is used, like Purchase Invoice and APRM GL Item P&E windows.

---
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0072963)
hudsonbot   
2014-12-30 23:23   
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