Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039600Retail ModulesWeb POSpublic2018-11-07 14:512019-04-15 16:19
Reporterngarcia 
Assigned Toguilleaer 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tojorge-garcia
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039600: AWO Retail Connector allows to get negative stock in a storage bin that does not allow overissue
DescriptionAWO Retail Connector allows to get negative stock in a storage bin that does not allow overissue
Steps To ReproduceHaving installed the following two modules:
   Openbravo AWO Retail Connector
   Web POS stock validation

In the backend:
   Set the Enable Stock Validation to Y
   Log out and log in

   Having the storage's warehouse configured for AWO:
      It should have at least two IRA and one storage bin on each IRA
      The storage bin should not allow negative stock (Their Inventory Status has OverIssue = 'N')

   Set one of the IRAs as Internal Routing Area for sales in POS Terminal window
   Create a product, add it in the store's assortment and price list
   Increase the product's stock in the storage bin that do not belong to the IRA assigned to the POS terminal. (The product will have stock in the store's warehouse but not in the store's IRA)

In the POS:
   Create a new ticket and add the previously created product
   You will be able to add it as it has stock in the store's warehouse. Should Web POS Stock validation module check the stock only from the IRA?

   Pay the ticket

In the backend:
   Check the product has been taken from the storage bin that belong to the IRA and there exists negative stock although it is not allowed
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0036213 closed jorge-garcia Adapt Web POS stock validation to support Inventory Status 
Attached Filesdocx Test POS goes negative.docx (845,816) 2018-11-14 11:54
https://issues.openbravo.com/file_download.php?file_id=12364&type=bug
Issue History
Date ModifiedUsernameFieldChange
2018-11-07 14:51ngarciaNew Issue
2018-11-07 14:51ngarciaAssigned To => Triage Finance
2018-11-07 14:51ngarciaOBNetwork customer => OBPS
2018-11-07 14:51ngarciaIssue Monitored: networkb
2018-11-07 14:52ngarciaResolution time => 1543359600
2018-11-07 14:52ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17901#r17901
2018-11-07 15:27guilleaerProjectModules => Retail Modules
2018-11-07 15:28guilleaerTriggers an Emergency Pack => No
2018-11-07 15:28guilleaerAssigned ToTriage Finance => Retail
2018-11-07 15:28guilleaerCategoryAdvance Warehouse Operations => Web POS
2018-11-08 09:28egoitzOBNetwork customerOBPS => Gold
2018-11-08 11:05ngarciaRelationship addedrelated to 0036213
2018-11-08 11:30galderromoIssue Monitored: galderromo
2018-11-09 17:50rqueraltaAssigned ToRetail => rqueralta
2018-11-14 11:50maarten1962Issue Monitored: maarten1962
2018-11-14 11:54maarten1962File Added: Test POS goes negative.docx
2018-11-14 11:55maarten1962Note Added: 0107904
2018-11-14 15:37hgbotCheckin
2018-11-14 15:37hgbotNote Added: 0107907
2018-11-14 15:37hgbotStatusnew => resolved
2018-11-14 15:37hgbotResolutionopen => fixed
2018-11-14 15:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.stockvalidation/rev/eb1b1065e01dc66e2fcefce6f0e31b71051d099c [^]
2018-11-15 09:35marvintmAssigned Torqueralta => guilleaer
2018-11-22 13:10jorge-garciaReview Assigned To => jorge-garcia
2018-11-22 13:10jorge-garciaNote Added: 0108055
2018-11-22 13:10jorge-garciaStatusresolved => closed
2019-04-15 16:19hgbotCheckin
2019-04-15 16:19hgbotNote Added: 0111144

Notes
(0107904)
maarten1962   
2018-11-14 11:55   
@Rafa: Please take a look at the attached document.
(0107907)
hgbot   
2018-11-14 15:37   
Repository: erp/pmods/org.openbravo.retail.stockvalidation
Changeset: eb1b1065e01dc66e2fcefce6f0e31b71051d099c
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Nov 14 15:37:31 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.stockvalidation/rev/eb1b1065e01dc66e2fcefce6f0e31b71051d099c [^]

Fixed Issue 39600: Take into account AWO retail connector configuration

When AWO retail connector is installed a portion of SQL is added to the queries executed by modules to get stock

---
M src/org/openbravo/retail/stockvalidation/OrderFromQuotationStockChecker.java
M src/org/openbravo/retail/stockvalidation/StockChecker.java
---
(0108055)
jorge-garcia   
2018-11-22 13:10   
Issue reviewed and tested
(0111144)
hgbot   
2019-04-15 16:19   
Repository: tools/automation/pi-mobile
Changeset: 8527935dbfc5d4ebfd6699ea54eac88b6f1b81c6
Author: Alejandro <alekosmp86 <at> gmail.com>
Date: Wed Apr 03 15:12:14 2019 -0400
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/8527935dbfc5d4ebfd6699ea54eac88b6f1b81c6 [^]

Related to issue 39600: added automated test

---
A src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/retailconnector/I39600_VerifyNegativeStockInStorageBinWithNoOverissue.java
---