Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041927Retail ModulesWeb POSpublic2019-10-03 16:262023-05-25 17:31
Reportersalvador_campanella 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in VersionRR20Q1 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041927: Data inconsistency is provoked when multiprice list is used in WEBPOS [ Quotations and Verified Returns ]
DescriptionData inconsistency is provoked when multiprice list is used in WEBPOS [ Quotations and Verified Returns ]
Steps To ReproduceSteps to reproduce: Verified Returns
---------------------------------------
Go to BackEnd:
Enable the preference Web POS Enable Multi Price List
Create a pricelist "Test" without including tax
We add the product 1502145 and set the price 20
In Business partner window we assign the price list Test to Arturo Montoro

Go to FrontEnd:
Select business partner Arturo Montoro
Buy the product 1502145

Go to BackEnd
In the window Business partner change for Arturo Montoro the priceList to the pricelist "The White Valley Group Sale Price List"

Go to the POS and do a full refresh
In the menu click on verified returns and select the previous order you bought
You get the error "Cannot calculate receipt taxes"

If you do the operation the other way around:
Buying with the price list "The White Valley Group Sale Price List" that includes tax.
And later changes the price list To Test in a business partner. The return will add the taxes making the amount bigger than the one was paid for the first time

Steps to reproduce: Quotations
-------------------------------
    - Enable the "Web POS Enable Multi Price List" preference
- Change the currency of the White Valley Group Sale Price list (Opening Store) to ARS
- Assign to the business partner "VBS Customer 2" the price list "The White Valley Group Sale Price list (Opening Store)"
-In the web pos create a new quotation for "VBS Customer 2"
-In backoffice select the new Quotation

Result: the currency of the Quotations is EUR but the pricelist associated is ARS and the value if the same
Proposed Solution. when BP is selected in POS, two new validations will be executed:

- pricelist include tax/not include taxes should be the same that the main pricelist

- currency should be the same that main pricelist

If not, a popup will be displayed informing about this problem, and the main pricelist will be used to this customer
Additional Information
TagsNo tags attached.
Relationships
caused by design defect 0041665 new rqueralta Error With return verified if the business partner price list is changed 
caused by defect 0041857 closed rqueralta In WebPOS the Quotations with multi pricelist enable don't change the currency value 
related to defect 0043858 closed prakashmurugesan88 [Cross-store] Cannot Open Receipt or Verified Return in a different store if the anonymous customer doesn't have contact defined 
related to defect 0052576 closed ranjith_qualiantech_com It should be possible to manage multi Price List in a channel touchpoint 
Attached Filespatch issue 41927 source posterminal.patch (8,899) 2019-10-15 09:08
https://issues.openbravo.com/file_download.php?file_id=13390&type=bug
patch issue 41927 source returns.patch (892) 2019-10-15 09:08
https://issues.openbravo.com/file_download.php?file_id=13391&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-10-03 16:26salvador_campanellaNew Issue
2019-10-03 16:26salvador_campanellaAssigned To => Retail
2019-10-03 16:26salvador_campanellaResolution time => 1571868000
2019-10-03 16:26salvador_campanellaTriggers an Emergency Pack => No
2019-10-03 16:27salvador_campanellaRelationship addedcaused by 0041665
2019-10-03 16:28salvador_campanellaRelationship addedcaused by 0041857
2019-10-03 16:47jfrancesIssue Monitored: jfrances
2019-10-08 15:02ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2019-10-08 15:12ranjith_qualiantech_comStatusnew => scheduled
2019-10-15 09:08ranjith_qualiantech_comFile Added: issue 41927 source posterminal.patch
2019-10-15 09:08ranjith_qualiantech_comFile Added: issue 41927 source returns.patch
2019-11-06 11:01hgbotCheckin
2019-11-06 11:01hgbotNote Added: 0115427
2019-11-06 11:01hgbotStatusscheduled => resolved
2019-11-06 11:01hgbotResolutionopen => fixed
2019-11-06 11:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/7ef40f856d8974627e2a05769f525a0547787416 [^]
2019-11-06 11:01hgbotCheckin
2019-11-06 11:01hgbotNote Added: 0115428
2019-11-06 11:01hgbotCheckin
2019-11-06 11:01hgbotNote Added: 0115429
2019-11-06 11:01hgbotCheckin
2019-11-06 11:01hgbotNote Added: 0115430
2019-11-07 14:17rafarodaIssue Monitored: rafaroda
2019-11-14 17:51marvintmReview Assigned To => marvintm
2019-11-14 17:51marvintmStatusresolved => closed
2019-11-14 17:51marvintmFixed in Version => RR20Q1
2020-04-24 12:08ngarciaRelationship addedrelated to 0043858
2023-03-30 11:47radhakrishnanAssigned Toranjith_qualiantech_com => radhakrishnan
2023-03-30 11:47radhakrishnanAssigned Toradhakrishnan => ranjith_qualiantech_com
2023-05-25 17:31eduardo_ArgalIssue Monitored: eduardo_Argal
2023-05-30 07:53marvintmRelationship addedrelated to 0052576

Notes
(0115427)
hgbot   
2019-11-06 11:01   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 7ef40f856d8974627e2a05769f525a0547787416
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Nov 06 15:30:25 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/7ef40f856d8974627e2a05769f525a0547787416 [^]

Fixed issue 41927 : Added Validation of PriceList when changing Customer

* When MultiPriceList is enabled, If Terminal PriceList's PriceIncludeTax or Currency
  is different from Customer PriceList's PriceIncludeTax or Currency,
  then receipt PriceList is updated with Terminal PriceList

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/retail/posterminal/master/BusinessPartnerProperties.java
M web/org.openbravo.retail.posterminal/js/components/businesspartner_selector.js
M web/org.openbravo.retail.posterminal/js/model/businesspartner.js
M web/org.openbravo.retail.posterminal/js/model/order.js
---
(0115428)
hgbot   
2019-11-06 11:01   
Repository: erp/pmods/org.openbravo.retail.returns
Changeset: 93892a166d14888b6c9507cd1bd185ff83e02e63
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Nov 06 15:30:43 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.returns/rev/93892a166d14888b6c9507cd1bd185ff83e02e63 [^]

Related to issue 41927 : Updated line priceIncludesTax when adding return lines

---
M web/org.openbravo.retail.returns/js/modalReturnLines.js
---
(0115429)
hgbot   
2019-11-06 11:01   
Repository: erp/pmods/org.openbravo.retail.sampledata
Changeset: 1736b252e06ed95bee1f276ef7589d8a47ae1b1c
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Nov 06 15:31:04 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/1736b252e06ed95bee1f276ef7589d8a47ae1b1c [^]

Related to issue 41927 : Added Product Price for VIP Pricelist

---
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCTPRICE.xml
---
(0115430)
hgbot   
2019-11-06 11:01   
Repository: tools/automation/pi-mobile
Changeset: 23a84e151f120d50012d0213f03f0a3d4ec8a423
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Nov 06 15:31:16 2019 +0530
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/23a84e151f120d50012d0213f03f0a3d4ec8a423 [^]

Verifies issue 41927 : Modified Automated Tests

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/allowNoPrice/ANPIMP010_ProductWithNoPriceInMainPricelistUsingBrowse.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/allowNoPrice/ANPIMP020_ProductWithNoPriceInMainPricelistUsingSearch.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/allowNoPrice/ANPIMP030_ProductWithNoPriceInMainPricelistUsingBestSeller.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/allowNoPrice/ANPIMP040_ProductWithNoPriceInMainPricelistUsingSearchBestSeller.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/allowNoPrice/ANPIMP050_ProductWithNoPriceInMainPricelistUsingSearchRemote.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/allowNoPrice/ANPIMP060_ProductWithNoPriceInMainPricelistUsingSearchRemoteBestSeller.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/customer/I39251_VerifyPriceWhenCustomerPriceListWasModified.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/highvolume/I35485_MplChangeDoesntTriggersEmptySearchs.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/I32217_MPLDiscretionaryPromotions.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/I32589_MPLEnablePreferenceCreateReceipt.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/I35061_ChangeCustomerWithSplitLines.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/I35101_ChangeCustomerWithSplitLinesPromotions.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLChangePriceLine.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLChangePriceList.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLDiscPromByPrice.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLDiscPromPrice.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLDiscountsWithoutPriceIncludeTaxes.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLEnablePreferences.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLLoadPrice.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLLoadPriceList.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLModifyPriceList.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLProductNoPriceList.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/MPLReceiptFromQuotation.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I32561_VerifyPriceListBasedOnCustomerPL.java
---