Openbravo Issue Tracking System - Retail Modules
View Issue Details
0039921Retail ModulesAuto BOM For Retailpublic2019-01-10 17:502019-01-18 14:44
ngarcia 
jorge-garcia 
immediatemajoralways
closedfixed 
5
 
RR19Q2 
marvintm
No
0039921: Wrong M_STORAGE_DETAIL table if 'support for attributes' is set to N and a autobom product without stock is sell on POS
Wrong M_STORAGE_DETAIL table if 'support for attributes' is set to N and a autobom product without stock is sell on POS

As triggers are disabled, the M_STORAGE_DETAIL is not correctly updated
Note: the instance should be activated as it is needed to define a storage bin in Product - Manufacturing tab. It is hidden in livebuilds

In the backoffice:
   Leave the 'Web POS Enable support for product attributes' preference to N
   Create a new product
   Set it as Stocked, Bill Of Materials and Auto BOM For Retail
   Add it in the store's price list and assortment
   Assign an attribute set with Require At Least One Value to it
   Set a Storage Bin in Product - Manufacturing tab for the store

In the POS:
   Create a new ticket
   Add previously created product
   Pay it

In the backoffice:
   Go to Product - Transactions tab and check two transactions have been created there: a positive one related with the bill of materials production and a negative one related with the goods shipment

   Go to Product - Stock tab and check the Quantity On Hand is -1 and it should be 0
No tags attached.
Issue History
2019-01-10 17:50ngarciaNew Issue
2019-01-10 17:50ngarciaAssigned To => Retail
2019-01-10 17:50ngarciaTriggers an Emergency Pack => No
2019-01-10 17:51ngarciaIssue Monitored: networkb
2019-01-11 13:05marvintmStatusnew => scheduled
2019-01-11 13:05marvintmAssigned ToRetail => jorge-garcia
2019-01-17 09:50hgbotCheckin
2019-01-17 09:50hgbotNote Added: 0108990
2019-01-17 09:50hgbotStatusscheduled => resolved
2019-01-17 09:50hgbotResolutionopen => fixed
2019-01-17 09:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.autobom/rev/5f83463be03d877ed7ad05cab69a8e8f11197de3 [^]
2019-01-18 14:44marvintmReview Assigned To => marvintm
2019-01-18 14:44marvintmStatusresolved => closed
2019-01-18 14:44marvintmFixed in Version => RR19Q2

Notes
(0108990)
hgbot   
2019-01-17 09:50   
Repository: erp/pmods/org.openbravo.retail.autobom
Changeset: 5f83463be03d877ed7ad05cab69a8e8f11197de3
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Thu Jan 17 09:47:04 2019 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.autobom/rev/5f83463be03d877ed7ad05cab69a8e8f11197de3 [^]

Fixed issue 39921: Wrong M_STORAGE_DETAIL table if 'support for attributes'
is set to N and a autobom product without stock is sell on POS

The solution is to update the stock for auto BOM product using
m_update_inventory function.

---
M src/org/openbravo/retail/autobom/BOMProcess.java
---