Openbravo Issue Tracking System - Retail Modules
View Issue Details
0040037Retail ModulesWeb POSpublic2019-01-25 12:442019-02-15 09:49
0040037: Problem using multi price list with price list versions defined
Using multi price list (price list associated to clients) if these price lists have price list versions defined, after executing an incremental refresh, if a new list price version has been defined the new price is loaded in Web POS but the oldest price is still there.
The query uses one of them randomly.

Go to livebuilds

Channel -Touchpoint -> MPL1

Navigate to Organization - > Price List

Create a new Price List Version for Sale Price List Customer VIP

Add one product (Adhesive body warmers) and fill the price (9.00)


Do login

Search the product

You will see the new price defined or the oldest one.(randomly)

In local database you will also see the oldest price.
The product price will have a new column (valid from of price list version).
The Web POS query needs filter by this new field, order by created desc and get the first record.
No tags attached.
png Multipricelist.png (182,486) 2019-01-25 12:44
Issue History
2019-01-25 12:44samuel_nicuesaNew Issue
2019-01-25 12:44samuel_nicuesaAssigned To => Retail
2019-01-25 12:44samuel_nicuesaFile Added: Multipricelist.png
2019-01-25 12:44samuel_nicuesaRegression date => 2019-02-15
2019-01-25 12:44samuel_nicuesaTriggers an Emergency Pack => No
2019-01-25 17:50jfrancesIssue Monitored: jfrances
2019-01-28 13:41ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2019-01-28 13:41ranjith_qualiantech_comStatusnew => scheduled
2019-02-04 06:26hgbotCheckin
2019-02-04 06:26hgbotNote Added: 0109464
2019-02-04 06:26hgbotCheckin
2019-02-04 06:26hgbotNote Added: 0109465
2019-02-04 06:26hgbotStatusscheduled => resolved
2019-02-04 06:26hgbotResolutionopen => fixed
2019-02-04 06:26hgbotFixed in SCM revision => [^]
2019-02-14 17:36ngarciaRegression date2019-02-15 =>
2019-02-15 09:49marvintmReview Assigned To => marvintm
2019-02-15 09:49marvintmStatusresolved => closed
2019-02-15 09:49marvintmFixed in Version => RR19Q2

2019-02-04 06:26   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 82f5305432412d949611e68852bef60fce59b35b
Author: Ranjith S R <ranjith <at>>
Date: Mon Feb 04 10:56:08 2019 +0530
URL: [^]

Related to issue 40037 : Added orderBy to filter product price with multiple priceList version

M src/org/openbravo/retail/posterminal/master/
M web/org.openbravo.retail.posterminal/js/model/productprice.js
2019-02-04 06:26   
Repository: erp/pmods/
Changeset: 1d1d293ef5815a7c5c69e42791f36ea0acc39a5e
Author: Ranjith S R <ranjith <at>>
Date: Mon Feb 04 10:56:19 2019 +0530
URL: [^]

Fixed issue 40037 : Added orderBy to filter product with multiple priceList version

M web/