Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0045340
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2020-10-30 09:442020-11-30 08:44
ReporterLeyreView Statuspublic 
Assigned Toprakashmurugesan88 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0045340: A Cross-Store sale can not be made if AWO Connector is defined

DescriptionWith the AWO Conector defined in the Touchpoint, only stock is selected from the same store (from the area that has been defined).

But if the Cross Store functionality is used, this is not correct.

StockChecker.java class only considers the store bin of the store and this is wrong if we use the cross store functionality:

if (useAWOConnector) {
hqlQuery += " and ms.storageBin.id in (";
hqlQuery += " select loc.id from Locator loc ";
hqlQuery += " where loc.oBAWOLocatorGroup <> null and loc.oBAWOLocatorGroup.active = true and loc.oBAWOLocatorGroup.internalRoutingArea.id = :iraid and loc.active = true and loc.oBAWOLocatorGroup.internalRoutingArea.active = true";
hqlQuery += ")";
}
Steps To ReproduceBackend:
1. Touchpoint VBS-1: Define an "Internal Routing Area for sales", in AWO Connector section.
2. Touchpoint VB-1: Define an "Internal Routing Area for sales", in AWO Connector section.
3. Configure correctly both warehouses: warehouse definition. See attached document.

Web POS:
1. Open the VBS-1 terminal:
2. Select a product
3. Check the Stock, and select Vall Boi Store
4. Click "Add to the Receipt"
Result: Error: Not enough stock.
Proposed Solution1. Easy but not 100% accurate solution:
Do not filter by Sales Area when the stock is selected from a Warehouse that belongs to a different Organization

2. 100% accurate solution:
When the stock belongs to a Warehouse of a different Organization:
  1. Check if there are terminals related to that Organization
  2. Check if those terminals have Sales Areas defined
  3. In that case, filter the stock by the Sales Areas defined for those terminals
  4. If not, do not filter and show all stock as available
TagsNo tags attached.
Attached Filesdocx file icon Ticket_19071_Live.docx [^] (1,031,818 bytes) 2020-10-30 09:44

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0124637)
hgbot (developer)
2020-11-27 05:19

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.stockvalidation/-/merge_requests/4 [^]
(0124665)
hgbot (developer)
2020-11-30 08:44

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.stockvalidation [^]
Changeset: 6de6ffad0d16093e6c4fe4fc2a6ee08b53616b25
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-11-27T16:52:04+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.stockvalidation/-/commit/6de6ffad0d16093e6c4fe4fc2a6ee08b53616b25 [^]

Fixed BUG-45340: Fixes Cross-Store sale cannot be made if AWO Connector is defined
* Validated with cross-store's sales area instead of terminal store

---
M src/org/openbravo/retail/stockvalidation/StockChecker.java
---
(0124666)
hgbot (developer)
2020-11-30 08:44

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.stockvalidation/-/merge_requests/4 [^]

- Issue History
Date Modified Username Field Change
2020-10-30 09:44 Leyre New Issue
2020-10-30 09:44 Leyre Assigned To => Retail
2020-10-30 09:44 Leyre Resolution time => 1605826800
2020-10-30 09:44 Leyre Triggers an Emergency Pack => No
2020-10-30 09:44 Leyre File Added: Ticket_19071_Live.docx
2020-10-30 09:44 Leyre Steps to Reproduce Updated View Revisions
2020-10-30 10:29 dmiguelez Proposed Solution updated
2020-11-23 11:14 gorka_gil Assigned To Retail => gorka_gil
2020-11-23 16:00 prakashmurugesan88 Assigned To gorka_gil => prakashmurugesan88
2020-11-24 07:57 prakashmurugesan88 Status new => scheduled
2020-11-27 05:19 hgbot Note Added: 0124637
2020-11-30 08:44 hgbot Resolution open => fixed
2020-11-30 08:44 hgbot Status scheduled => closed
2020-11-30 08:44 hgbot Note Added: 0124665
2020-11-30 08:44 hgbot Note Added: 0124666


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker