Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026464Openbravo ERP07. Sales managementpublic2014-05-05 18:492014-08-19 20:16
Reporterjonalegriaesarte 
Assigned Torafaroda 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR14Q4Fixed in Versionpi 
Merge Request Status
Review Assigned ToAtulOpenbravo
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026464: Define a new price list version with name included in the old version, duplicates entries in product selector
DescriptionDefine a new price list version with name included in the old version, duplicates entries in product selector
Steps To ReproduceWe are going to describe the issue using sales flow, but the same happens in purchase flow
- Tarifa de ventas price list
- Change the name of the actual version to "Tarifa de ventas tva"
- Define a new version starting from today, called "Tarifa de ventas". Define prices using the button create price list, taking as base the old version of Tarifa de ventas.
- Create a new sale invoice
- Create a new line, in product selector, the products appear twice
- Opening the selector, you can understand better the issue. The system is filtering by price list, but it is take into consideration the name to filter and the system shows similar names, instead of filtering by ID.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0027288 closed inigosanchez Review display logic of Clause Left Part field in Defined Selector Field tab 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-05-05 18:49jonalegriaesarteNew Issue
2014-05-05 18:49jonalegriaesarteAssigned To => pramakrishnan
2014-05-05 18:49jonalegriaesarteModules => Core
2014-05-05 18:49jonalegriaesarteTriggers an Emergency Pack => No
2014-05-05 18:50jonalegriaesarteResolution time => 1405893600
2014-06-16 12:48jonalegriaesarteTarget VersionPR14Q3 => PR14Q4
2014-07-31 10:16jonalegriaesarteNote Added: 0069003
2014-07-31 10:20extraIssue Monitored: extra
2014-08-01 10:01rafarodaStatusnew => scheduled
2014-08-01 10:01rafarodaAssigned Topramakrishnan => rafaroda
2014-08-01 10:01rafarodafix_in_branch => pi
2014-08-01 16:27rafarodaNote Added: 0069035
2014-08-01 16:49rafarodaNote Added: 0069037
2014-08-04 09:14rafarodaNote Edited: 0069035bug_revision_view_page.php?bugnote_id=0069035#r6238
2014-08-07 09:48rafarodaRelationship addedrelated to 0027288
2014-08-15 08:42hgbotCheckin
2014-08-15 08:42hgbotNote Added: 0069383
2014-08-15 08:42hgbotStatusscheduled => resolved
2014-08-15 08:42hgbotResolutionopen => fixed
2014-08-15 08:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5ca94c9c998944df8a474eef548dbb328a23d4c4 [^]
2014-08-18 01:58hudsonbotCheckin
2014-08-18 01:58hudsonbotNote Added: 0069450
2014-08-19 20:16AtulOpenbravoReview Assigned To => AtulOpenbravo
2014-08-19 20:16AtulOpenbravoNote Added: 0069526
2014-08-19 20:16AtulOpenbravoStatusresolved => closed
2014-08-19 20:16AtulOpenbravoFixed in Version => pi

Notes
(0069003)
jonalegriaesarte   
2014-07-31 10:16   
Same happens in purchase plan tab
(0069035)
rafaroda   
2014-08-01 16:27   
(edited on: 2014-08-04 09:14)
Product selector issue is reproducing in:
* Purchase Invoice
* Sales Invoice

In Purchase Order and Sales Order product selector is working fine.
(0069037)
rafaroda   
2014-08-01 16:49   
In Application Dictionary:
* C_ORDERLINE table is using for column M_PRODUCT_ID, the Reference: Product - Search - Defined Selector: ProductByPriceAndWarehouse
* C_INNVOICELINE table is using for column M_PRODUCT_ID, the Reference: ProductSimple - OBUISEL_Selector Reference - Defined Selector: ProductSimple
(0069383)
hgbot   
2014-08-15 08:42   
Repository: erp/devel/pi
Changeset: 5ca94c9c998944df8a474eef548dbb328a23d4c4
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Thu Aug 14 14:22:11 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5ca94c9c998944df8a474eef548dbb328a23d4c4 [^]

Fixes issue 26464 Added Clause Left Part to Defined Selector Field PriceListVersionID of ProductSimple reference

---
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
---
(0069450)
hudsonbot   
2014-08-18 01:58   
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/ed428d44c18c [^]
Maturity status: Test
(0069526)
AtulOpenbravo   
2014-08-19 20:16   
Verified