Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023699Retail ModulesWeb POSpublic2013-04-30 16:582013-06-06 11:59
Reporterjecharri 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product VersionRMP21 
Target VersionRMP23Fixed in VersionRMP23 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023699: Problem with price list
DescriptionProblem with price list
Steps To Reproduce-create 2 price list versions
-one validfrom 2009 and another one valid from today

Check the second price list version (valid from today) as isactive ='N'

Verify that you can not login in the Web POS because the backend is trying to find active price list version with valid from = today
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff issue23699.diff (7,387) 2013-05-07 18:09
https://issues.openbravo.com/file_download.php?file_id=6127&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-04-30 16:58jecharriNew Issue
2013-04-30 16:58jecharriAssigned To => marvintm
2013-04-30 16:58jecharriResolution time => 1367877600
2013-04-30 17:01jecharriSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4649#r4649
2013-05-07 18:09marvintmFile Added: issue23699.diff
2013-05-08 11:20hgbotCheckin
2013-05-08 11:20hgbotNote Added: 0058503
2013-05-08 11:20hgbotStatusnew => resolved
2013-05-08 11:20hgbotResolutionopen => fixed
2013-05-08 11:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/36b8f76acf42b2f126145a712bce700abc55d7df [^]
2013-05-23 07:51hgbotCheckin
2013-05-23 07:51hgbotNote Added: 0058855
2013-05-23 07:51hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/36b8f76acf42b2f126145a712bce700abc55d7df [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.ch/rev/36b8f76acf42b2f126145a712bce700abc55d7df [^]
2013-05-28 14:50guilleaerReview Assigned To => guilleaer
2013-05-28 14:50guilleaerStatusresolved => closed
2013-05-28 14:50guilleaerFixed in Version => RMP23
2013-05-29 12:18hgbotCheckin
2013-05-29 12:18hgbotNote Added: 0059017
2013-05-29 12:18hgbotStatusclosed => resolved
2013-05-29 12:18hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.ch/rev/36b8f76acf42b2f126145a712bce700abc55d7df [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.multiorder/rev/36b8f76acf42b2f126145a712bce700abc55d7df [^]
2013-06-06 11:59guilleaerNote Added: 0059239
2013-06-06 11:59guilleaerStatusresolved => closed

Notes
(0058503)
hgbot   
2013-05-08 11:20   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 36b8f76acf42b2f126145a712bce700abc55d7df
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed May 08 11:20:18 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/36b8f76acf42b2f126145a712bce700abc55d7df [^]

Fixed issue 23699. The way the price list version is picked has been changed:
> - Two utility methods, which get the correct pricelist version for a given organization or terminal, have been added. This method will filter by active inside the query which also picks the maximum date, to avoid picking an inactive pricelist version, and then filtering it because it's inactive.
- The queries which previously selected the price list version have been modified to use these utility methods.

---
M src/org/openbravo/retail/posterminal/POSUtils.java
M src/org/openbravo/retail/posterminal/master/Category.java
M src/org/openbravo/retail/posterminal/master/Product.java
M src/org/openbravo/retail/posterminal/term/PriceListVersion.java
---
(0058855)
hgbot   
2013-05-23 07:51   
Repository: erp/pmods/org.openbravo.retail.posterminal.ch
Changeset: 36b8f76acf42b2f126145a712bce700abc55d7df
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed May 08 11:20:18 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.ch/rev/36b8f76acf42b2f126145a712bce700abc55d7df [^]

Fixed issue 23699. The way the price list version is picked has been changed:
> - Two utility methods, which get the correct pricelist version for a given organization or terminal, have been added. This method will filter by active inside the query which also picks the maximum date, to avoid picking an inactive pricelist version, and then filtering it because it's inactive.
- The queries which previously selected the price list version have been modified to use these utility methods.

---
M src/org/openbravo/retail/posterminal/POSUtils.java
M src/org/openbravo/retail/posterminal/master/Category.java
M src/org/openbravo/retail/posterminal/master/Product.java
M src/org/openbravo/retail/posterminal/term/PriceListVersion.java
---
(0059017)
hgbot   
2013-05-29 12:18   
Repository: erp/pmods/org.openbravo.retail.posterminal.multiorder
Changeset: 36b8f76acf42b2f126145a712bce700abc55d7df
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed May 08 11:20:18 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.multiorder/rev/36b8f76acf42b2f126145a712bce700abc55d7df [^]

Fixed issue 23699. The way the price list version is picked has been changed:
> - Two utility methods, which get the correct pricelist version for a given organization or terminal, have been added. This method will filter by active inside the query which also picks the maximum date, to avoid picking an inactive pricelist version, and then filtering it because it's inactive.
- The queries which previously selected the price list version have been modified to use these utility methods.

---
M src/org/openbravo/retail/posterminal/POSUtils.java
M src/org/openbravo/retail/posterminal/master/Category.java
M src/org/openbravo/retail/posterminal/master/Product.java
M src/org/openbravo/retail/posterminal/term/PriceListVersion.java
---
(0059239)
guilleaer   
2013-06-06 11:59   
closed again because it has changed "automatically" to resolved