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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0039600
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2018-11-07 14:512019-04-15 16:19
ReporterngarciaView Statuspublic 
Assigned Toguilleaer 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisioneb1b1065e01d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tojorge-garcia
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0039600: 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
TagsNo tags attached.
Attached Filesdocx file icon Test POS goes negative.docx [^] (845,816 bytes) 2018-11-14 11:54

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0036213 closedjorge-garcia Adapt Web POS stock validation to support Inventory Status 

-  Notes
(0107904)
maarten1962 (reporter)
2018-11-14 11:55

@Rafa: Please take a look at the attached document.
(0107907)
hgbot (developer)
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 (reporter)
2018-11-22 13:10

Issue reviewed and tested
(0111144)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2018-11-07 14:51 ngarcia New Issue
2018-11-07 14:51 ngarcia Assigned To => Triage Finance
2018-11-07 14:51 ngarcia Issue Monitored: networkb
2018-11-07 14:52 ngarcia Resolution time => 1543359600
2018-11-07 14:52 ngarcia Steps to Reproduce Updated View Revisions
2018-11-07 15:27 guilleaer Project Modules => Retail Modules
2018-11-07 15:28 guilleaer Triggers an Emergency Pack => No
2018-11-07 15:28 guilleaer Assigned To Triage Finance => Retail
2018-11-07 15:28 guilleaer Category Advance Warehouse Operations => Web POS
2018-11-08 11:05 ngarcia Relationship added related to 0036213
2018-11-08 11:30 galderromo Issue Monitored: galderromo
2018-11-09 17:50 rqueralta Assigned To Retail => rqueralta
2018-11-14 11:50 maarten1962 Issue Monitored: maarten1962
2018-11-14 11:54 maarten1962 File Added: Test POS goes negative.docx
2018-11-14 11:55 maarten1962 Note Added: 0107904
2018-11-14 15:37 hgbot Checkin
2018-11-14 15:37 hgbot Note Added: 0107907
2018-11-14 15:37 hgbot Status new => resolved
2018-11-14 15:37 hgbot Resolution open => fixed
2018-11-14 15:37 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.stockvalidation/rev/eb1b1065e01dc66e2fcefce6f0e31b71051d099c [^]
2018-11-15 09:35 marvintm Assigned To rqueralta => guilleaer
2018-11-22 13:10 jorge-garcia Review Assigned To => jorge-garcia
2018-11-22 13:10 jorge-garcia Note Added: 0108055
2018-11-22 13:10 jorge-garcia Status resolved => closed
2019-04-15 16:19 hgbot Checkin
2019-04-15 16:19 hgbot Note Added: 0111144


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker