Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039921Retail ModulesAuto BOM For Retailpublic2019-01-10 17:502020-07-10 17:18
Reporterngarcia 
Assigned Tojorge-garcia 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039921: Wrong M_STORAGE_DETAIL table if 'support for attributes' is set to N and a autobom product without stock is sell on POS
DescriptionWrong 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
Steps To ReproduceNote: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0044596 closed ranjith_qualiantech_com Wrong M_STORAGE_DETAIL table when using AutoBOM with attributes and no stock 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-01-10 17:50ngarciaNew Issue
2019-01-10 17:50ngarciaAssigned To => Retail
2019-01-10 17:50ngarciaResolution time => 1548889200
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
2020-07-10 17:18gorkaionIssue cloned0044596
2020-07-10 17:18gorkaionRelationship addedrelated to 0044596

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
---