Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0045340 | Retail Modules | Web POS | public | 2020-10-30 09:44 | 2020-11-30 08:44 |
|
| Reporter | Leyre | |
| Assigned To | prakashmurugesan88 | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0045340: A Cross-Store sale can not be made if AWO Connector is defined |
| Description | With 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 Reproduce | Backend:
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 Solution | 1. 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 |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  Ticket_19071_Live.docx (1,031,818) 2020-10-30 09:44
https://issues.openbravo.com/file_download.php?file_id=15063&type=bug |
|
| 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 | bug_revision_view_page.php?rev_id=21840#r21840 |
| 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 | |