Openbravo Issue Tracking System - Modules
View Issue Details
0038596ModulesDistribution Orderspublic2018-05-22 15:492018-06-19 13:41
dmiguelez 
vmromanos 
urgentmajoralways
closedfixed 
5
 
 
dmiguelez
0038596: Show available quantity in Product selector in Distribution order Issue Window
Show available quantity in Product selector in Distribution order Issue Window

When doing a Distribution Order Issue without a previous Receipt, it is necessary to know the available quantity to send.
This should be shown in the Product selector, like it is done for Sales Order, for example.
Show available quantity in Product selector in Distribution order Issue Window

When doing a Distribution Order Issue without a previous Receipt, it is necessary to know the available quantity to send.
This should be shown in the Product selector, like it is done for Sales Order, for example.
No tags attached.
has duplicate feature request 0038538 closed Triage Omni WMS Modules Show stocked quantity in Product selector in Lines Tab of Distribution Orders Window 
related to defect 0038693 closed caristu Openbravo ERP Error when exporting database due to a selector definition 
related to design defect 0038734 new Triage Platform Base Openbravo ERP Default Expression of Field in OBUISEL_Selector definition is mixing js and hql expressions, and is not working in all scenarios 
causes defect 0038899 closed dmiguelez Modules Distribution Orders are not managing Attributes correctly 
Issue History
2018-05-22 15:49dmiguelezNew Issue
2018-05-22 15:49dmiguelezAssigned To => Triage Finance
2018-05-28 17:38dmiguelezRelationship addedhas duplicate 0038538
2018-06-04 13:20dmiguelezRelationship addedrelated to 0038693
2018-06-06 10:11dmiguelezNote Added: 0104969
2018-06-06 11:46vmromanosStatusnew => scheduled
2018-06-06 11:46vmromanosAssigned ToTriage Finance => dmiguelez
2018-06-11 18:43dmiguelezRelationship addedrelated to 0038734
2018-06-11 18:44hgbotCheckin
2018-06-11 18:44hgbotNote Added: 0105069
2018-06-11 18:44hgbotStatusscheduled => resolved
2018-06-11 18:44hgbotResolutionopen => fixed
2018-06-11 18:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/5e468e4665bd33d194bf5eb02e5f896ce6cca255 [^]
2018-06-11 18:44hgbotCheckin
2018-06-11 18:44hgbotNote Added: 0105070
2018-06-11 18:44hgbotCheckin
2018-06-11 18:44hgbotNote Added: 0105071
2018-06-12 10:12hgbotCheckin
2018-06-12 10:12hgbotNote Added: 0105086
2018-06-12 10:12hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/5e468e4665bd33d194bf5eb02e5f896ce6cca255 [^] => http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/461ad908b75052f0224b94ec0c476b1df133e694 [^]
2018-06-12 13:06hgbotCheckin
2018-06-12 13:06hgbotNote Added: 0105091
2018-06-12 13:06hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/461ad908b75052f0224b94ec0c476b1df133e694 [^] => http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/b7118a5c6cbd71f9d6d28b038cdfdb2c46309c58 [^]
2018-06-12 13:07vmromanosAssigned Todmiguelez => vmromanos
2018-06-12 13:07vmromanosReview Assigned To => dmiguelez
2018-06-12 18:22hgbotCheckin
2018-06-12 18:22hgbotNote Added: 0105101
2018-06-12 18:29dmiguelezNote Added: 0105102
2018-06-12 18:29dmiguelezStatusresolved => closed
2018-06-19 12:24hgbotCheckin
2018-06-19 12:24hgbotNote Added: 0105226
2018-06-19 12:24hgbotCheckin
2018-06-19 12:24hgbotNote Added: 0105227
2018-06-19 12:24hgbotCheckin
2018-06-19 12:24hgbotNote Added: 0105228
2018-06-19 12:24hgbotCheckin
2018-06-19 12:24hgbotNote Added: 0105229
2018-06-19 12:24hgbotStatusclosed => resolved
2018-06-19 12:24hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/b7118a5c6cbd71f9d6d28b038cdfdb2c46309c58 [^] => http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder/rev/857f2ab57dca4a95f19d61a990bfdd7b55e02083 [^]
2018-06-19 12:24hgbotCheckin
2018-06-19 12:24hgbotNote Added: 0105230
2018-06-19 12:24hgbotCheckin
2018-06-19 12:24hgbotNote Added: 0105231
2018-06-19 12:25hgbotCheckin
2018-06-19 12:25hgbotNote Added: 0105232
2018-06-19 12:25hgbotCheckin
2018-06-19 12:25hgbotNote Added: 0105233
2018-06-19 12:25hgbotCheckin
2018-06-19 12:25hgbotNote Added: 0105234
2018-06-19 12:25hgbotCheckin
2018-06-19 12:25hgbotNote Added: 0105235
2018-06-19 12:25hgbotFixed in SCM revisionhttp://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder/rev/857f2ab57dca4a95f19d61a990bfdd7b55e02083 [^] => http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder/rev/8f43d442e6d3ea0aee3976c9693e36ed8405edca [^]
2018-06-19 12:25hgbotCheckin
2018-06-19 12:25hgbotNote Added: 0105236
2018-06-19 12:25hgbotCheckin
2018-06-19 12:25hgbotNote Added: 0105237
2018-06-19 13:41dmiguelezNote Added: 0105250
2018-06-19 13:41dmiguelezStatusresolved => closed
2018-07-05 17:01vmromanosRelationship addedcauses 0038899

Notes
(0104969)
dmiguelez   
2018-06-06 10:11   
Test Plan:

With Distributio Orders installed and the dataset applied through Enterprise Module Management Window

Log in as F&B Admin

Go to Distribution Order Issue Window
Create a new record with:
  - Organization: F&B US
  - Warehouse Issue: US West Coast
  - Warehouse Receipt: US East Coast
Move to lines and create a new record.
  - Check that in the product selector the quantity available for a product is shown
  - Filter by Ale Beer and check that there no available quantity (0)
Move back to the header and change the Warehouses
  - Warehouse Issue: US East Coast
  - Warehouse Receipt: US West Coast
Move to lines and create a new record.
  - Check that in the product selector the quantity available for a product is shown
  - Filter by Ale Beer and check that there is available quantity

Go to Distribution Order Receipt Window and repeat same exercise with same results
(0105069)
hgbot   
2018-06-11 18:44   
Repository: erp/mods/org.openbravo.distributionorder
Changeset: 5e468e4665bd33d194bf5eb02e5f896ce6cca255
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jun 04 13:27:11 2018 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/5e468e4665bd33d194bf5eb02e5f896ce6cca255 [^]

Fixes Issue 38596. Added new selector that shows
information about avalilable Quantity for a Product.

This selector shows available quantity in the Reception Warehouse
for DO Receipts and in the Issuing Warehouse for the
DO Issues.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_SEARCH.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
A src/org/openbravo/distributionorder/info/ProductWithStockSelectorFilterExpression.java
---
(0105070)
hgbot   
2018-06-11 18:44   
Repository: erp/mods/org.openbravo.distributionorder
Changeset: ae76f22f8e0631a82805726a8e708daa339d8e83
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jun 11 13:09:26 2018 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/ae76f22f8e0631a82805726a8e708daa339d8e83 [^]

Related to Issue 38596. Code Review changes.

* Fixed Typo
* Synchronized Terminology
* Added some solumns to Stored in session to correctly show
  values

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
---
(0105071)
hgbot   
2018-06-11 18:44   
Repository: erp/mods/org.openbravo.distributionorder
Changeset: 6fc98222faa6f83ef8ea4240eafd6b444411efe4
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jun 11 18:34:09 2018 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/6fc98222faa6f83ef8ea4240eafd6b444411efe4 [^]

Related to Issue 38596. Fixed typo

---
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0105086)
hgbot   
2018-06-12 10:12   
Repository: erp/mods/org.openbravo.distributionorder
Changeset: 461ad908b75052f0224b94ec0c476b1df133e694
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Jun 12 10:11:31 2018 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/461ad908b75052f0224b94ec0c476b1df133e694 [^]

Fixed issue 38596: Fixed compilation error
Domain type of reference 5DE98FE9933242D7AB8608BE769490C8 is not a TableDomainType but a org.openbravo.userinterface.selector.model.domaintype.SelectorDomainType@72f63eec

Declared new reference as Search and declared missed User Interface Definition

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
A src-db/database/sourcedata/OBCLKER_UIDEFINITION.xml
---
(0105091)
hgbot   
2018-06-12 13:06   
Repository: erp/mods/org.openbravo.distributionorder
Changeset: b7118a5c6cbd71f9d6d28b038cdfdb2c46309c58
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Jun 12 13:05:17 2018 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/b7118a5c6cbd71f9d6d28b038cdfdb2c46309c58 [^]

Fixed issue 38596: Reimplemented product selector

The product selector in DO lines has been totally refactorized. It doesn't use anymore any hack, it works using standard features.
It shows an aggregated by product view of all the stock available in the warehouse.

The selector implements a custom query that uses the m_product_stock_v view.
In DOi the selector shows by default currently stocked product because usually is the one that will be issued. User can remove the filter to show not currently stocked product.
In DOr the selector shows by default any product (currently stocked or not).

When selecting a stock, the attribute set instance field is automatically populated. User can delete the attribute if needed.
This feature didn't work before. Note that here we might have the known issues if user decides to edit the attribute.

---
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_SEARCH.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
M src/org/openbravo/distributionorder/ad_callouts/SL_DistributionOrder_Product.java
M src/org/openbravo/distributionorder/info/ProductWithStockSelectorFilterExpression.java
R src-db/database/sourcedata/OBCLKER_UIDEFINITION.xml
---
(0105101)
hgbot   
2018-06-12 18:22   
Repository: erp/mods/org.openbravo.distributionorder
Changeset: 8741cf8ca8ee297f6efd86f4efbc3f0338c72ab7
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jun 12 18:21:51 2018 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.distributionorder/rev/8741cf8ca8ee297f6efd86f4efbc3f0338c72ab7 [^]

Related to Issue 38596. Code Review changes

* Changed definition of reference type for column to be
  OBUISEL_Selector, as the new selector is using this
  reference instead of Search
* Renamed property of Product Name to name to avoid warnings
  in the log when trying to retrieve the property from the drop
  down list (the system was trying to do product.productName, which
  does not exist)
* Fixed n.p.e. in Callout raised when changing from a product
  that has attribute to a product without it

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
M src/org/openbravo/distributionorder/ad_callouts/SL_DistributionOrder_Product.java
---
(0105102)
dmiguelez   
2018-06-12 18:29   
Code Review + Testing Ok
(0105226)
hgbot   
2018-06-19 12:24   
Repository: retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder
Changeset: 3b50a4a71bc44ccc6ad05011eca5f33778b33591
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jun 04 13:27:11 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder/rev/3b50a4a71bc44ccc6ad05011eca5f33778b33591 [^]

Related to Issue 38596. Added new selector that shows
information about avalilable Quantity for a Product.

This selector shows available quantity in the Reception Warehouse
for DO Receipts and in the Issuing Warehouse for the
DO Issues.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_SEARCH.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
A src/org/openbravo/distributionorder/info/ProductWithStockSelectorFilterExpression.java
---
(0105227)
hgbot   
2018-06-19 12:24   
Repository: retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder
Changeset: ee41528807231b5e1a21985aafdf758fdf2e50fd
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jun 11 13:09:26 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder/rev/ee41528807231b5e1a21985aafdf758fdf2e50fd [^]

Related to Issue 38596. Code Review changes.

* Fixed Typo
* Synchronized Terminology
* Added some solumns to Stored in session to correctly show
  values

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
---
(0105228)
hgbot   
2018-06-19 12:24   
Repository: retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder
Changeset: c5d19a4740f0615c058a7c0de44896d78d49743b
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jun 11 18:34:09 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder/rev/c5d19a4740f0615c058a7c0de44896d78d49743b [^]

Related to Issue 38596. Fixed typo

---
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0105229)
hgbot   
2018-06-19 12:24   
Repository: retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder
Changeset: 857f2ab57dca4a95f19d61a990bfdd7b55e02083
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Jun 12 10:11:31 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder/rev/857f2ab57dca4a95f19d61a990bfdd7b55e02083 [^]

Fixed issue 38596: Fixed compilation error
Domain type of reference 5DE98FE9933242D7AB8608BE769490C8 is not a TableDomainType but a org.openbravo.userinterface.selector.model.domaintype.SelectorDomainType@72f63eec

Declared new reference as Search and declared missed User Interface Definition

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
A src-db/database/sourcedata/OBCLKER_UIDEFINITION.xml
---
(0105230)
hgbot   
2018-06-19 12:24   
Repository: retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder
Changeset: 61654090a21fc2bcfb91fb0ea77fc1cc165b7dae
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jun 19 12:21:52 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder/rev/61654090a21fc2bcfb91fb0ea77fc1cc165b7dae [^]

Related to issue 38596: Reimplemented product selector

The product selector in DO lines has been totally refactorized. It doesn't use anymore any hack, it works using standard features.
It shows an aggregated by product view of all the stock available in the warehouse.

The selector implements a custom query that uses the m_product_stock_v view.
In DOi the selector shows by default currently stocked product because usually is the one that will be issued. User can remove the filter to show not currently stocked product.
In DOr the selector shows by default any product (currently stocked or not).

When selecting a stock, the attribute set instance field is automatically populated. User can delete the attribute if needed.
This feature didn't work before. Note that here we might have the known issues if user decides to edit the attribute.

---
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_SEARCH.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
M src/org/openbravo/distributionorder/ad_callouts/SL_DistributionOrder_Product.java
M src/org/openbravo/distributionorder/info/ProductWithStockSelectorFilterExpression.java
R src-db/database/sourcedata/OBCLKER_UIDEFINITION.xml
---
(0105231)
hgbot   
2018-06-19 12:24   
Repository: retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder
Changeset: 13328e8369317582b5b838385e619ddd7620dfb8
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jun 19 12:23:55 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.distributionorder/rev/13328e8369317582b5b838385e619ddd7620dfb8 [^]

Related to Issue 38596. Code Review changes

* Changed definition of reference type for column to be
  OBUISEL_Selector, as the new selector is using this
  reference instead of Search
* Renamed property of Product Name to name to avoid warnings
  in the log when trying to retrieve the property from the drop
  down list (the system was trying to do product.productName, which
  does not exist)
* Fixed n.p.e. in Callout raised when changing from a product
  that has attribute to a product without it

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
M src/org/openbravo/distributionorder/ad_callouts/SL_DistributionOrder_Product.java
---
(0105232)
hgbot   
2018-06-19 12:25   
Repository: retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder
Changeset: 828ac9233806029d4fa2bc1348254ce3a186d0c6
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jun 04 13:27:11 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder/rev/828ac9233806029d4fa2bc1348254ce3a186d0c6 [^]

Related to Issue 38596. Added new selector that shows
information about avalilable Quantity for a Product.

This selector shows available quantity in the Reception Warehouse
for DO Receipts and in the Issuing Warehouse for the
DO Issues.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_SEARCH.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
A src/org/openbravo/distributionorder/info/ProductWithStockSelectorFilterExpression.java
---
(0105233)
hgbot   
2018-06-19 12:25   
Repository: retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder
Changeset: 46e3deec65fe329c94c0a2db7a69314f6823bf9b
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jun 11 13:09:26 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder/rev/46e3deec65fe329c94c0a2db7a69314f6823bf9b [^]

Related to Issue 38596. Code Review changes.

* Fixed Typo
* Synchronized Terminology
* Added some solumns to Stored in session to correctly show
  values

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
---
(0105234)
hgbot   
2018-06-19 12:25   
Repository: retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder
Changeset: cfb0166f1802a34a07578baba7bb4d54ff60f1de
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jun 11 18:34:09 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder/rev/cfb0166f1802a34a07578baba7bb4d54ff60f1de [^]

Related to Issue 38596. Fixed typo

---
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0105235)
hgbot   
2018-06-19 12:25   
Repository: retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder
Changeset: 8f43d442e6d3ea0aee3976c9693e36ed8405edca
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Jun 12 10:11:31 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder/rev/8f43d442e6d3ea0aee3976c9693e36ed8405edca [^]

Fixed issue 38596: Fixed compilation error
Domain type of reference 5DE98FE9933242D7AB8608BE769490C8 is not a TableDomainType but a org.openbravo.userinterface.selector.model.domaintype.SelectorDomainType@72f63eec

Declared new reference as Search and declared missed User Interface Definition

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
A src-db/database/sourcedata/OBCLKER_UIDEFINITION.xml
---
(0105236)
hgbot   
2018-06-19 12:25   
Repository: retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder
Changeset: 95f4a882727f50742afc282a9fcce5c5f0ecb806
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jun 19 12:21:52 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder/rev/95f4a882727f50742afc282a9fcce5c5f0ecb806 [^]

Related to issue 38596: Reimplemented product selector

The product selector in DO lines has been totally refactorized. It doesn't use anymore any hack, it works using standard features.
It shows an aggregated by product view of all the stock available in the warehouse.

The selector implements a custom query that uses the m_product_stock_v view.
In DOi the selector shows by default currently stocked product because usually is the one that will be issued. User can remove the filter to show not currently stocked product.
In DOr the selector shows by default any product (currently stocked or not).

When selecting a stock, the attribute set instance field is automatically populated. User can delete the attribute if needed.
This feature didn't work before. Note that here we might have the known issues if user decides to edit the attribute.

---
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_SEARCH.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
M src/org/openbravo/distributionorder/ad_callouts/SL_DistributionOrder_Product.java
M src/org/openbravo/distributionorder/info/ProductWithStockSelectorFilterExpression.java
R src-db/database/sourcedata/OBCLKER_UIDEFINITION.xml
---
(0105237)
hgbot   
2018-06-19 12:25   
Repository: retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder
Changeset: 8dde6cbe9e5f51b1162336dcb525767f6fae66e5
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jun 19 12:23:55 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.distributionorder/rev/8dde6cbe9e5f51b1162336dcb525767f6fae66e5 [^]

Related to Issue 38596. Code Review changes

* Changed definition of reference type for column to be
  OBUISEL_Selector, as the new selector is using this
  reference instead of Search
* Renamed property of Product Name to name to avoid warnings
  in the log when trying to retrieve the property from the drop
  down list (the system was trying to do product.productName, which
  does not exist)
* Fixed n.p.e. in Callout raised when changing from a product
  that has attribute to a product without it

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
M src/org/openbravo/distributionorder/ad_callouts/SL_DistributionOrder_Product.java
---
(0105250)
dmiguelez   
2018-06-19 13:41   
Pushed fixes to backport repositories (Q4 and Q1)