Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045683Openbravo ERPA. Platformpublic2021-01-05 16:072021-01-18 15:53
Reportersebastien_liron 
Assigned ToTriage Finance 
PriorityimmediateSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product VersionPR20Q3.2 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0045683: Distribution order receipt P&E shows product's name instead of its identifer
DescriptionDistribution order receipt Pick lines' grid shows product's name instead of its identifier. By default product's identifier is just its name, but in case some other column is added (ie. characteristics description), the latter is not shown in the grid.
Steps To Reproduce- set the flag Used as record identifier for the column Characteristic_Desc in Product table
- create Distribution order receipt
- try to add products and the name is without the carac value
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0045621 closed alostale Return to Vendor P&E shows product's name instead of its identifer 
Attached Filesjpg cartissue1.jpg (61,796) 2021-01-05 16:07
https://issues.openbravo.com/file_download.php?file_id=15219&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2021-01-05 16:07sebastien_lironNew Issue
2021-01-05 16:07sebastien_lironAssigned To => platform
2021-01-05 16:07sebastien_lironFile Added: cartissue1.jpg
2021-01-05 16:07sebastien_lironModules => Core
2021-01-05 16:07sebastien_lironResolution time => 1610665200
2021-01-05 16:07sebastien_lironTriggers an Emergency Pack => No
2021-01-05 16:07sebastien_lironRelationship addedrelated to 0045621
2021-01-05 18:25AugustoMauchAssigned Toplatform => Triage Finance
2021-01-12 12:17dmiguelezTypedefect => design defect
2021-01-12 12:20dmiguelezNote Added: 0125373
2021-01-18 09:46vmromanosTarget VersionPR20Q3.3 =>
2021-01-18 15:53vmromanosResolution time1610665200 =>

Notes
(0125373)
dmiguelez   
2021-01-12 12:20   
This issue has been changed to Design Defect.

This particular OBUISEL_Selector named 'Item Stocked Products and available quantity' is defined using a Custom HQL Query.

In this case it is not possible to add the identifier of the Table as a column to be retrieved by the query.

The option of using the ad_column_identifier Database Function is discarded also since it is required to send the ad_language parameter which must be given to the query and there is no option to parameterize this queries as of now.

The best option in this case is to add the required fields through a customization using a template.

Additional Note: Since the selector shows the Search Key of the products, it is possible to differentiate one record from the other in this case.